<?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];
}
for ($year=10;$year<100;$year++){
$ch=1;
if ($year<50)$ch = 1.05 - 0.05 * ($year - 10) / 40;
for ($age=65;$age<100;$age++){
$kiso[$year][$age]=($m[$year][$age]+$f[$year][$age])/$ch;
}
}
$sql = "truncate eli47";
$exe= mysql_query($sql,$link);
for ($year=10;$year<100;$year++){
for ($age=65;$age<100;$age++){
$x=$kiso[$year][$age];
$sql = "insert into eli47 values($year,$age,$x)";
$exe= mysql_query($sql,$link);
}
}
$close_flag = mysql_close($link);
print("47 基礎年金受給者 計算終了")
?>
最終更新:2010年08月21日 23:23