Php+mysql realize statistics website online number

Php+mysql realize the number of online Web site, the background has MySQL database support. You can directly calculate the current number of online Web site.

The first is to create a MySQL database table.

CREATE TABLE TableName (
field type (max_length) DEFAULT ' Default_value ' (not) NULL
}

The SQL statement that you can use.

CREATE TABLE Useronline (
timestamp int () DEFAULT ' 0 ' not NULL,
IP varchar not NULL,
File varchar not NULL,
PRIMARY KEY (timestamp),
KEY IP (IP),
KEY file (file)
);

Let's start with a PHP script that first defines MySQL information.

$server = "localhost"; Your server
$db _user = "root"; The username of your MySQL
$db _pass = "password"; your MySQL password.
$database = "Users"; The name of the table

Set STATISTICS time (number of seconds online)

$timeoutseconds = 300;

Take the current time.

$timestamp = time ();

The complete code above:

<?php
$server = "localhost"; Your server
$db _user = "root"; Your MySQL database username
$db _pass = "password"; Your MySQL database password if any
$database = "Users"; The DB name
$timeoutseconds = 300;//timeoutseconds Limit
Get the current time
$timestamp = time ();
Calculate the lowest timestamp allowed
$timeout = $timestamp-$timeoutseconds;
?>

Connect MySQL

mysql_connect (' localhost ', ' username ', ' password ');

Variable forms are also allowed.

Mysql_connect ($server, $db _user, $db _pass);

If the MySQL database does not have a password, you can use the following code to connect (of course, we recommend that you must set up their own password, so at least hackers have to decrypt AH)

Mysql_connect ($server, $db _user);

To query the database code:

Mysql_db_query (' database ', ' query ');

We need to add a record as long as we have visitors.

$insert = Mysql_db_query ($database, insert into Useronline VALUES
(' $timestamp ', ' ". $_server[' REMOTE_ADDR ']." ', ' ". $_server[' php_self ');

Then we give the user a way of handling the error message.

if (!) ( $insert)) {
Print "Useronline Insert Failed >";
}

Then we have to realize that when we set the time, we will delete the user record.

$delete = Mysql_db_query ($database, "delete from Useronline WHERE timestamp< $timeout");

Also gives the handling of errors in deleting records.

if (!) ( $delete)) {
Print "Useronline Delete Failed >";
}

Below we show how many different IP in the database

$result = Mysql_db_query ($database, "SELECT DISTINCT IP from useronline WHERE file= '". $_server[' Php_self ']. " ");

We use Mysql_num_rows (query) to count the users, and the code is as follows:

$user = mysql_num_rows ($result);

Finally we want to close the database.

Mysql_close ();

Displays the number of people online.

if ($user = = 1) {
Print ("1 user online\n");
} else {
Print ("$user users online\n");
}

Finally write the above code as a PHP file as follows.

<?php
Put your basic server info
$server = "localhost"; Normally localhost
$db _user = "root"; Your MySQL database username
$db _pass = "password"; Your MySQL database password
$database = "Users";
$timeoutseconds = 300; It'll delete all people which haven ' t refreshed (so probbably are
Offline or inactive) in $timieoutseconds time (so it actually checks the people this are active in the last
$timeoutseconds seconds)
This is where PHP gets the time
$timestamp = time ();
Counts the timeout, all people which have been seen last online in earlier than this timestamp, 'll get removed
$timeout = $timestamp-$timeoutseconds;
Connect to Database
Mysql_connect ($server, $db _user);
Add the timestamp from the user to the online list
$insert = Mysql_db_query ($database, insert into Useronline VALUES
(' $timestamp ', ' ". $_server[' REMOTE_ADDR ']." ', ' ". $_server[' php_self ');
if (!) ( $insert)) {
Print "Useronline Insert Failed >";
}
Delete the peoples which haven ' t been online/active in the last $timeoutseconds seconds.
$delete = Mysql_db_query ($database, "delete from Useronline WHERE timestamp< $timeout");
if (!) ( $delete)) {
Print "Useronline Delete Failed >";
}
Select the amount of people online, all uniques, which are online in this page
$result = Mysql_db_query ($database, "SELECT DISTINCT IP from useronline WHERE file= '". $_server[' Php_self ']. " ");
if (!) ( $result)) {
Print "Useronline Select Error >";
}
Count the number of rows = The number of people online
$user = mysql_num_rows ($result);
Spit out the results
Mysql_close ();
if ($user = = 1) {
Print ("1 user online\n");
} else {
Print ("$user users online\n");
}
?>