This tutorial has been moved to publishing...

http://www.pixel2life.com/publish/tutorial...utorial_on_p2l/

Thanks.

Comments Welcome

- Adam

Very Very nice tutorial. Basic yet very effective and easy to implement. Great work adam thats a really nice hit counter!

Thanks

I hope to write some more tutorials just as good, maybe even better

- Adam

Tutorials posted on these forums are meant to be exclusive to P2L, especially if you have gotten a custom member title for writing it, yet you have posted it on this website.

http://www.techtuts.com/?view=tutorials&am...rial&id=962

Hang on....

I asked Donna Shall I post this?

reply: yes

Point Made

- Adam

Ah ok Didn't know.

Ok lol

- Adam

Nice post Adam. This will come in handy somewhere shortly. I might even modify it slightly. Thanks again champ!

unsure why you have reported this he asked if he could post it, it maybe pointless to you but many new members will think otherwise.

Please don't use the report post when there is nothing to report thanks

:s

You have done the SQL and your config file is correct?

- Adam

Hi there, just tested this out and found that the SQL does not run properly..

Error

SQL query:

CREATE TABLE `stats` (
`ip` varchar( 20 ) NOT NULL default '',
`date` varchar( 10 ) NOT NULL default '00-00-0000',
`hits` int( 10 ) NOT NULL default '1'
) 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 'DEFAULT CHARSET=latin1' at line 5

Try that

- Adam

Well i just added it manually onto the DB in the end... but i get this error thrown up from hit.php

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL on line 14.

All the tables and fields are the same.

config.php file should be like this:


You added extra ")" in the mysql_error part.

And in stats.php, the variable needs to be fixed:


Other than that, this is probably the best tutorial on stats like this out of all the ones I've searched so far.

Edit:
Okay, I'm getting the same error stated above:

Ok,

I have fixed config.php, and the variable in stats.php

I have updated the tutorial, So it should work now



Thanks,

- Adam

Nice but very basic, Not sure whats so 'advanced', Anyways may be good for beginners

Thanks, I will be implementing this in with a CMS I have going, and each item in the CMS will have a hit counter.

I'm new around here and came across this tutorial.

I am wondering if this hit counter can be made to read certain file types that are being called on.
for example instead of displaying hits, page views, etc.. I want to display number of hits to .mpg, .wmv, and .mov files.

I have a video site and want people to know how many videos are being hit, at the moment I am posting the hits and the end of the month on the home page. I would love to have it automatically list the video hits in real time for my site www.bmxvideo.net

Thanks

suggestion:



can very easily be shortened to



It has the same funtionality, and cuts out an entire query. It is a nice mysql shortcut.

du

Hi there, excellent tutorial by the way!

However, I am receiving the following message 'Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 5 in /home/******/public_html/stats.php on line 8'


This is the code in line 8

Adam i'm still getting this error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/pt/public_html/test/hit.php on line 14

Are you sure you tested this before putting it up ? Can you fix the issues :/

I'm going to create a new one soon

Yes this did work for me.

- Adam

How come it doesn't work for me :/ I've tried this on different hosts and asked a few friends to try it and it doesn't work !

How soon do you think you will update this one or when are you planning on releasing the newer one your talking about ?

I will code the new one now, and publish it.

- Adam

Here: http://www.pixel2life.com/tutorials/count/..._php_and_mysql/

Enjoy!
- Adam

Great work, much neater code and worked in the first try
Are you accepting suggestions or feature requests regarding this tutorial ? If so i would love to see an advance users online tutorial implemented into this nifty tutorial !

Sure.. tell me any suggestions

- Adam

Like i've mentioned before, i would like to see an advance users online tutorial implemented into this nice tutorial. I would like to show how many users are currently visiting my website and what page they are viewing. That should add extra kewlness to this tutorial

A floor in this code is that if a user is behind a company like NTL ( English ISP ( Internet Service Provider ) ) $_SERVER['REMOTE_ADDR'] will show the same IP address as everybody else in that area on NTL. So even if you had 10 people in the same area all on NTL or an ISP alike, it would record it as 1 unique hit, when infact there are 10 unique hits.

So you need to make a function which finds the users real IP address to make the hits unique.

Matt

Mayb try a different method to get the ip of a user ? I read something like this somewhere



Don't know if this will work or not :/

I will add how many users are currently online, not sure that what page they are viewing is necessary. Obviously you can add it as an extra



Okay, Will do

Thanks,
- Adam

edit: Tutorial updated. Now supports users online.

