ｐｈｐ５６ - プログラム倉庫

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

$sql = "SELECT * FROM eli80";
$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;
}
$maxn=$n;
for ($n=1; $n < $maxn; $n++) {
$byear =$matrix[$n][1];  
$mtime[$byear] = $matrix[$n][2];  
}

$sql = "SELECT * FROM eli81";
$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;
}
$maxn=$n;
for ($n=1; $n < $maxn; $n++) {
$byear =$matrix[$n][1];  
$ftime[$byear] = $matrix[$n][2];  
}

$sql = "SELECT * FROM eli41";
$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;
}
$maxn=$n;
for ($n=1; $n < $maxn; $n++) {
$byear =$matrix[$n][1];  
$mtime[$byear] = $matrix[$n][2];  
}

$sql = "SELECT * FROM eli42";
$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;
}
$maxn=$n;
for ($n=1; $n < $maxn; $n++) {
$byear =$matrix[$n][1];  
$ftime[$byear] = $matrix[$n][2];  
}


$sql = "SELECT * FROM eli43";
$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;
}
$maxn=$n;
for ($n=1; $n < $maxn; $n++) {
$byear =$matrix[$n][1];  
$mtime[$byear] = $matrix[$n][2];  
}

$sql = "SELECT * FROM eli44";
$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;
}
$maxn=$n;
for ($n=1; $n < $maxn; $n++) {
$byear =$matrix[$n][1];  
$ftime[$byear] = $matrix[$n][2];  
}

$sql = "truncate eli56";
$exe= mysql_query($sql,$link);
for ($byear=1910;$byear<2035;$byear++){
$x=$mtime[$byear];
$y=$ftime[$byear];
$sql = "insert into eli56 values($byear,$x,$y)";
$exe= mysql_query($sql,$link);
}
$close_flag = mysql_close($link);
print("56 通算平均加入年数 計算終了");
?>