Check number of users using PHP

Welcome to this new Combined Minds tutorial. In this tutorial I will teach you how to create a simple "number of users online" system. This system will be IP based, not session based. The reason i chose the IP based system, is that some browsers really mess up sessions. This can result in a number thats maybe twice as high as it really is. IP based might not be a perfect technique, for if you have to visitors with the same IP (e.g. a school). It will be stored as one user. But in the end, the IP technique gives a better result than the session technique. Getting started First we need a way to store the visitor information. The most fast way is a simple MySQL table, so lets create a new table. In this tutorial i hope i can assume you have basic MySQL knowledge. This code just creates a new table, with 2 fields. One field for storing the time (we'll come back to that later). And one for the IP, so we can keep all visitors apart. Before we start coding, i will explain you how we're going to create this system. First we'll let the server check if the visitor already has a record in the database. If it doesn't have a record, we'll create a record. And we'll have a new visitor to the website. If it already has a record, we'll check the time that's stored along with the new visitor. If the time is more then 30 seconds ago, we'll update the time to the current time. And every time the page is loaded the script deletes all visitors records that are older than 5 minutes/ (300 seconds) So lets start programming OK? First create your connection with the database. OK, simple enough. Lets start with the time. The time is important, we need to know the current time, the time of 30 seconds ago, and the time of 300 seconds ago. All times are made with the time() function. This is a function that uses only seconds, counting from 1970 until now. With this function we can precisely get the times we need for our script. Also define a variable called $ip, that stores the IP address of the current visitor. ?> This makes sense. Create 3 time variables containing the current time, 30 seconds ago, and 300 seconds ago. The IP variable also makes enough sense. Now lets check if this is the first time the visitor opens the website, or if his IP is already stored in the database. Simply checking if IP already exists in the database. If there is a record with the IP, the $onCount variable will contain "1", or else "0". If the IP is not listed in the table, and so the $onCount variable contains "0", we need to create a new record in the database. The $onCount variable is less than 1, so create a new record in the database. Now what if the $onCount variable does contain "1"? OK, lets create the update section, this sections updates the time in the table to the current time, if the table-time is more than 30 seconds old. I explained all details in the comment, so this should be easy to understand. Now we need to delete all records that contain the time of more then 300 seconds ago. (5 minutes) This is done with one simple query. This means that the table is now 100% up to date, all visitors are listed, and no visitor in the table has a time 5 minutes old. We can now start counting the number of visitors from our table. A nice quest that counts the number of different IP addresses in the database. And using list to directly store the MySQL result into the $coResult variable. Now the only thing left is echoing the result to the screen. If there is only 1 person online, we don't need visitors. So we'll keep it apart by using a very simple if statement. Congratulations, you've just completed a nice script. It would be best to just include this script on the place you want the number of visitors echoed. If you've faced some difficulties, or other comment. Please drop by at our IRC channel. This is my finished script: ?>

Copyright © 2006-2007 Coding, Programming Tutorials. Powered by Zeeblo Webhosting 2.1.3 | 0.0315