php05 - プログラム倉庫

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

$sql = "SELECT * FROM pgdata03";
$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;
}
for ($n=1; $n < 5501; $n++) {
$year =$matrix[$n][1];
$age =$matrix[$n][2];
$mh[$year][$age] = $matrix[$n][3];
$fh[$year][$age] = $matrix[$n][4];
}

$sql = "SELECT * FROM pgdata04";
$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;
}
for ($n=1; $n < 5501; $n++) {
$year =$matrix[$n][1];
$age =$matrix[$n][2];
$m4[$year][$age] = $matrix[$n][3];
$f4[$year][$age] = $matrix[$n][4];
}

$sql = "SELECT * FROM xdata05";
$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;
}
for ($n=1; $n < 97; $n++) {
$year =$matrix[$n][1];
$checkpop[$year] = 100*$matrix[$n][2];
}
for ($year=0;$year<100;$year++){
for ($age=15;$age<70;$age++){
$m2[$year][$age] = $mh[$year][$age]-$m4[$year][$age];
$f2[$year][$age] = $fh[$year][$age]-$f4[$year][$age];
}
}

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

for ($year=0;$year<100;$year++){
for ($age=15;$age<70;$age++){
$x1=$m2[$year][$age];
$x2=$f2[$year][$age];
$sql = "insert into pgdata05 values($year,$age,$x1,$x2)";
$exe= mysql_query($sql,$link);
}
}
$close_flag = mysql_close($link);

for ($year=0; $year < 100; $year++) {
$p1=0;
for ($age=15; $age < 70; $age++) {
$p1=$p1+$m2[$year][$age]+$f2[$year][$age];
}
$pop[$year]=$p1;
}
$today = date("H:i:s");
print($today);
print(",");
for ($year=5; $year < 99; $year++) {
print($pop[$year]);
print(",");
print($checkpop[$year]);
print(",");
}
print($pop[99]);
print(",");
print($checkpop[99]);
?>