PHPϵͳÁ÷Á¿·ÖÎöµÄ³ÌÐò

create table stream (
ip text,
sTime int,
visits int,
info text);
<?
if($day<0)$day=0;
$mlink=mysql_connect('localhost','ajax','xxxxxxx');
//ͳ¼ÆÖÁ½ñÊ×Ò³±»a¯ÀÀµÄ×Ü´ÎÊý
$query="select SUM(visits) as tvisits from stream";
$result=mysql_db_query('ajax',$query,$mlink);

echo 'a¯ÀÀÊ×Ò³×ÜÀÛ»ý´ÎÊý:';
if($row=mysql_fetch_object($result)){
echo $row->tvisits;
}

$week=array("ÐÇÆÚÈÕ","ÐÇÆÚÒ»","ÐÇÆÚ¶þ","ÐÇÆÚÈý","ÐÇÆÚËÄ","ÐÇÆÚÎa","ÐÇÆÚÁu");
for($i=0;$i<=$day;$i++){
echo '

';
$ctime1=time()-243600$i;
$ctime2=time()-243600($i-1);
echo 'ÈÕÆÚ:'.date("mÔÂdÈÕ",$ctime1).$week[date("w",$ctime1)];
echo "";

$stoday1=mktime(0,0,0,date(m,$ctime1),date(d,$ctime1),date(Y,$ctime1));
$stoday2=mktime(0,0,0,date(m,$ctime2),date(d,$ctime2),date(Y,$ctime2));
//ͳ¼Æµ±ÈÕÊ×Ò³±»a¯ÀÀµÄÀÛ»ý´ÎÊý
$query='select SUM(visits) as tvisits from stream where sTime>=';
$query.=$stoday1.' and sTime<'.$stoday2;
$result=mysql_db_query('ajax',$query,$mlink);
echo 'a¯ÀÀÊ×Ò³ÀÛ»ý´ÎÊý:';
if($row=mysql_fetch_object($result)){
echo $row->tvisits;
}
//ͳ¼Æµ±ÈÕ°ÝÃipµÄÊýÁ¿
$query='select from stream where sTime>='.$stoday1;
$query.=' and sTime<'.$stoday2.' order by sTime DESC';
$result=mysql_db_query('ajax',$query,$mlink);

echo "
a¯ÀÀ×ÜÈËÊý:".mysql_num_rows($result);
echo '

while($row=mysql_fetch_object($result)){
echo '