ＰＨＰ６０ - プログラム倉庫

<?php
require("calldata.php");
$sql = "SELECT * FROM plan";
$result = mysql_query($sql, $link);
while( $row = mysql_fetch_row( $result ) ){
$plan = $row[0];  
}  

$sql = "SELECT * FROM policy";
$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++){
$num=$matrix[$n][1];
$px1[$num]=$matrix[$n][2];
$px2[$num]=$matrix[$n][3];
$px3[$num]=$matrix[$n][4];
}

$p = $px1[$plan];
$g = $px2[$plan];  
$r=  $px3[$plan];

$sql = "SELECT * FROM eli53";
$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];  
$rou[$year] = $matrix[$n][2];  
}

$sql = "SELECT * FROM eli54";
$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];  
$tu[$year] = $matrix[$n][2];  
}

$sql = "SELECT * FROM eli52";
$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];  
$kyo[$year] = $matrix[$n][2];  
}

$sql = "SELECT * FROM eli14";
$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];  
$rev[$year] = $matrix[$n][2];  
}

$sql = "SELECT * FROM eli55";
$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];  
$iz[$year] = $matrix[$n][2];  
}

for ($year=10;$year<100;$year++){
$exp[$year]=$rou[$year]+$tu[$year]+$iz[$year];
}

$sql = "SELECT * FROM eli57";
$result = mysql_query($sql, $link);
$n=1;
while( $row = mysql_fetch_row( $result ) ){
$matrix[$n][1] = $row[0];
$matrix[$n][5]  =$row[4];
$n=$n+1;
}
$maxn=$n;
for ($n=1; $n < $maxn; $n++) {
$year =$matrix[$n][1];  
$koku[$year] = $matrix[$n][5];  
}

for ($year=10;$year<100;$year++){
$exp[$year]=$rou[$year]+$tu[$year]+$iz[$year];
}

$r1=1;
$e1=0;
$e2=0;
$e3=0;
$e4=0;
for ($year=10;$year<100;$year++){
$e1=$e1+$exp[$year]*$r1;
$e2=$e2+$kyo[$year]*$r1;
$e3=$e3+$rev[$year]*$r1;
$e4=$e4+$koku[$year]*$r1;
$r1=$r1/(1+$r);
}

print($e1);
print("<br>");
print($e2);
print("<br>");
print($e3);
print("<br>");
print($e4);
print("<br>");
$close_flag = mysql_close($link);
print("60 給付現価 計算終了");
?>