Hit Counter PHP

To find out the statistics from a website, an application needs to be included in a website counter. The application of this counter will work automatically calculate every visitor who comes on a website, so that administrators and other visitors can see how many visitors the website. Hits Counter application and it will count every visitor's unique IP based and also calculate each page that is clicked on by visitors of the website. This application uses MySQL as its storage medium.

create database "counter"

CREATE TABLE `counter` ( `count_id` varchar(225) NOT NULL default '', `count` longtext NOT NULL, `hits` longtext NOT NULL ) TYPE=MyISAM;

Then create a script for the configuration, visitors and hits. "counter.php"

<?php session_start(); $dbhost = 'localhost'; $dbusername = 'username'; $dbpasswd = 'yourpass'; $database_name = 'databasename'; $connection = mysql_pconnect("$dbhost","$dbusername","$dbpasswd") or die ("Couldn't connect to server."); $db = mysql_select_db("$database_name", $connection) or die("Couldn't select database."); if (!session_is_registered("counted")){ mysql_query("UPDATE counter SET count=(count + 1) WHERE count_id=1"); session_register("counted"); } ?> Visitor: <?php /* ----- show the value / value of the table "counter" second column "count" ------- */ $sql = mysql_query("SELECT * FROM counter LIMIT 1"); while($row = mysql_fetch_array($sql)){ echo $row[1]; } ?> Hits: <?php /* ----- for hits, we do not need the function "IF" ------- */ /* ----- Update cell "hits" by adding a +1 ------- */ mysql_query("UPDATE counter SET hits=(hits + 1) WHERE count_id=1"); /* ----- show the value / value of the table "counter" third column "hits" ------- */ /* ----- which has been updated from the above process ------- */ $sql = mysql_query("SELECT * FROM counter LIMIT 1"); while($row = mysql_fetch_array($sql)){ echo $row[2]; } ?>

PHPText AnimationsWidget

By Blogger Biasa - February 16, 2010 - Add Comment