There are many different variations but I just want it to show # of users online. I was able to obtain this coding from the library but I just need the number of users online. It's pretty simple.
<?php
create table YOURTABLE (
SID varchar(100) NOT NULL,
time varchar(15) NOT NULL,
day varchar (3) NOT NULL);
Config your settings below
*****/
$Session_name = "default"; // The Sessions name, write "default" for default name.
$host = "localhost"; // Your host
$username = "username"; // Your MySQL username
$password = "password"; // Your MySQL password
$database = "database"; // Your Database of choice
$table = "table"; // Your Table of choice, ex. "online_users"
// Starts Session
if ($Session_name == "default") {
session_start();
}
else {
session_name("$Session_name");
session_start("$Session_name");
}
$SID = session_id();
$time = time();
$dag = date("z");
$nu = time()-900;
//This connects to the MySQL server
mysql_connect ($host, $username, $password) OR DIE ("Could not connect to MySQL");
mysql_select_db($database) OR DIE ("Can't select database.");
// Check to see if the session_id is already registerd
$sidcheck = mysql_query("SELECT count(*) FROM $table WHERE SID='$SID'");
$sid_check = mysql_result($sidcheck,0);
if ($sid_check == "0") {
// If not, the session_id will be stored in MySQL
mysql_query("INSERT INTO $table VALUES ('$SID','$time','$dag')");
} else {
// If it is, it will register a new time to the session.
mysql_query("UPDATE $table SET time='$time' WHERE SID='$SID'");
}
// This is it, this counts the users currently online
$count_users = mysql_query("SELECT count(*) FROM $table WHERE time>$nu AND day=$dag");
$users_online = mysql_result($count_users,0);
// This deletes old ids, so your db will not get overloaded.
mysql_query("DELETE FROM $table WHERE time<$nu");
mysql_query("DELETE FROM $table WHERE day != $dag");
mysql_close();
if ($users_online == "1") {
echo "You are alone to view this page right now.\n";
}
else {
echo "There's $users_online people viewing this page right now.\n";
}
?>
Can I just the last part
if ($users_online == "1") {
echo "You are alone to view this page right now.\n";
}
else {
echo "There's $users_online people viewing this page right now.\n";
}
to show just any number of users? I would like to use css...so <span class="users_online"> something?
