- This topic is empty.
-
Posts
-
Hi all,
Does anyone know how to use PHP and a MySQL database to count the number of clicks a link receives? I would like to count the number of clicks on each link in a dynamically generated list of links.
The links I want to track could point to pages within my own site, or they could be affiliate-tagged links pointing to casino sites. Is it even possible to track affiliate-tagged links without using some sort of redirect?
Please help!
Thanks! :bigsmile:
I would post that on a PHP forum. There is a lot of help out there for MySQL and PHP. I have done a similar thing with asp, but I do not know how to do it with PHP.
Try hotscripts.com, or just google “click tracking php mysql”
Also, here is a site which has some information on how to do this:
http://www.lowendmac.com/tech/php11.html
kw
Perhaps this will make you happy:
Thanks guys.
I have heard of phpAdsNew before…. Does anybody here use that program? If so, what do you think of it? Was it easy to set up?
How are the banners at the top of the CAP forum rotated?
Ideally I’d like to write the click tracking code myself, but if it’s going to be complicated and time consuming, I may use phpAdsNew or something similar.
Engineer wrote:Thanks guys.I have heard of phpAdsNew before…. Does anybody here use that program? If so, what do you think of it? Was it easy to set up?
How are the banners at the top of the CAP forum rotated?
Ideally I’d like to write the click tracking code myself, but if it’s going to be complicated and time consuming, I may use phpAdsNew or something similar.
I use phpAdsNew on quite a few different websites. It has been very easy to install. Basically a matter of creating a database, uploading the files, and editing one file with the database information. Not much too it.
If you decide to give it a try and have a problem, let me know I am sure that I have ran into it a time or two.
Once it is up and running, it is very simple to use.
I have only used it with the Linux/Unix server. Not sure if it will work or how it works on a Windows server.
Phpadsnew though simple to use in its functionality, it’s features and different options can be a bit overwhelming. The handbook for it is quite large and if it’s just link tracking you are concerned with it’s not worth the trouble nor will you get the best usage of it.
If your webhost uses a nice control panel, like mine, I have the ability to view stats and numbers through a variety of statistic scripts and inside them there are great statistics on clicks, visits, exits, etc for my links…
Here’s a good click tracking script…
http://www.hotscripts.com/Detailed/43975.html
but if that’s not exactly what you want I would browse through the scripts under PHP and the category CLICK TRACKING on http://www.hotscripts.com which is the best resource for all your script needs!
Hope that helps!
Thanks for the ideas guys.
Yes, it is mainly click tracking that I’m interested in, not really banner rotation. I could probably write my own php code to rotate banners, so I most likely wouldn’t use that that feature of phpAdsNew. I try to avoid things with “admin panels” and such — I would rather find an example of code that I could adapt for my own purposes.
I will look at Hotscripts and see if they have any free code I could use — thanks for the suggestion. I’ve been searching around on Google for some information also — I found a page here which is quite close to what I want to do. I don’t know how to use that to track affiliate links, though. I think I would have to first direct those links to a counter page that would count the click, and then it would immediately redirect the page to the affiliate link / landing page. I think it would work, but I wonder if that’s the only way to do it? Hmm.
I’m trying not to get bogged down with this project, but I do think it’s very important to know where visitors click on a website. When you know that, you can place your better converting links on that area of the page.
Also, it would be nice if I could verify the data recorded by the affiliate tracking software. If I count 500 clicks out to XYZ Casino, the affiliate tracking software at XYZ Casino should show 500 clicks too. If their tracking software shows only 2 clicks, then there is a serious problem, and I would have to take down all of their links.
Does anyone here pay attention to this sort of thing?
How many of you actually track clicks and look at this stuff? I know there are some people who do pay attention. I would be interested in learning how you went about it — did you write the code yourself, did you use a pre-made software program (like phpAdsNew), etc.
:blush:
