You might have seen visitor counter on many websites.
Visitor counter is a simple script which is used to show number of visits on
your webpage. This Post will explain you the simple code to create your
own visitor counter using PHP and Mysql. You can use this code in any of
your web applications to keep track on your visitors number in database
for analysis
Just Follow Two Simple Steps to create your own visitor
counter using PHP and Mysql in your Web application
- 1. Create a Table in your database
- 2. Create a test file to implement the code (counter.php)
Step 1: Create Table in your database
Simply make a table with name
tbl_counter(any name) in your database to keep the records of visitors.
CREATE TABLE `tb_counter` (
`counter` INT( 11 ) NOT NULL AUTO_INCREMENT ,
PRIMARY KEY ( `counter` )
) ENGINE = MYISAM ;
Step 2: Create a php file (Test File)
<?php
session_start();
require_once 'db_con.php';
$counter='';//initilize counter
$sql="SELECT counter FROM
tbl_counter";
$resultc=mysql_query($sql);
$rows=mysql_fetch_assoc($resultc);
$counter=$rows['counter'];
// if count is empty
if(empty($counter)){
$counter=1;
$insertCounter="INSERT INTO
tbl_counter set counter='".$counter."'";
$result1=mysql_query($insertCounter);
}
// increment visitor count
$increasecounter=$counter+1;
$sql2="update tbl_counter set
counter='".$increasecounter."'";
$result2=mysql_query($sql2);
?>
<!DOCTYPE HTML>
<html>
<head>
<title>
Hits Counter
</title>
</head>
<h1>
<?php echo "Total hits in this page=" .$counter ; ?>
</h1>
</html>
To know more watch my video tutorial in you tube to know more
