If you want to add a counter to a web page or a website then use the below simple PHP Counter Script using MySql. It is very easy to implement it and it counts whenever a page is being refreshed and the script won’t reduce page speed, unlike page counter scripts.
PHP Visitor Counter Script
Website Visitor Counter Code PHP
First Create a table called Counter and add below MySql Queries.
1 2 3 4 5 6 7 8 9 | CREATE TABLE `Counter` ( `id` int(15) NOT NULL AUTO_INCREMENT, `visits` int(15) NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;INSERT INTO `Counter` (`id`, `visits`) VALUES(1, 1); |
PHP Script for Counter
Now Create a PHP file and name it is as db.php
In db.php file add the below code.
1 2 3 4 5 6 7 8 9 10 | <?php$dbhost = "localhost";$dbuser = "admin";$dbpass = "password";$dbname = "databaseName";$conn = mysqli_connect($dbhost, $dbuser, $dbpass,$dbname);?> |
In place of dbhost, dbuser, dbpass, dbname add your Database details.
Now create a PHP file called counter.php and add below code in it.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | <?phpinclude 'db.php';$sql = "UPDATE Counter SET visits = visits+1 WHERE id = 1";$result = mysqli_query($conn, $sql);$sql = "SELECT visits FROM Counter WHERE id = 1";$result = mysqli_query($conn, $sql);if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { $visits = $row["visits"]; }} else { echo "No Visits";} $conn->close();echo "Total Number of Visits: ". $visits; ?> |
Now upload both the db.php and counter.php on your web hosting and load the counter.php file to see the visitors count.
That’s it it’s a simple PHP MySql Counter Script that doesn’t reduce page speed unlike third-party visitor or counter scripts.