I tested the new updated version and saw two mistakes

1) The mysql connection query for the config file is either incomplete or missing some data



Unless things have changed how can one connect to a database without host, database, username, and password combination.

2) After i setup the query myself and configured the mysql query myself I ran the hit.php file and I got the following error



Are you sure you tested the updated version of this tutorial before putting it up Adam ?
Can you fix the issues and update the tutorial. Thanks in advance

Fixed.

- Adam

You didn't test it did you Adam
There are no errors now but whenever someone goes to hit.php it's counting the hits/page refreshes twice !
You can see an example of what i'm saying here

http://pwnagetime.net/test/hit.php
http://pwnagetime.net/test/stats.php

Please fix these errors and i also have another suggestion.

I appreciate you adding the users online timbit into the tutorial but can you also add a feature which will allow the user to click on the # of users online to see which user is online on which page ? For example

Guests Online: 1 <<< #1 is linked to another page named details.php and upon visiting the page it shows information, such as their ip, host, browser and anything extra you wanna throw in, on the users who are online

I believe if you can achieve this, then this tutorial really will become the best simple yet advance hits counter

I found the culprit ! Check stats.php and remove the following line

require_once 'hit.php'; // Record the hits to this page

And it now counts once only

Let me know about the users online feature.

Dude, the script works fine.

If you remove that line from stats.php, you wont be counting the traffic to that page...

and Yes of course I tested it

- Adam

Nope the script doesn't work it has issues after issues.
Now after i fixed the previous mentioned issue i found another bug/glitch which is that after the 5 unique hits, it stops counting anymore unique hits whereas the page refreshes/hits keep going up. Can you look into this matter ? Thx appreciate your time and effort !

It works fine for me. You must be doing something wrong.

Can someone else Test this for me pleaseee

Thanks,
- Adam

I've tested it on three of my other hosts and same issue, after 5 unique hits it stops counting unique hits !

Yea, I'm sorry I realised the bug now.

I will try and fix

- Adam

Great, any updates on this ? Have you fixed it yet ? I'm so impatient to use the fixed version

Is now working for me, updated code.

- Adam

Good stuff, it's working properly now but there still are a few things i would like to point out I hope you don't mind.

1) config.php



It would be alot easier if you did this the following way




2) Almost all the files contain loads of breaks/spaces between the code, is that really necessary ?

3) In stats.php you've included two files



Why are we including the hit.php file here ? Unless we want to count hits for people viewing our stats.php page i don't think it's needed. You should comment this in stats.php to make things easier for users.

4) Thanks for taking my suggestion and adding on the users online feature but wouldn't it be much better if a user could click on the # of guests/users online and view which page others are viewing and other useful information on the users/guests like their browser, host, ip, referrer and so on ? I know i would love to see something like this implemented in this already awesome script ! I can help you implement this if you want

Thanks again for all your hard work Keep up the good work.

1. Sorry, I C & P straight from my localhost so I forget to change the details again.

2. It's just how I code, it wont hurt for you to remove the spaces yourself

3. If you're counting your site stats, when someone is viewing your stat's... that's another hit for your site. So yes it is needed.

4. I am very capable of doing this, and don't need your help. Thanks anyway. I may add it, If I do it will be before Dan has looked at the tutorial and approved / declined. Once published, I will be adding nothing major to it.

Thanks,
- Adam

1 fixed, 4 added ( Page 2 ).

- Adam

Everything is in place and works like a charm without any errors. I love the users online feature but it has a little bit space for improvement. How about including useful information about user like i've mentioned before



To give you a better idea of what i mean please take a look at the following demo script and i would love to see you implement these options onto the "whose online and on which page" of your tutorial.

http://www.terrier-bytes.com/browzin/browzin_demo.html

Including with the above may i suggest you add a feature which shows where the user came from ? Like a referrer ? I would love to show something like top 5 or top 10 referers to my users, so this would be a very simple yet advance addition to this already awesome script.

After these two things are done i think you should wrap it up with a job well done card Cheers mate, great work !

I know what your saying, but no offence.. I can't adapt the script to how you want it, cause its not just for you.

You can add this stuff yourself, but I am not going to be adding this into the tutorial.

Thanks,
- Adam

No offense taken Adam and i hope you don't take one either when i say that i'm simply providing you with feedback and suggestions to help you make this basic hit counter advance and reflect the features the topic suggests. I can implement these features myself and use it for myself, but considering it's your work i don't want to be the one ripping your code snippets by calling it my work