７ ７ - プログラム倉庫

<?php  
$handle = fopen("data07.csv", "r");
$n = 1;
while (($csvdata = fgetcsv($handle, 1000, ",")) !== FALSE) {  
for ($c=0; $c < 2; $c++) {
$data[$n] = $csvdata[$c];
$n = $n +1;      
}
}
fclose($handle);
for ($t=1; $t < 96 ; $t++) {
$n=2*($t-1)+1;
$year = $data[$n];
$g[$year]= $data[$n+1];
}

require("calldata.php");

$sql = "truncate pdata07";
$exe= mysql_query($sql,$link);
for ($year=5;$year<100;$year++){
$x=$g[$year];
$sql = "insert into pdata07 values($year,$x)";
$exe= mysql_query($sql,$link);
}
$close_flag = mysql_close($link);
for ($year=5; $year < 99; $year++) {
print($g[$year]);
print(",");
}
$year=99;
print($g[$year]);
?>