php69 - プログラム倉庫

<?php  
require("calldata.php");
$sql = "SELECT * FROM data05";
$result = mysql_query($sql, $link);
$n=1;
while( $row = mysql_fetch_row( $result ) ){
$matrix[$n][1] = $row[0];
$n=$n+1;
}
for ($n=1;$n<12;$n++){
$mrate[1][$n]= $matrix[4+8 *($n - 1)+1][1];
$mrate[2][$n]= $matrix[4+8 *($n - 1)+2][1];
$mrate[3][$n]= $matrix[4+8 *($n - 1)+3][1];
$mrate[4][$n]= $matrix[4+8 *($n - 1)+4][1];
}

for ($n=1;$n<12;$n++){
$wrate[1][$n]= $matrix[92+8 *($n - 1)+1][1];
$wrate[2][$n]= $matrix[92+8 *($n - 1)+2][1];
$wrate[3][$n]= $matrix[92+8 *($n - 1)+3][1];
$wrate[4][$n]= $matrix[92+8 *($n - 1)+4][1];
}

for ($n=1;$n<12;$n++){
$drate[1][$n]= $matrix[180+8 *($n - 1)+1][1];
$drate[2][$n]= $matrix[180+8 *($n - 1)+2][1];
$drate[3][$n]= $matrix[180+8 *($n - 1)+3][1];
$drate[4][$n]= $matrix[180+8 *($n - 1)+4][1];
}


for ($year=6;$year<12;$year++){
for ($age=15;$age<70;$age++){
$n1 = ($year - 6) / 6 ;
$n2 =floor(($age - 10) / 5);
$mrourate[$year][$age] = $mrate[1][$n2] + $n1 * ($mrate[2][$n2]  - $mrate[1][$n1] );
$wrourate[$year][$age] = $wrate[1][$n2] + $n1 * ($wrate[2][$n2]  - $wrate[1][$n1] );
$drourate[$year][$age] = $drate[1][$n2] + $n1 * ($drate[2][$n2]  - $drate[1][$n1] );
}
}

for ($year=7;$year<18;$year++){
for ($age=15;$age<70;$age++){
$n1 = ($year - 12) / 6 ;
$n2 =floor(($age - 10) / 5);
$mrourate[$year][$age] = $mrate[2][$n2] + $n1 * ($mrate[3][$n2]  - $mrate[2][$n1] );
$wrourate[$year][$age] = $wrate[2][$n2] + $n1 * ($wrate[3][$n2]  - $wrate[2][$n1] );
$drourate[$year][$age] = $drate[2][$n2] + $n1 * ($drate[3][$n2]  - $drate[2][$n1] );
}
}

for ($year=18;$year<30;$year++){
for ($age=15;$age<70;$age++){
$n1 = ($year - 18) / 12 ;
$n2 =floor(($age - 10) / 5);
$mrourate[$year][$age] = $mrate[3][$n2] + $n1 * ($mrate[4][$n2]  - $mrate[3][$n1] );
$wrourate[$year][$age] = $wrate[3][$n2] + $n1 * ($wrate[4][$n2]  - $wrate[3][$n1] );
$drourate[$year][$age] = $drate[3][$n2] + $n1 * ($drate[4][$n2]  - $drate[3][$n1] );
}
}  

for ($year=30;$year<100;$year++){
for ($age=15;$age<70;$age++){
$n1 = ($year - 18) / 12 ;
$n2 =floor(($age - 10) / 5);
$mrourate[$year][$age] = $mrate[4][$n2] ;
$wrourate[$year][$age] = $wrate[4][$n2] ;
$drourate[$year][$age] = $drate[4][$n2] ;
}
}  

$sql = "truncate eli69";
$exe= mysql_query($sql,$link);
for ($year=6;$year<100;$year++){
for ($age=15;$age<70;$age++){
$x=0.01*$mrourate[$year][$age];
$y=0.01*$wrourate[$year][$age];
$z=0.01*$drourate[$year][$age];
$sql = "insert into eli69 values($year,$age,$x,$y,$z)";
$exe= mysql_query($sql,$link);
}
}
$close_flag = mysql_close($link);
print("69 就業率 計算終了");
?>