ｐｈｐ５２ - プログラム倉庫

<?php
require("calldata.php");
$sql = "SELECT * FROM eli09";
$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];
$m4[$year][$age]=$matrix[$n][3];
$f4[$year][$age]=$matrix[$n][4];
}

$sql = "SELECT * FROM eli10";
$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];
$m2[$year][$age]=$matrix[$n][3];
$f2[$year][$age]=$matrix[$n][4];
}

$sql = "SELECT * FROM eli49";
$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];
$m3[$year][$age]=$matrix[$n][3];
$f3[$year][$age]=$matrix[$n][4];
}

$sql = "SELECT * FROM eli50";
$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];
$m5[$year][$age]=$matrix[$n][3];
$f5[$year][$age]=$matrix[$n][4];
}

$sql = "SELECT * FROM eli51";
$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];
$m1[$year][$age]=$matrix[$n][3];
$f1[$year][$age]=$matrix[$n][4];
}

$sql = "SELECT * FROM eli48";
$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;
}
$maxn=$n;
for ($n=1;$n<$maxn;$n++){
$year=$matrix[$n][1];
$kiso[$year]=$matrix[$n][2];
}


for ($year=10;$year<100;$year++){
$px1=0;
for ($age=20;$age<60;$age++){
$px1=$px1+0.8*($m1[$year][$age]+$f1[$year][$age]);
$px1=$px1+$m2[$year][$age]+$f2[$year][$age];
$px1=$px1+$m3[$year][$age]+$f3[$year][$age];
$px1=$px1+$m4[$year][$age]+$f4[$year][$age];
$px1=$px1+$m5[$year][$age]+$f5[$year][$age];
}
$px2=0;
for ($age=20;$age<60;$age++){
$px2=$px2+$m2[$year][$age]+$f2[$year][$age];
$px2=$px2+$m3[$year][$age]+$f3[$year][$age];
}
$kyo[$year]=$kiso[$year]*$px2/$px1;
}

$sql = "truncate eli52";
$exe= mysql_query($sql,$link);
for ($year=10;$year<100;$year++){
$x=$kyo[$year];
$sql = "insert into eli52 values($year,$x)";
$exe= mysql_query($sql,$link);
}
$close_flag = mysql_close($link);
print("52 基礎年金拠出金 計算終了");
?>