<?php
$handle = fopen("data06.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];
$rate[$year]= $data[$n+1];
}
require("calldata.php");
$sql = "truncate pdata06";
$exe= mysql_query($sql,$link);
for ($year=5;$year<100;$year++){
$x=$rate[$year];
$sql = "insert into pdata06 values($year,$x)";
$exe= mysql_query($sql,$link);
}
$close_flag = mysql_close($link);
for ($year=5; $year < 99; $year++) {
print($rate[$year]);
print(",");
}
$year=99;
print($rate[$year]);
?>
最終更新:2009年06月14日 04:16