Gt; createtablestream (iptext, sTimeint, visitsint, infotext );? Phpif ($ day...> create table stream (
Ip text,
STime int,
Visits int,
Info text );
Tvisits;} $ week = array ("Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday "); for ($ I = 0; $ I <= $ day; $ I ++) {echo''; $ Ctime1 = time ()-24*3600 * $ I; $ ctime2 = time ()-24*3600 * ($ I-1); echo 'date :'. date ("m Month 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 )); // count the total number of times the homepage is browsed on the current day. $ query = 'SELECT SUM (visits) as tvisits from stream where sTime> = '; $ query. = $ stoday1. 'and sTime <'. $ stoday2; $ result = mysql_db_query ('Ajax ', $ query, $ mlink); echo 'cumulative number of homepage views:'; if ($ row = mysql_fetch_object ($ result )) {echo $ row-> tvisits;} // count the number of ip addresses visited on the current day. $ query = 'select * from stream where sTime> = '. $ stoday1; $ query. = 'and sTime <'. $ stoday2. 'order by sTime DESC '; $ result = mysql_db_query ('Ajax', $ query, $ mlink); echo "total browsing count :". mysql_num_rows ($ result); echo'
'; Echo'
'; Echo'
IP address |
Last time |
Times |
User information | '; Echo"
"; While ($ row = mysql_fetch_object ($ result) {echo'
'; Echo'
'. $ Row-> ip .' | '; Echo'
'. Date ("h: I: sa", $ row-> sTime ).' | '; Echo'
'. $ Row-> visits .' | '; Echo'
'. $ Row-> info .' | '; Echo"
";} Echo"
"; Echo'
';} Mysql_close ($ mlink) ;?>