PHP Statistics online number of numbers combined MySQL stats online number

CREATE TABLE Ccol ( ID integer NOT NULL auto_increment, #记录的ID IP char (a) is not NULL, #访问者的IP地址 Dtstamp datetime NOT NULL, #最后访问时间 Uri Char (255), #访问者请求的URI Primary KEY (ID) ); Copy Code Then, write the PHP code for the statistics /* Files: ccol.php Objective: To count the number of simultaneous online visitors edit:bbs.it-home.org */ $duration=1800; Require "db.php"; Prepare yourself, database access classes Contains Dbsql $ccol=new Dbsql; $ccol->connect (); $ccol->query ("DELETE from Ccol WHERE (Unix_timestamp (now ())-unix_timestamp (Dtstamp)) >$duration"); Delete records for more than half an hour $ccol->query ("select * from Ccol WHERE ip= ' $remote_addr '"); Determine if the current IP exists in the table if ($CCOL->NF ())//have? { $ccol->next_record ();//Move down the pointer to the array of records found $ID=$CCOL->F (' id '); $ccol->query ("UPDATE ccol SET Dtstamp=now (), uri= ' $request_uri ' WHERE id=$id"); Set last access time and access page } else//No { $ccol->query ("INSERT into Ccol VALUES (0, ' $remote_addr ', now (), ' $request_uri ')"); } $ccol->query ("Select COUNT (*) as Ccol from Ccol WHERE" (Unix_timestamp (Now ())-unix_timestamp (Dtstamp)) <= $duration "); Find the record in half an hour, and the WHERE clause in the back is optional--the time Out has been deleted $ccol->next_record () echo "Online number:", $ccol->f (' Ccol '); $ccol->free_result (); ?> Copy Code Call the method and call the program on top of each page of the site. For example: --index.php ...