• Home
• Flash
• JavaScript
• PHP
• XML

MySQL Hit Counter

Installation:

1. Open counter.php with notepad and put your database hostname, username, password and database name correctly.
2. Upload the counter.php file in to your server.
3. Log in to your database with phpmyadmin and execute this query
   CREATE TABLE `mysql_couter_logs` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `name` TEXT NOT NULL , `hits` INT NOT NULL DEFAULT '0' )
4. To add a page on database for counting logs log in to your database with phpmyadmin, click on Insert from the top menu of phpMyAdmin. Give a page name, no need to give id or hits, leave them blank.
5. To add more pages repeat step 4 as many time as you need.

Counting and showing hits
Add the script below in you homepage where you want to show your hit counts. Don't forget to check the correct url to counter.php

Change the pagename with current page name you provided on database.

Formatting hit counter text
Of course you can show the hit counter the way you like. Just insert the code inside any html tags. Such as...

Troubleshoot:
This script is always showing 1:
Probably you didn't add the page on database. Use phpMyAdmin to login and add that page in database.