ｐｈｐ０９ - プログラム倉庫

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

$sql = "SELECT * FROM eli08";
$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;
}
$maxn=$n;
for ($n=1; $n < $maxn; $n++) {
$year =$matrix[$n][1];
$age =$matrix[$n][2];
$mh[$year][$age] = $matrix[$n][3];
$fh[$year][$age] = $matrix[$n][4];  
}

$sql = "SELECT * FROM data91";
$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;
}
$maxn=$n;
for ($n=1; $n < $maxn; $n++) {
$age =$matrix[$n][1];
$x91[$age] = $matrix[$n][2];
$x92[$age] = $matrix[$n][3];  
}

$sql = "SELECT * FROM data92";
$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;
}
$maxn=$n;
for ($n=1; $n < $maxn; $n++) {
$age =$matrix[$n][1];
$x93[$age] = $matrix[$n][2];
$x94[$age] = $matrix[$n][3];  
}


for ($year=8;$year<25;$year++){
$cho[$year]= 1 + 0.2 * ($year - 5) / 20;
}

for ($year=25;$year<100;$year++){
$cho[$year]= 1.2;
}

for ($age=15;$age<70;$age++){
$m4rate[$age]=$x93[$age]/($x91[$age]+$x93[$age]);
$f4rate[$age]=$x94[$age]/($x92[$age]+$x94[$age]);
}


for ($year=8;$year<100;$year++){
for ($age=15;$age<70;$age++){
$m4[$year][$age]=$m4rate[$age]*$mh[$year][$age]/$cho[$year];
$f4[$year][$age]=$f4rate[$age]*$fh[$year][$age]/$cho[$year];
}
}

$sql = "truncate eli09";
$exe= mysql_query($sql,$link);
for ($year=8;$year<100;$year++){
for ($age=15;$age<70;$age++){
$x=$m4[$year][$age];
$y=$f4[$year][$age];
$sql = "insert into eli09 values($year,$age,$x,$y)";
$exe= mysql_query($sql,$link);
}
}
$close_flag = mysql_close($link);
print("09 共済年金被保険者 計算終了");
?>