### Guys Try This Out ###
1.Write The onlineguest.php Script
<?php
//Now Grab The Users Info You Want To Store In Your Database
$user_ip=$_SERVER['REMOTE_ADDR'];
$user_agent=$_SERVER['USER_AGENT'];
$entry_time=time();
$exit_time=time()+(60*60*24); //Remove User Info From Database In 24 Hours From //Now
if(!empty($user_id) || !empty($user_agent)) {
$dbc=mysqli_connect('localhost','username','passwo rd','databasename');
//Query Now To Check If Guest Is New Or Already Entered
$que="SELECT user_ip FROM guests WHERE user_ip='$user_ip'";
$re=mysqli_query($dbc,$que);
if(mysqli_num_rows($re) == 0)
{
//Guest Is New So Enter Guest Info In Database
$que="INSERT INTO guests (user_id,user_ip,entry_time,exit_time,user_agent)
VALUES (0,'$user_ip','$entry_time','$exit_time','$user_ag ent')";
mysqli_query($dbc,$que);
}
//Create Function To echo Out Total Guests From Database
function total_guests($dbc)
{
$que="SELECT * FROM guests";
$re=mysqli_query($dbc,$que);
$total = mysqli_num_rows($re);
$online='Online Guests('.$total.')';
return $online;
}
echo total_guests($dbc);
//Run Query That AutoMatically Deletes A Guest Row During Their Exit_time Every Time //The Script Has Been Called
$que="DELETE user_id,user_ip,entry_time,exit_time,user_agent FROM guests
WHERE exit_time='$entry_time'";
mysqli_query($dbc,$que);
mysqli_close($dbc);
}
//end Of Script
?>
2.Create Database With Table Named guests
CREATE TABLE 'guests' (
user_id INT AUTO_INCREMENT NOT NULL,
user_ip VARCHAR(16) NOT NULL,
entry_time VARCHAR(32) NOT NULL,
exit_time VARCHAR(32) NOT NULL,
user_agent VARCHAR(16) NOT NULL
);
3.Create The Database
4.Modify The Script Depending On Your Database Name
5.Add The onlineguests.php Script Into Your Index Page Using require_once() -
example :
<div id="guest"><?php require_once('onlineguests.php'); ?></div>
6.This Script Is Just a Improvised One By Me ....
Hope It Will Help You Guys.........
If You've Any Problems With The Script Let Me Know...
ciranjeebxtreme@gmail.com