php50 - プログラム倉庫

<?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 data0904";
$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];
$zm4[$year][$age] = $matrix[$n][3];
$zf4[$year][$age] = $matrix[$n][4];  
}

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

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

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

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

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

for ($age=15;$age<70;$age++){
$rate[$age]=($zf5[8][$age]+$zf7[8][$age]+$zf9[8][$age])/(0.0001+$zm4[8][$age]+$zm6[8][$age]+$zm8[8][$age]);
}

for ($year=10;$year<100;$year++){
$ch=1.3;
if($year<25)$ch=1.3 + 0.25 * ($year - 25) / 20;
for ($age=20;$age<60;$age++){
$f5[$year][$age]=$rate[$age]*$m4[$year][$age]/$ch;
}
}

$sql = "truncate eli50";
$exe= mysql_query($sql,$link);
for ($year=10;$year<100;$year++){
for ($age=20;$age<60;$age++){
$x=$f5[$year][$age];
$sql = "insert into eli50 values($year,$age,$x)";
$exe= mysql_query($sql,$link);
}
}
$close_flag = mysql_close($link);
print("50 共済3号被保険者 計算終了");
?>