PHP Counter Script Tutorial

Tutorials Palace 5 April, 2011 1 Comment

Creates your own php counter script using a basic knowledge of php + mysql script and keeps your visitors number to database for analysis.

Step1:

Create table “counter”

CREATE TABLE `counter` (
`counter` int(9) NOT NULL default '0'
) TYPE=MyISAM;

CREATE TABLE `counter` (

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

) TYPE=MyISAM;

Step2:

Create file counter.php

|—|——————— code ——————–|—|

<?php

$host="localhost"; // 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";

  $result=mysql_query($sql);


$rows=mysql_fetch_array($result);

  $counter=$rows['counter'];


// if have no counter value set counter = 1

  if(empty($counter)){

  $counter=1;

  $sql1="INSERT INTO $tbl_name(counter) VALUES('$counter')";

  $result1=mysql_query($sql1);

  }


echo "You 're visitors No. ";

  echo $counter;


// count more value

  $addcounter=$counter+1;

  $sql2="update $tbl_name set counter='$addcounter'";

  $result2=mysql_query($sql2);


mysql_close();

  ?>

<?php

$host="localhost"; // 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";

$result=mysql_query($sql);

$rows=mysql_fetch_array($result);

$counter=$rows['counter'];

// if have no counter value set counter = 1

if(empty($counter)){

$counter=1;

$sql1="INSERT INTO $tbl_name(counter) VALUES('$counter')";

$result1=mysql_query($sql1);

}

echo "You 're visitors No. ";

echo $counter;

// count more value

$addcounter=$counter+1;

$sql2="update $tbl_name set counter='$addcounter'";

$result2=mysql_query($sql2);

mysql_close();

Tags:php counter, php counter script, php counter tutorial, simple counter tutorial, simple php counter

Comments

Best PHP Training April 28, 2011 / Reply

THANKS for information .

Step1:

Step2:

Related Posts

Leave a Reply