Dieser Code kommt in dieser File DB.php
Code:
Code: Alles auswählen
<?php
$host = 'localhost';
$user = 'root';
$password = '';
$connect = mysql_connect($host, $user, $password) or die(mysql_error());
$db = mysql_select_db("csv");
?>
Code:
Code: Alles auswählen
<?php
require 'DB.php';
$file = file('restauran.csv');
foreach($file as $fh)
{
//$info = fgetcsv($fh,1048576,';');
$info = explode(";", $fh);
$test= "INSERT INTO gericht (gerichtname , preis , ist_scharf )VALUES ('$info[0]', $info[1], $info[2])";
$result = mysql_query($test);
//echo $test;
print "$info[0], ";
print "$info[1], ";
print "$info[2] eingefügt<br>";
}
?>