[SCRIPT] Visitor Counter

[Ghezus]

This counter counts the number of unique visitors by logging the IP's.

It uses 2 function's:

count() - Counts the user.

visits() - Shows the number of visits

I hope you know how to connect to a mysql database. But if you don't there is a tutorial somewhere that i can't link to.... due to some restriction's...

The table structure is following:

CREATE TABLE `counter` (
  `ip` varchar(15) NOT NULL default '',
  `number` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

You can insert this using PHPMyAdmin or another simular tool.

The code:

PHP Code:

<?php


    function count(){
        if(mysql_result(mysql_query("SELECT COUNT(1) FROM counter WHERE ip='".$_SERVER['REMOTE_ADDR']."';"), 0, 0 ) > 0){
            if(mysql_query("UPDATE counter SET number=number+1 WHERE ip='".$_SERVER['REMOTE_ADDR']."';")){
                return true;
            }
        }else{
            if(mysql_query("INSERT INTO counter SET number=1, ip='".$_SERVER['REMOTE_ADDR']."';")){
                return true;
            }
        }
        return false;        
    }
    
    function visits(){
        if($result = mysql_query("SELECT COUNT(1) as unique, SUM(number) as total FROM count")){
            return mysql_fetch_assoc($result);
        }else{
            return array('unique' => 0, 'total' => 0);
        }
    }

?>

I didn't insert the connection code because I hope you can do that yourself by read the tutorial i linked to below.

Now you can count a visitor by adding:

PHP Code:

<?php count(); ?>

to a page. And you can call the counts with the array function visits();

PHP Code:

<?php

echo "<pre>";
print_r(visits());
echo "</pre>";

count();

echo "<pre>";
print_r(visits());
echo "</pre>";
?>

should display something like:

Array
(
    [unique] => 10
    [total] => 37
)

Array
(
    [unique] => 10
    [total] => 38
)

You can display it in a fancy way using simple PHP to display your count like this:

We have had 3 unique visit's and a total of 10 visit's.

You would use the code :

PHP Code:

<?php 
echo'We have had '.visits['unique'].' unique visit's and a total of '.visits['total'].' visit's. ';
?>

[-FR-]

Nice one . And helpful too. Its a nice tutorial for Newbies.

I hope you know how to connect to a mysql database. But if you don't there is a tutorial somewhere that i can't link to.... due to some restriction's...

Yeah there is already a tutorial available . and heres the link to it:-
http://www.betlik.com/showthread.php?t=17

BTW, where are the restrictions?

[Ghezus]

I can't post links well I can now because my postcount is higher...

[-FR-]

Yeah, that was turned ON for just 5 mins. Now users with 1 posts can also post links.

[DoomGuard]

great share .. and useful to me.. given rep to you ..

thx

[roy77]

Hey army! first thanks for all the tutorials - i finished the first one, connecting to my MYsql successfully, yet now, when i try to make the new table in this tutorial i get this error:

SQL query:

CREATE TABLE `counter` (
`ip` varchar( 15 ) NOT NULL default '',
`number` int( 11 ) NOT NULL default '0'
) ENGINE = MYISAM DEFAULT CHARSET = latin1;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 4

Can you tell me what i did wrong?? thanks sooo much!
roy77

[army]

Originally Posted by roy77

Hey army! first thanks for all the tutorials - i finished the first one, connecting to my MYsql successfully, yet now, when i try to make the new table in this tutorial i get this error:

SQL query:

CREATE TABLE `counter` (
`ip` varchar( 15 ) NOT NULL default '',
`number` int( 11 ) NOT NULL default '0'
) ENGINE = MYISAM DEFAULT CHARSET = latin1;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 4

Can you tell me what i did wrong?? thanks sooo much!
roy77

I tried it myself on my phpMyAdmin, and it works fine ... no error at all.

Btw, this is Ghezus' tutorial .

[roy77]

lol yes i Realized it now, sorry Ghezus, thanks for the tutorial - ill try again.
thanks
roy77

[munmun]

Nice Sharing, Is there any version for ASP.
Can it be possible with javascript with simple HTML coding.

[army]

Originally Posted by munmun

Nice Sharing, Is there any version for ASP.
Can it be possible with javascript with simple HTML coding.

As you can see here: http://www.betlik.com/need-script-ja...985.html?t=985

It is not possible in simple HTML/JavaScript source .

For an ASP counter, check here: http://www.betlik.com/script-asp-hit-counter-t1027.html