[php] logging visitors

Alex. · 12-31-2006, 04:30 AM

Hi, i am planning on running an affliate scheme.

I want to use the GD function to create the image, and then Id like a function to log the site that's requesting the image, so i can add the url to the DB.

Is there a function / method that can do this for me??

Peter · 12-31-2006, 05:52 AM

in all honesty it would be fairly easy to write something yourself.

What I would do is the following:-

Make a htaccess mod rewrite rule to have change a url of something like http://www.yourdomain/username/ to http://www.yourdomain.com/image.php?user=username

Also create a database with a visitor referrer table with 3 fields 1 being a unique id another being their username and another being the count (username would match what is being changed in the url).

When someone gets the image simply do a statement such as UPDATE tbl_name SET count=count+1;

After this simply display the image.

Another method for the database would be to have 1 table for the referrer and another for the visitors, the referrer table would be the same as before but without the count field. In the visitor field you would store id, referrer id, and any other details that may come in handy such as a timestamp and their ip and possibly browser agent etc.

Alex. · 12-31-2006, 04:40 PM

im sorry, what i meant was is there a way to log the sites that request the image

thanks for the other info

Peter · 12-31-2006, 05:26 PM

If people are not going to sign up then the only way I can think of is to use $_SERVER['HTTP_REFERER'] which shows what the users browser claims to be the referrer to the current page, in this case the page that is calling the image.

However before using this make sure you sanitize it and do not 100% rely on it as it can be spoofed (as can anything else provided by the user) or may not be sent at all (due to example proxies or some firewalls).

Alex. · 12-31-2006, 05:45 PM

thanks, what do you mean by sanatise?
that should work ok for me, as the usage is for link exchange.

Matthew. · 12-31-2006, 06:11 PM

By sanatise we mean to make the string safe, or to escape it in other words.

Alex. · 12-31-2006, 06:55 PM

thanks, will rep++ when i get to my pc.

12-31-2006, 04:30 AM	#1 (permalink)
Alex. NamePros Regular Join Date: Nov 2006 Location: Uk Posts: 601 133.80 NP$ (Donate)	[php] logging visitors Hi, i am planning on running an affliate scheme. I want to use the GD function to create the image, and then Id like a function to log the site that's requesting the image, so i can add the url to the DB. Is there a function / method that can do this for me?? __________________ _\\|/_ _\\|/_ _\\|/_ _\\|/_ _\\|/_ :confused:

12-31-2006, 04:40 PM	#3 (permalink)
Alex. NamePros Regular Join Date: Nov 2006 Location: Uk Posts: 601 133.80 NP$ (Donate)	im sorry, what i meant was is there a way to log the sites that request the image thanks for the other info __________________ _\\|/_ _\\|/_ _\\|/_ _\\|/_ _\\|/_ :confused:

12-31-2006, 05:45 PM	#5 (permalink)
Alex. NamePros Regular Join Date: Nov 2006 Location: Uk Posts: 601 133.80 NP$ (Donate)	thanks, what do you mean by sanatise? that should work ok for me, as the usage is for link exchange. __________________ _\\|/_ _\\|/_ _\\|/_ _\\|/_ _\\|/_ :confused:

12-31-2006, 06:55 PM	#7 (permalink)
Alex. NamePros Regular Join Date: Nov 2006 Location: Uk Posts: 601 133.80 NP$ (Donate)	thanks, will rep++ when i get to my pc. __________________ _\\|/_ _\\|/_ _\\|/_ _\\|/_ _\\|/_ :confused:

12-31-2006, 05:52 AM	#2 (permalink)
Peter Senior Member Join Date: Nov 2003 Location: Scotland Posts: 4,900 0.60 NP$ (Donate)	in all honesty it would be fairly easy to write something yourself. What I would do is the following:- Make a htaccess mod rewrite rule to have change a url of something like http://www.yourdomain/username/ to http://www.yourdomain.com/image.php?user=username Also create a database with a visitor referrer table with 3 fields 1 being a unique id another being their username and another being the count (username would match what is being changed in the url). When someone gets the image simply do a statement such as UPDATE tbl_name SET count=count+1; After this simply display the image. Another method for the database would be to have 1 table for the referrer and another for the visitors, the referrer table would be the same as before but without the count field. In the visitor field you would store id, referrer id, and any other details that may come in handy such as a timestamp and their ip and possibly browser agent etc.

12-31-2006, 05:26 PM	#4 (permalink)
Peter Senior Member Join Date: Nov 2003 Location: Scotland Posts: 4,900 0.60 NP$ (Donate)	If people are not going to sign up then the only way I can think of is to use $_SERVER['HTTP_REFERER'] which shows what the users browser claims to be the referrer to the current page, in this case the page that is calling the image. However before using this make sure you sanitize it and do not 100% rely on it as it can be spoofed (as can anything else provided by the user) or may not be sent at all (due to example proxies or some firewalls).

12-31-2006, 06:11 PM	#6 (permalink)
Matthew. Stud Sausage Join Date: Dec 2006 Location: England Posts: 1,546 34.41 NP$ (Donate)	By sanatise we mean to make the string safe, or to escape it in other words.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)