Make simple page counter using php and mysql

A hit counter or a page counter counts the number of people that visit your page. If you have created a new website you might be interested how many people are visiting. so try this simple method count how many people visit on your website. this coding make MySQL update query using in php.

Database

Create count table and insert sample value in name field to the database. Ex; Name="Mostlikers" don't insert count value watch below table coding

CREATE TABLE Count

(
id INT  AUTO_INCREMENT,
Name TEXT

count INT
);

Count.php

Create count.php page Fetch database count table value from this page using below coding update through 

page count value will be increased.

<?php
$fetch=mysql_query("select * from count");
while($row1=mysql_fetch_array($fetch))
{

    $id=$row1['id'];
    $samplename=$row1['name'];
    $counts=$row1['count'];
    $tolcount2=$counts+1;
    $updates=mysql_query("update count set count='$tolcount2' where id='$id' ");
}
?>

Fetch the count value using increment value +1 to update the database from given value

out.php

Refresh count.php file value will be increased show as output below

 <span style="color:#F00;">(<?php echo $tolcount2; ?>)</span>