PHP: Counting unique hits

[Rellizate]

For the tut, see here: http://www.thesmurk...?page=vtut&id=47

Sorry about having to link.

[citricsquid]

Thankyou thankyou thankyou thankyou <3

I have been looking for a good tutorial on this <3 this will really help me, thankyou so much, and good tutorial.

[Rellizate]

That's ok. I was looking for one like this for ages, which is I learnt PHP, and wrote it.

:-D

[Pilot-Doofy]

lol This cat asked me for help on this tutorial making process. Anyway, why would you use a database for such small things like this? A txt file would really be all you need.

[NinoGrounds]

At 4/17/06 11:11 AM, Pilot-Doofy wrote: lol This cat asked me for help on this tutorial making process. Anyway, why would you use a database for such small things like this? A txt file would really be all you need.

However you are right, I am saving it the DB as well.

But my script is ALOT smaller, and, because of it, faster.

[Rellizate]

At 4/17/06 11:11 AM, Pilot-Doofy wrote: lol This cat asked me for help on this tutorial making process. Anyway, why would you use a database for such small things like this? A txt file would really be all you need.

Well, mostly because I wanted to practice my SQl.

:D

[NinoGrounds]

At 4/17/06 12:26 PM, Rellizate wrote:

At 4/17/06 11:11 AM, Pilot-Doofy wrote: lol This cat asked me for help on this tutorial making process. Anyway, why would you use a database for such small things like this? A txt file would really be all you need.

Well, mostly because I wanted to practice my SQl.

D

You want me post mine version? If you want to I'll do it.

[Rellizate]

No thanks. I know yours will be better, so there is no point...

xD

[NinoGrounds]

At 4/17/06 12:35 PM, Rellizate wrote: No thanks. I know yours will be better, so there is no point...

xD

Ok...but it is like:
1) GET IP
2) Check if the same one already in the db
3) if no, insert it
4) else do nothing (but there's no actually part like else {} )

[Rellizate]

That's exactly what mine does.

[Zendra]

At 4/17/06 12:26 PM, Rellizate wrote: Well, mostly because I wanted to practice my SQl.

Better do that in your own time. ;)
You need to give people the best solution which is fast and secure - if you'd ask me.

[Ziaja]

I think this was ment to be an affiliate in/out counter (at least thats what i gather from the comment he left).

[thoughtpolice]

At 4/17/06 12:16 PM, Nino_JoJ wrote: However you are right, I am saving it the DB as well.

But my script is ALOT smaller, and, because of it, faster.

A smaller script doesn't me flat out anything - my entire website is run off of five lines of PHP, but that doesn't mean it's going to work any faster than somethingawful.

[Rellizate]

At 4/17/06 07:04 PM, Ziaja wrote: I think this was ment to be an affiliate in/out counter (at least thats what i gather from the comment he left).

Well, it only counts in. Also this was actually created for seeing how many unique hits, sites which you bought advertising off sent you.
You can use it for lots of stuff, though.

[Rellizate]

Ok, fixed.

Change line in add_new.php where it says:
$result = mysql_query("select * from supporters limit 1");

to:
$result = mysql_query("SELECT id FROM supporters ORDER BY id DESC LIMIT 1");

[netster403]

sweetness, always looking for php goodies, thank ya kindly :P

[Rellizate]

That's ok.

Remember to:

change line in add_new.php where it says:
$result = mysql_query("select * from supporters limit 1");

to:
$result = mysql_query("SELECT id FROM supporters ORDER BY id DESC LIMIT 1");

[knugen]

The link is broken :'(

[Mister-Mind]

At 2/16/07 03:26 PM, DreamworX wrote: The link is broken :'(

Yuppers,

Im going to pm the thread starter asking if he can make another thread and called php: counting unique hits and he can remake the tut, and replace it in the PHP Main

[knugen]

At 2/16/07 03:34 PM, PHPgeek wrote: Im going to pm the thread starter asking if he can make another thread and called php: counting unique hits and he can remake the tut, and replace it in the PHP Main

Ok, do you think that you could PM me if he does so? Thanks :)

[juraj]

Counting unique hits isn't so tough to set-up. You just need a MySQL database and an idea what you're trying to accomplish :-)

BTW, what is exactly considered an unique hit? A single request from an IP address in 24 hours?