php51 - プログラム倉庫

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

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


$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];
$n=$n+1;
}
$maxn=$n;
for ($n=1; $n < $maxn; $n++) {
$year =$matrix[$n][1];
$age =$matrix[$n][2];  
$f3[$year][$age] = $matrix[$n][3];
}

$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];
$n=$n+1;
}
$maxn=$n;
for ($n=1; $n < $maxn; $n++) {
$year =$matrix[$n][1];
$age =$matrix[$n][2];  
$f4[$year][$age] = $matrix[$n][3];
}


for ($year=10;$year<100;$year++){
for ($age=20;$age<60;$age++){
$m1[$year][$age] =$m[$year][$age]-$m2[$year][$age]-$m4[$year][$age];
$f1[$year][$age] =$f[$year][$age]-$f2[$year][$age]-$f4[$year][$age]-$f3[$year][$age]-$f5[$year][$age];
}
}

$sql = "truncate eli51";
$exe= mysql_query($sql,$link);
for ($year=10;$year<100;$year++){
for ($age=20;$age<60;$age++){
$x=$m1[$year][$age];
$y=$f1[$year][$age];
$sql = "insert into eli51 values($year,$age,$x,$y)";
$exe= mysql_query($sql,$link);
}
}
$close_flag = mysql_close($link);
print("51 国民年金被保険者 計算終了");
?>