PHP User online tutorial

This tutorial show you php script that count how many users are active on your site.


In this tutorial, create 1 PHP file for testing this code.
1. user_online.php

1. Create table "user_online" in mysql in database "test".
2. Create file user_online.php.

STEP1: Create table "user_online"

CREATE TABLE `user_online` (
`session` char(100) NOT NULL default '',
`time` int(11) NOT NULL default '0'

STEP2: Create file - user_online.php

############### Code


$time_check=$time-600; //SET TIME 10 Minute

$host="localhost"; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name="test"; // Database name
$tbl_name="user_online"; // Table name

// Connect to server and select databse
mysql_connect("$host", "$username", "$password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name WHERE session='$session'";



$sql1="INSERT INTO $tbl_name(session, time)VALUES('$session', '$time')";

else {
"$sql2=UPDATE $tbl_name SET time='$time' WHERE session = '$session'";

$sql3="SELECT * FROM $tbl_name";


echo "User online : $count_user_online ";

// if over 10 minute, delete session
$sql4="DELETE FROM $tbl_name WHERE time<$time_check";

// Open multiple browser page for result

// Close connection


Similar Post

PHP Counter script tutorial

Creates your own counter script. Using a basic knowledge of php + mysql script and keeps your visitors number to database for analysis.

Encrypting Password using md5() function

Using md5(); function to make your login system more secure