<?php
$handle = fopen("data10.csv", "r");
$n = 1;
while (($csvdata = fgetcsv($handle, 1000, ",")) !== FALSE) {
for ($c=0; $c < 4; $c++) {
$data[$n] = $csvdata[$c];
$n = $n +1;
}
}
fclose($handle);
for ($t=1; $t < 56 ; $t++) {
$n=4*($t-1)+1;
$age = $data[$n];
$gamma[$age]= $data[$n+1];
$alpha[$age]= $data[$n+2];
$beta[$age]= $data[$n+3];
}
require("calldata.php");
$sql = "truncate pdata10";
$exe= mysql_query($sql,$link);
for ($age=15;$age<70;$age++){
$x=$gamma[$age];
$y=$alpha[$age];
$z=$beta[$age];
$sql = "insert into pdata10 values($age,$x,$y,$z)";
$exe= mysql_query($sql,$link);
}
$close_flag = mysql_close($link);
for ($age=15; $age < 69; $age++) {
print($gamma[$age]);
print(",");
print($alpha[$age]);
print(",");
print($beta[$age]);
print(",");
}
$age=69;
print($gamma[$age]);
print(",");
print($alpha[$age]);
print(",");
print($beta[$age]);
?>
最終更新:2009年06月14日 04:26