PHP Simple Text PHP Counter for website!

Hi
I am new in web designing but little effort for those who new like me, this my first thread hope all like and reply my new post! thanks in advance!


<?php

$host="hostname"; // Host name
$username="sqlusername"; // Mysql username
$password="sqlpass"; // Mysql password
$db_name="db_name"; // Database name
$tbl_name="table_name"; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect to server ");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
$rows=mysql_fetch_array($result);
$counter=$rows['counter'];

// if have no counter value set counter = 1
if(empty($counter)){
$counter=1;
$sql1="INSERT INTO $tbl_name(counter) VALUES('$counter')";
$result1=mysql_query($sql1);
}
//<font size="2">
<font face="verdana">
echo "Total Visitors. ";
echo $counter;

// count more value
$addcounter=$counter+1;
$sql2="update $tbl_name set counter='$addcounter'";
$result2=mysql_query($sql2);

mysql_close();
?>

 

Thanks for sharing that with us Mir! (Do I call you that? Or Ahmad?) It's a breath of fresh air to see new posters helping out as well