Selasa, 01 Maret 2011

PHP hit counter

Penasaran sama cara kerja hit counter membuat gue mencari-cari tutorial kesana kemari http://www.smileycodes.info
Dan akhirnya...
Taraaaaa http://www.smileycodes.info
This is it...

Langkah pertama buat dulu database nya dengan nama hitcounter, setelah itu buat tabelnya, bisa langsung menggunakan phpMyAdmin bisa juga dengan coding.
CREATE TABLE `visitor` (
`counter` int(9) NOT NULL default '0'
) TYPE=MyISAM;


Langkah kedua buat script counter.php
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="hitcounter"; // Database name
$tbl_name="visitor"; // 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 "<b>".$counter."</b>";

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

mysql_close();
?>


Selesai deh..gampang kan??
Tolong dikembangin ye kalo bisa..
Ane juga lagi mau ngembangin lagi..
Kalo udah ada yang bisa kasih atu ane yee..
Intinya saling berbagi http://www.smileycodes.info aja..hehehe

Referensi = http://www.phpeasystep.com/phptu/7.html

2 komentar:

  1. oanioninasoaifhsfhoaifhasifn safoaishfujashofu

    BalasHapus
  2. apaan sih nih??
    ga jelas banget komen nya..
    zzzzzz

    BalasHapus