<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>ようこそ</title>
</head>
<body>
<?php
require("calldata.php");
$sql = "SELECT * FROM ren";
$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++){
$date[$n]= $matrix[$n][1];
$title[$n]= $matrix[$n][2];
$sum[$n]= $matrix[$n][3];
}
$rssurl = "http://rss.rssad.jp/rss/cyzo/index.xml";
$rssdata = simplexml_load_file($rssurl);
for($n=0;$n<5;$n++){
$newdate[$n]=$rssdata->channel->item[$n]->pubDate;
$newtitle[$n]=$rssdata->channel->item[$n]->title;
$newsum[$n]=$rssdata->channel->item[$n]->description;
print($newtitle[$n]);
print("<BR>");
}
$maxm=1;
for($nx=0;$nx<5;$nx++){
$px=0;
for ($n=1;$n<$maxn;$n++){
if ($newtitle[$nx]==$title[$n])$px=100;
}
if ($px<50)$mdate[$maxm]=$newdate[$nx];
if ($px<50)$mtitle[$maxm]=$newtitle[$nx];
if ($px<50)$msum[$maxm]=$newsum[$nx];
if ($px<50)$maxm=$maxm+1;
}
for($m=1;$m<$maxm;$m++){
$sql = "insert into ren values('$mdate[$m]','$mtitle[$m]','$msum[$m]')";
$exe= mysql_query($sql,$link);
}
$close_flag = mysql_close($link);
?>
</body>
</html>
最終更新：2010年09月13日 21:23
