Archief - CVS file uploaden & in database zetten.

<?php 
include ('mysql.php');
$filename = "Materiaal.cvs";
$fp = fopen($filename, "w");

$res = mysql_query("SELECT * FROM materiaal");

// fetch a row and write the column names out to the file
$row = mysql_fetch_assoc($res);
$line = "";
$comma = "";
foreach($row as $name => $value) {
    $line .= $comma . '"' . str_replace('"', '""', $name) . '"';
    $comma = ",";
}
$line .= "\n";
fputs($fp, $line);

// remove the result pointer back to the start
mysql_data_seek($res, 0);

// and loop through the actual data
while($row = mysql_fetch_assoc($res)) {
   
    $line = "";
    $comma = "";
    foreach($row as $value) {
        $line .= $comma . '"' . str_replace('"', '""', $value) . '"';
        $comma = ",";
    }
    $line .= "\n";
    fputs($fp, $line);
   
}
readfile($filename);
fclose($fp);
?>

<?php $row = 1;
$fp = fopen ("leerlingenlijst.CSV","r");
while ($data = fgetcsv ($fp, ",")) {
    $num = count ($data);
    print "<p> $num velden in regel $row: <br>";
    $row++;
    for ($c=0; $c < $num; $c++) {
        print $data[$c] . "<br>";
    }
}
fclose ($fp);
?>