アットウィキロゴ

PHP49

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

$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 data0902";
$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];
$zm2[$year][$age] = $matrix[$n][3];
$zf2[$year][$age] = $matrix[$n][4];  
}

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



for ($age=20;$age<60;$age++){
$rate[$age]=$zf3[8][$age]/$zm2[8][$age];
}


for ($year=10;$year<100;$year++){
$ch = 1.3;
If ($year < 30)$ch = 1.3 + 0.18 * ($year - 30) / 25;
for ($age=20;$age<60;$age++){
$f3[$year][$age]=$rate[$age]*$m2[$year][$age]/$ch;
}
}

$sql = "truncate eli49";
$exe= mysql_query($sql,$link);
for ($year=10;$year<100;$year++){
for ($age=20;$age<60;$age++){
$x=$f3[$year][$age];
$sql = "insert into eli49 values($year,$age,$x)";
$exe= mysql_query($sql,$link);
}
}
$close_flag = mysql_close($link);
print("49 厚生3号被保険者 計算終了");
?>
最終更新:2010年09月08日 19:59