php06 - プログラム倉庫

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

$sql = "SELECT * FROM pgdata05";
$result = mysql_query($sql, $link);
$n=1;
while( $row = mysql_fetch_row( $result ) ){
$matrix[$n][1] = $row[0];
$matrix[$n][2]  =$row[1];
$matrix[$n][3]  =$row[2];
$matrix[$n][4]  =$row[3];
$n=$n+1;
}
for ($n=1; $n < 5501; $n++) {
$year =$matrix[$n][1];
$age =$matrix[$n][2];
$m2[$year][$age] = $matrix[$n][3];
$f2[$year][$age] = $matrix[$n][4];
}

$sql = "SELECT * FROM pdata09";
$result = mysql_query($sql, $link);
$n=1;
while( $row = mysql_fetch_row( $result ) ){
$matrix[$n][1] = $row[0];
$matrix[$n][2]  =$row[1];
$matrix[$n][3]  =$row[2];
$n=$n+1;
}
for ($n=1; $n < 56; $n++) {
$age =$matrix[$n][1];
$mw[$age] = $matrix[$n][2];
$fw[$age] = $matrix[$n][3];
}

$sql = "SELECT * FROM pdata06";
$result = mysql_query($sql, $link);
$n=1;
while( $row = mysql_fetch_row( $result ) ){
$matrix[$n][1] = $row[0];
$matrix[$n][2]  =$row[1];
$n=$n+1;
}
for ($n=1; $n < 96; $n++) {
$year =$matrix[$n][1];
$rate[$year] = $matrix[$n][2];
}

$sql = "SELECT * FROM pdata07";
$result = mysql_query($sql, $link);
$n=1;
while( $row = mysql_fetch_row( $result ) ){
$matrix[$n][1] = $row[0];
$matrix[$n][2]  =$row[1];
$n=$n+1;
}
for ($n=1; $n < 96; $n++) {
$year =$matrix[$n][1];
$p[$year] = $matrix[$n][2];
}

$sql = "SELECT * FROM pdata08";
$result = mysql_query($sql, $link);
$n=1;
while( $row = mysql_fetch_row( $result ) ){
$matrix[$n][1] = $row[0];
$matrix[$n][2]  =$row[1];
$n=$n+1;
}
for ($n=1; $n < 96; $n++) {
$year =$matrix[$n][1];
$g[$year] = $matrix[$n][2];
}
$wage[5]=1;
for ($year=6; $year < 100; $year++) {
$wage[$year]=(1+0.01*$p[$year-1]+0.01*$g[$year-1])*$wage[$year-1];
}
for ($year=5; $year < 100; $year++) {
$re=0;
for ($age=15; $age < 70; $age++) {
$re=$re+250*$wage[$year]*$mw[$age]*$m2[$year][$age];
$re=$re+220*$wage[$year]*$fw[$age]*$f2[$year][$age];
}
$rev[$year]=$rate[$year]*$re/pow(10,6);
}
$sql = "truncate pgdata06";
$exe= mysql_query($sql,$link);

for ($year=5;$year<100;$year++){
$x=$rev[$year];
$sql = "insert into pgdata06 values($year,$x)";
$exe= mysql_query($sql,$link);
}
$close_flag = mysql_close($link);
$today = date("H:i:s");
print($today);
print(",");
for ($year=5; $year < 90; $year++) {
print($rev[$year]);
print(",");
}
$year=90;
print($rev[$year]);
?>