<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>ren ren</title>
</head>
<body>
<?php
require("calldata.php");
$urlnumber=3;
$urlx[1]="http://www.google.com/alerts/feeds/01098385978506698295/470012915028882755";
$urlx[2]="http://www.google.com/alerts/feeds/01098385978506698295/15892197134770011249";
$urlx[3]="http://www.google.com/alerts/feeds/01098385978506698295/17909126248618323727";
for ($sx=1;$sx<$urlnumber+1;$sx++){
$rssurl =$urlx[$sx];
$rssdata = simplexml_load_file($rssurl);
for($n=0;$n<100;$n++){
$date[$n]=$rssdata->entry[$n]->published;
$title[$n]=$rssdata->entry[$n]->title;
$content[$n]=$rssdata->entry[$n]->content;
$author[$n]=$rssdata->entry[$n]->author->name;
$category[$n]=$rssdata->entry[$n]->source->title;
}
$nx=0;
For($n=0;$n<100;$n++){
$a=strlen($title[$n]);
if($a>0)$nx=$nx+1;
}
For($n=0;$n<$nx;$n++){
$b = substr($date[$n],0,4);
$c1 = substr($date[$n],5,1);
$c2 = substr($date[$n],6,1);
$d1 = substr($date[$n],8,1);
$d2 = substr($date[$n],9,1);
$e1 = substr($date[$n],11,1);
$e2 = substr($date[$n],12,1);
$f1 = substr($date[$n],14,1);
$f2 = substr($date[$n],15,1);
$g1 = substr($date[$n],17,1);
$g2 = substr($date[$n],18,1);
$c=10*$c1+$c2;
$d=10*$d1+$d2;
$e=10*$e1+$e2;
$f=10*$f1+$f2;
$g=10*$g1+$g2;
$z=$c;
$z=100*$z+$d;
$z=100*$z+$e;
$z=100*$z+$f;
$z=100*$z+$g;
$id[$n]=$z;
print('<BR>');
}
for($n=0;$n<$nx;$n++){
$sql = "insert into pon2 values($id[$n],'$author[$n]','$title[$n]','$date[$n]','$content[$n]','$category[$n]')";
$exe= mysql_query($sql,$link);
}
}
$close_flag = mysql_close($link);
?>
</body>
</html>
最終更新：2011年04月07日 04:07
