Hey, it's me again with another tutorial! Now, have you ever wanted to know how many people go onto your website? Well, now you can! With this simple counter tutorial.
Requirements:
phpMyAdmin
FTP client
And a website.

To start off, you need to insert this query into your database:

CREATE TABLE `counter` (
`counter` int(9) NOT NULL default '0'
) TYPE=MyISAM;

Yes folks, its that simple of a query!

Now to insert it into your website:

<?php
$host="localhost"; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name="test"; // Database name
$tbl_name="members"; // 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);
}

echo "You 're visitors No. ";
echo $counter;

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

mysql_close();
?>

Your can insert this into a new file called counter.php, if you want.

You have to put the host your using, your database name, your password, and database used. You can modify the look of the counter however you want!

Thanks for reading this tutorial!