pjp05 - プログラム倉庫

<?php
$handle = fopen("data04.csv", "r");
$n = 1;
while (($csvdata = fgetcsv($handle,100000,",")) !== FALSE) {  
for ($c=0; $c < 4; $c++) {
$data[$n] = $csvdata[$c];
$n = $n +1;
}
}
fclose($handle);

require("calldata.php");

$sql = "truncate egdata04";
$exe= mysql_query($sql,$link);
for ($n=1;$n<10001;$n++){
$year=$data[4*$n-3];
$age=$data[4*$n-2];
$x=$data[4*$n-1];
$y=$data[4*$n];
$sql = "insert into egdata04 values($year,$age,$x,$y)";
$exe= mysql_query($sql,$link);
}
$close_flag = mysql_close($link);
?>