<? //REMEMBER TO CONNECT TO THE DATABASE!! $ip = $_SERVER['REMOTE_ADDR']; $time = time(); $ip_check = 'SELECT ip FROM `users_online` WHERE ip = \''.$_SERVER['REMOTE_ADDR'].'\''; $ip_query = mysql_query($ip_check); $num_rows = mysql_num_rows($ip_query); if(!$num_rows) { //if no rows, meaning no ip's in db matched theirs, we will add them. $insert_new = mysql_query("INSERT INTO `users_online` (ip, time) VALUES ('$ip', '$time')"); } //end if NOT THERE //this means that they're already in there, so we update info. if($num_rows > 0) { $update = mysql_query('UPDATE `users_online` SET time=\''.time().'\' WHERE ip = \''.$_SERVER['REMOTE_ADDR'].'\''); if(!$update) die(mysql_error()); } // end UPDATE //if time now - start time > 300 then its been 5 minutes, so we delete $delete_old = mysql_query("DELETE FROM `users_online` WHERE ((".time()."-time) > 300)"); if(!$delete_old) die(mysql_error()); //show the number of people online now.... $id_query = @mysql_query("SELECT * FROM `users_online`"); $users_online = mysql_num_rows($id_query); echo("<BR>The number of people here are : $users_online<BR>"); //users online is done.... ?>
