Below is the script on how to make visitors counter based on Mysql database
create table on your database:
CREATE TABLE `counter` (
`count_id` varchar (225) NOT NULL default,
`count` longtext NOT NULL,
`hits` longtext NOT NULL
) TYPE = MyISAM;
notes:
for initial value for:
"count_id" enter the value 1
"count" enter the value 1
"hits" enter the value 1
below is the script for counter:
<?php
session_start();
/* Database connection ----- begin ------- */
$dbhost = localhost; /* your host ----- ------- */
$dbusername = username; /* your user ----- ------- */
$dbpasswd = password; /* your password ----- ------- */
$database_name = database; /* your database name ----- ------- */
/* ----- Start db connection, code below do not change in ------- */
$connection = mysql_pconnect("$dbhost", "$dbusername", "$dbpasswd") or die ( "Could not connect to server.");
$db = mysql_select_db("$database_name", $connection) or die ( "Could not select database.");
/* Database connection out ----- ------- */
// ----- If session "counted" has not been listed ------- *
if (!session_is_registered("counted")) {
/* ----- Update the cell "count" to add a +1 ------- */
mysql_query("UPDATE counter SET count = (count + 1) WHERE count_id = 1");
/* ----- Register session "counted" ------- */
session_register("counted");
}
?>
//script for visitor:
/* ----- Show value / value from the table "counter" column to the 2-I mean the "count" ------- */
$sql = mysql_query ("SELECT * FROM counter limit 1");
while ($row = mysql_fetch_array ($sql)) {
echo $row [1];
}
?>
script for hits:
<?php
/* ----- For the hits, we do not need the function "IF" ------- */
// Update cell ----- "hits" to add a +1 ------- */
mysql_query("UPDATE counter SET hits = (hits + 1) WHERE count_id = 1");
/* ----- Show value / value from the table "counter" column to the 3-I mean the "hits" ------- */
/* ----- Who has been in the process of update of the above ------- */
$sql = mysql_query ("SELECT * FROM counter limit 1");
while ($row = mysql_fetch_array($sql)) {
echo $row [2];
}
?>
