プログラム倉庫 - php02

<?php
require("calldata.php");

$sql = "SELECT * FROM pgdata01";
$result = mysql_query($sql, $link);

while( $row = mysql_fetch_row( $result ) ){
$year = $row[0];
$age = $row[1];
$m[$year][$age] =$row[2];
$f[$year][$age] =$row[3];
}

$sql = "SELECT * FROM pdata04";
$result = mysql_query($sql, $link);

while( $row = mysql_fetch_row( $result ) ){
$year = $row[0];
$age = $row[1];
$mrate[$year][$age] =$row[2];
$frate[$year][$age] =$row[3];
}

for ($year=0;$year<100;$year++){
for ($age=15;$age<70;$age++){
$mrou[$year][$age]=0.01*$mrate[$year][$age]*$m[$year][$age];
$frou[$year][$age]=0.01*$frate[$year][$age]*$f[$year][$age];
}
}

$sql = "truncate pgdata02";
$exe= mysql_query($sql,$link);

for ($year=0;$year<100;$year++){
for ($age=15;$age<70;$age++){
$x1=$mrou[$year][$age];
$x2=$frou[$year][$age];
$sql = "insert into pgdata02 values($year,$age,$x1,$x2)";
$exe= mysql_query($sql,$link);
}
}
$close_flag = mysql_close($link);
$today = date("H:i:s");
print($today);
print(",");
for ($year=0; $year < 99; $year++) {
for ($age=15; $age < 70; $age++) {
print($mrou[$year][$age]);
print(",");
print($frou[$year][$age]);
print(",");
}
}
$year=99;
for ($age=15; $age < 69; $age++) {
print($mrou[$year][$age]);
print(",");
print($frou[$year][$age]);
print(",");
}
$age=69;
print($mrou[$year][$age]);
print(",");
print($frou[$year][$age]);
?>