Tracking php redirect files

[Marcelo]

Hello!

I was wondering: is there a way to track that a php redirect file was clicked?

I am talking about this:



The file redirects , and I tried two counters but they don't work...

Thanks

[PFO]

Yes,

If you have a database, you can store click information everytime the redirect file is loaded. The number of hits will get updated according to what link was clicked.

[Marcelo]

Hmm...

How do I do that?

I have no database...

[geoffvro]

I have no database...

use a flat file to store the data

[ThePokerBank]

I'm interested in this also. Do I have to go into my cpanel to sort this out?

Can anyone give a quick guide?

[themike537]

mikebrad wrote a great post about that here:

http://www.pokeraffiliateworld.com/f...direct+program

[rceo]

Originally Posted by ThePokerBank

I'm interested in this also. Do I have to go into my cpanel to sort this out?

Can anyone give a quick guide?

This is easy for someone who knows mysql and php. But the following
tutorial is no use if you dont know anything about them. From an
experienced coder it would take about 5-30 minutes to setup
depending on the complexity of the page that prints the results.

What you need to do is:

1. create a new table to your mysql database with this query:

CREATE TABLE example(
id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
count INT)

2. add this code to your php redirect page:

mysql_connect("servername","username","password");
mysql_select_db("yourdatabasename");
mysql_query("UPDATE example SET count=(count + 1) WHERE id='0'");
mysql_close();

3. to see how many clicks you had, you would create a page that
fetches the count and prints it out. This one could be the
"admin" page and require login, which would need some more code

[mikebrad]

yeah, while that's cool and all of that, it doesn't differentiate between different clicks and different days, even.

Why not just use google analytics instead of trying to build something on your own. A little javascript within each link and viola, you can track it as simple or detailed as you like.