data4 - プログラム倉庫

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

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

while( $row = mysql_fetch_row( $result ) ){
$m = $row[0];
$n = $row[1];
$data[$m][$n] = $row[2];
}

$close_flag = mysql_close($link);

for ($m=1;$m<12;$m++){
$mx[$m][1]=$data[$m][1];
$mx[$m][2]=$data[$m][2];
$mx[$m][3]=$data[$m][3];
$fx[$m][1]=$data[$m][4];
$fx[$m][2]=$data[$m][5];
$fx[$m][3]=$data[$m][6];
}
$age=15;
$my[$age][1]=0.6*$mx[1][1];
$my[$age][2]=0.6*$mx[1][2];
$my[$age][3]=0.6*$mx[1][3];
$fy[$age][1]=0.6*$fx[1][1];
$fy[$age][2]=0.6*$fx[1][2];
$fy[$age][3]=0.6*$fx[1][3];
$age=16;
$my[$age][1]=0.8*$mx[1][1];
$my[$age][2]=0.8*$mx[1][2];
$my[$age][3]=0.8*$mx[1][3];
$fy[$age][1]=0.8*$fx[1][1];
$fy[$age][2]=0.8*$fx[1][2];
$fy[$age][3]=0.8*$fx[1][3];
for ($age=17;$age<67;$age++){
$n1=($age-12)/5;
$n2=floor($n1);
$n3=$n2+1;
$my[$age][1]=$mx[$n2][1]+($n1-$n2)*($mx[$n3][1]-$mx[$n2][1]);
$my[$age][2]=$mx[$n2][2]+($n1-$n2)*($mx[$n3][2]-$mx[$n2][2]);
$my[$age][3]=$mx[$n2][3]+($n1-$n2)*($mx[$n3][3]-$mx[$n2][3]);
$fy[$age][1]=$fx[$n2][1]+($n1-$n2)*($fx[$n3][1]-$fx[$n2][1]);
$fy[$age][2]=$fx[$n2][2]+($n1-$n2)*($fx[$n3][2]-$fx[$n2][2]);
$fy[$age][3]=$fx[$n2][3]+($n1-$n2)*($fx[$n3][3]-$fx[$n2][3]);
}
$age=69;
$my[$age][1]=0.6*$mx[11][1];
$my[$age][2]=0.6*$mx[11][2];
$my[$age][3]=0.6*$mx[11][3];
$fy[$age][1]=0.6*$fx[11][1];
$fy[$age][2]=0.6*$fx[11][2];
$fy[$age][3]=0.6*$fx[11][3];
$age=67;
$my[$age][1]=$mx[11][1];
$my[$age][2]=$mx[11][2];
$my[$age][3]=$mx[11][3];
$fy[$age][1]=$fx[11][1];
$fy[$age][2]=$fx[11][2];
$fy[$age][3]=$fx[11][3];
$age=68;
$my[$age][1]=0.8*$mx[11][1];
$my[$age][2]=0.8*$mx[11][2];
$my[$age][3]=0.8*$mx[11][3];
$fy[$age][1]=0.8*$fx[11][1];
$fy[$age][2]=0.8*$fx[11][2];
$fy[$age][3]=0.8*$fx[11][3];
for ($year=0;$year<10;$year++){
for ($age=15;$age<70;$age++){
$n1=$year/10;
$n2=floor($n1);
$n3=$n2+1;
$mrate[$year][$age]=$my[$age][1]+($n1-$n2)*($my[$age][2]-$my[$age][1]);
$frate[$year][$age]=$fy[$age][1]+($n1-$n2)*($fy[$age][2]-$fy[$age][1]);
}
}
for ($year=10;$year<25;$year++){
for ($age=15;$age<70;$age++){
$n1=($year-10)/15;
$n2=floor($n1);
$n3=$n2+1;
$mrate[$year][$age]=$my[$age][2]+($n1-$n2)*($my[$age][3]-$my[$age][2]);
$frate[$year][$age]=$fy[$age][2]+($n1-$n2)*($fy[$age][3]-$fy[$age][2]);
}
}
for ($year=25;$year<100;$year++){
for ($age=15;$age<70;$age++){
$mrate[$year][$age]=$my[$age][3];
$frate[$year][$age]=$fy[$age][3];
}
}
$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 pdata04";
$exe= mysql_query($sql,$link);
for ($year=0;$year<100;$year++){
for ($age=15;$age<70;$age++){
$x1=$mrate[$year][$age];
$x2=$frate[$year][$age];
$sql = "insert into pdata04 values($year,$age,$x1,$x2)";
$exe= mysql_query($sql,$link);
}
}
$close_flag = mysql_close($link);
if ($close_flag){
}
$today = date("H:i:s");
print($today);
print(",");
for ($year=0; $year < 99; $year++) {
for ($age=15; $age < 70; $age++) {
print($mrate[$year][$age]);
print(",");
print($frate[$year][$age]);
print(",");
}
}
$year=99;
for ($age=15; $age < 69; $age++) {
print($mrate[$year][$age]);
print(",");
print($frate[$year][$age]);
print(",");
}
$age=69;
print($mrate[$year][$age]);
print(",");
print($frate[$year][$age]);
?>