アットウィキロゴ

data01

<?php  
$handle = fopen("data01.csv", "r");
$n = 1;
while (($csvdata = fgetcsv($handle, 1000, ",")) !== FALSE) {  
    for ($c=0; $c < 3; $c++) {
$data[$n] = $csvdata[$c];
$n = $n +1;      
}
}
fclose($handle);
for ($t=1; $t < 124; $t++) {
$n=3*($t-1)+1;
$k[$t] = $data[$n];
$mk[$t]= $data[$n+1];
$fk[$t]= $data[$n+2];
}

require("calldata.php");

for ($age=0;$age<100;$age++){
$skip=floor($age/5)+3;
$startm[$age]=$mk[$age+$skip]/10000;
$startf[$age]=$fk[$age+$skip]/10000;
}

$sql = "truncate pdata01";
$exe= mysql_query($sql,$link);
for ($age=0;$age<100;$age++){
$x=$startm[$age];
$y=$startf[$age];
$sql = "insert into pdata01 values($age,$x,$y)";
$exe= mysql_query($sql,$link);
}
$close_flag = mysql_close($link);
for ($age=0;$age<99;$age++){
print($startm[$age]);
print(",");
print($startf[$age]);
print(",");
}
$age=99;
print($startm[$age]);
print(",");
print($startf[$age]);
?>
最終更新:2009年06月20日 09:40