アットウィキロゴ

PHP pub

<?php
require("calldata.php");
$sql = "SELECT * FROM ben04";
$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];
$m[$year][$age]=$matrix[$n][3];
$f[$year][$age]=$matrix[$n][4];
}

$sql = "SELECT * FROM ben68";
$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];
$n=$n+1;
}
$maxn=$n;
for ($n=1;$n<$maxn;$n++){
$year=$matrix[$n][1];
$age=$matrix[$n][2];
$rate[$year][$age]=0.01*$matrix[$n][3];  
}

$sql = "SELECT * FROM ben05";
$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];
$matrix[$n][5] =$row[4];
$n=$n+1;
}
$maxn=$n;
for ($n=1;$n<$maxn;$n++){
$year=$matrix[$n][1];
$age=$matrix[$n][2];
$mrate[$year][$age]=$matrix[$n][3];  
$wrate[$year][$age]=$matrix[$n][4];  
$drate[$year][$age]=$matrix[$n][5];  
}

for ($year=6;$year<100;$year++){
for ($age=15;$age<70;$age++){
$wife[$year][$age]=$rate[$year][$age]*$f[$year][$age];
$doku[$year][$age]=(1-$rate[$year][$age])*$f[$year][$age];
}
}

for ($year=6;$year<100;$year++){
for ($age=15;$age<70;$age++){
$mrou[$year][$age]=$mrate[$year][$age]*$m[$year][$age];
$wrou[$year][$age]=$wrate[$year][$age]*$wife[$year][$age];
$drou[$year][$age]=$drate[$year][$age]*$doku[$year][$age];
}
}

$sql = "truncate ben06";
$exe= mysql_query($sql,$link);  
for ($year=6;$year<100;$year++){
for ($age=15;$age<70;$age++){
$x=$mrou[$year][$age];
$y=$wrou[$year][$age];
$z=$drou[$year][$age];
$sql = "insert into ben06 values($year,$age,$x,$y,$z)";
$exe= mysql_query($sql,$link);
}
}
$close_flag = mysql_close($link);

print("06 労働力人口 計算終了");  
?>
最終更新:2010年12月13日 19:23