PHP Forum

**joeldavis** · 07-30-2009, 02:43 PM

I've got a php redirect file for a site that I instantly want my affiliate code redirected to the home site (home site is not mine). How can I keep tabs on how many redirects the site makes, other than from my control panel within my hosting account? Thanks for the help.

**danielsolution** · 07-30-2009, 02:57 PM

How is your redirect occuring? There are a couple of ways to track hits to that page - depending on the redirect method.

Let me know,
Daniel

**joeldavis** · 07-30-2009, 03:50 PM

I uploaded a php file named index.php to my site's directory, which redirects it to the site my affiliate link takes it to automatically. The index.php script is written below:

<?php header("Location: http:/myaffiliatelink.com
"); ?><html><head><title>redirect</title><meta http-equiv=Content-Type content="text/html; charset=iso-8859-1"></head><body></body></html>

I appreciate your help.

**danielsolution** · 07-30-2009, 05:20 PM

Do you have access to a dbase (MySQL) on that server. If so you can create a function to add / update the number of views before sending the php header and doing the redirect.

This would only take a few lines of code and would of course require a page created to show you how many hits were sent thru that redirect.

I can help you throw that together, if you like.

**danielsolution** · 07-30-2009, 05:36 PM

We would open a dbase connection as such:

PHP Code:


			
<?php

mysql_connect("localhost", "admin", "1admin") or die(mysql_error());



mysql_select_db("test") or die(mysql_error());



?>

Then update a table/field;

PHP Code:


			


$tracker_sql = "UPDATE `your_table` SET `views` = `views`+1";



$track_it = mysql_query( $tracker_sql ); die("Couldn't execute query. ");

Then set the header redirect as you have it now...

This is just written here and I have obviously not tested it - let me know if you need a working version.