pdata05 - プログラム倉庫

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

$sql = "SELECT * FROM ordata05";
$result = mysql_query($sql, $link);

while( $row = mysql_fetch_row( $result ) ){
$n = $row[0];
$mh[$n] =$row[1];
$fh[$n] =$row[2];
}
$close_flag = mysql_close($link);
for ($age=20;$age<60;$age++){
$n1=$age/5-3;
$n2=floor($n1);
$n3=$n2+1;
$mhr[$age]=$mh[$n2]+($n1-$n2)*($mh[$n3]-$mh[$n2]);
$fhr[$age]=$fh[$n2]+($n1-$n2)*($fh[$n3]-$fh[$n2]);
}
for ($age=60;$age<70;$age++){
$n1=$age/5-3;
$n2=floor($n1);
$n3=$n2+1;
$mhr[$age]=$mh[9]*(70-$age)/10;
$fhr[$age]=$fh[9]*(70-$age)/10;
}
for ($age=20;$age<30;$age++){
$mhp[$age]=$mhr[$age];
$fhp[$age]=$fhr[$age];
}
for ($age=30;$age<60;$age++){
$mhp[$age]=0.76;
$fhp[$age]=$mhp[$age]/$mhr[$age]*$fhr[$age];
}
for ($age=60;$age<70;$age++){
$mhp[$age]=0.76/0.7*$mhr[$age];
$fhp[$age]=$mhp[$age]/$mhr[$age]*$fhr[$age];
}
for ($byear=1931;$byear<1970;$byear++){
$startage=2000-$byear;
for ($age=$starage;$age<70;$age++){
$year=$age+($byear-2000);
$mhrate[$year][$age]=$mhr[$age]+($byear-1931)*($mhp[$age]-$mhr[$age])/40;
$fhrate[$year][$age]=$fhr[$age]+($byear-1931)*($fhp[$age]-$fhr[$age])/40;
}
}
for ($byear=1970;$byear<2080;$byear++){
$startage=2000-$byear;
if ($startage<20){
$startage=20;
}
$endage=2099-$byear;
if ($endage>70){
$endage=69;
}
for ($age=$starage;$age<$endage+1;$age++){
$year=$age+($byear-2000);
$mhrate[$year][$age]=$mhp[$age];
$fhrate[$year][$age]=$fhp[$age];
}
}
for ($year=0;$year<100;$year++){
for ($age=15;$age<20;$age++){
$mhrate[$year][$age]=$mhrate[$year][20];
$fhrate[$year][$age]=$fhrate[$year][20];
}
}
$link = mysql_connect('localhost', 'ce00582', '5fad05caada025b2fac0');
if (!$link) {
    die('接続失敗です。'.mysql_error());
}

$db_selected = mysql_select_db('db0ce00582', $link);
if (!$db_selected){
    die('データベース選択失敗です。'.mysql_error());
}

$sql = "truncate pdata05";
$exe= mysql_query($sql,$link);

for ($year=0;$year<100;$year++){
for ($age=15;$age<70;$age++){
$x1=$mhrate[$year][$age];
$x2=$fhrate[$year][$age];
$sql = "insert into pdata05 values($year,$age,$x1,$x2)";
$exe= mysql_query($sql,$link);
}
}
$close_flag = mysql_close($link);
$today = date("H:i:s");
print($today);
print(",");
for ($year=0; $year < 99; $year++) {
for ($age=20; $age < 70; $age++) {
print($mhrate[$year][$age]);
print(",");
print($fhrate[$year][$age]);
print(",");
}
}
$year=99;
for ($age=20; $age < 69; $age++) {
print($mhrate[$year][$age]);
print(",");
print($fhrate[$year][$age]);
print(",");
}
$age=69;
print($mhrate[$year][$age]);
print(",");
print($fhrate[$year][$age]);
?>