| Autor | Zpráva | ||
|---|---|---|---|
| jtfcobra Profil |
Ahoj poradite s ukladanim CSV do db mam tam chybu vypis jde ale ulozeni nejde
Takle mi to udela aspon vypis < <?php
echo "<html><body><table>\n\n";
$f = fopen("test.csv", "r");
while (($line = fgetcsv($f)) !== false) {
echo "<tr>";
foreach ($line as $cell) {
echo "<td bgcolor='#CDE51A'>" . htmlspecialchars($cell) . "</td>";
}
echo "</tr>\n";
}
fclose($f);
echo "\n</table></body></html>";
?Takle to nefunguje <?php
require_once('Connections/connect.php');
$mysqli = new mysqli($hostname_test, $username_test, $password_test,$database_test);
$fh = fopen("test.csv", "r");
while ($line = fgetcsv($fh, 1000, ","))
{
$a1 = $line[10];
$a2 = $line[11];
$a3 = $line[12];
$a4 = $line[15];
$a5 = $line[16];
$a6 = $line[17];
$a7 = $line[18];
// Vlozeni do DB
$query = "INSERT INTO sklad (sklad, produkt, nazev,sarze,expirace,mnoztvi,jednotka) VALUES ('$a1','$a2','$a3','$a4''$a5','$a6','$a7')";
$result = $mysqli->query($query);
}
fclose($fh);
$mysqli->close();
?>Vyreseno prosim smazat |
||
|
Časová prodleva: 10 let
|
|||
0