PHP Counter script tutorial

Create your own a simple PHP counter script using a basic knowledge of php + mysql and keep your visitors number in database for analysis.


In this tutorial, we create 1 PHP file for testing this code.
1. counter.php

1. Create table "counter" in database "test".
2. Create file counter.php.

STEP1: Create table "counter"

CREATE TABLE `counter` (
`counter` int(9) NOT NULL default '0'

STEP2: Create file counter.php

############### Code


// Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name="test"; // Database name
$tbl_name="members"; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect to server ");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";


// if have no counter value set counter = 1
$sql1="INSERT INTO $tbl_name(counter) VALUES('$counter')";

echo "You 're visitors No. ";
echo $counter;

// count more value
$sql2="update $tbl_name set counter='$addcounter'";


Similar Post

Making number format like 0001, 0002

In this tutorial we'll make number format like 0001, 0002, 0003 in stead of 1, 2 ,3. It's very easy to do this

Creating simple PHP contact form

When you need user send feedback to your email you can usecontact form. In this tutorial you'll learn how to create contact form with php script.