Studge.com

Very nice piece of code here, thanks so much. I’ll be blogging about it to send a few people over, I think others will find this useful too .

Is there any chance of getting some simple code to view the stats so we don’t have to go into phpmyadmin for that?

[...] Hiding Links With PHP and Counting Clicks with MySQL [...]

[...] at SuperAff.com has asked about a follow up to a previous post Hiding Links With PHP and Counting Clicks with MySQL. In this article I demonstrated how to hide links (affiliate or otherwise) and count how many times [...]

[...] Hiding Links With PHP and Counting Clicks with MySQL | Studge There are many reasons why one might want to hide their links – perhaps you are are an affiliate marketer, the link is really long and dirty or you are simply wanting to implement a system that counts how many times a certain link is clicked (more on th (tags: php seo mysql tools affiliate links) [...]

[...] has found a simple solution for cloaking affiliate links and gotten the designer to write some more code to make tracking the clicks simpler.  This is [...]

[...] had quoted an article from Studge.com which gives you PHP code to cloak affiliate links as well as click tracking by using MySQL database [...]

[...] My personal favourite from this list is this one from Hiding Links With PHP and Counting Clicks with MySQL [...]

Hi,
i had a problem.
If someone type his own id it wil be displayed in my database but its not a valid ID.
And i’did like a default redirect (Not displayed in the database), so even if there is no ?id= in the url.

Can you please help me.

Niels Harland

(Sorry for the bad English)

Niels, your problem is easily solved – first, you would need to manually create the database rows for Google, Yahoo! and Wikipedia in the linkcount table. Then edit the following bit of code:

if(mysql_num_rows($result) == 0) {
  	mysql_query("INSERT INTO linkcount (id) VALUES ('$id')")
          or die(mysql_error());
	mysql_query("UPDATE linkcount SET count=count+1 WHERE id='$id'")
          or die(mysql_error());
  } else {
	mysql_query("UPDATE linkcount SET count=count+1 WHERE id='$id'")
          or die(mysql_error());
  }

to this:

if(mysql_num_rows($result) == 0) {
  	header("Location: http://example.com/invalid-link.php");
        exit;
  } else {
	mysql_query("UPDATE linkcount SET count=count+1 WHERE id='$id'")
          or die(mysql_error());
  }

You will need to create some sort of invalid-link.php page that will serve as the default landing page for bad ?id= requests.

[...] so good I decided to write a quick follow up to let you all know too.   Firstly a guy over at http://studge.com/hiding-links-with-php-and-counting-clicks-with-mysql/ has made a superb and very easy to follow guide on cloaking links using php while being able to [...]

i couldn’t find anything on german websites and i took me a long time to find this tutorial. great job and thank you very much. i also have some sites, where i like to hide the affiliate-links. your script even counts the clicks. again: well done.

RE mysql_connect(“mysql.example.com”
Can you translate that syntax into form which has
$database['host'] = ‘localhost’;
$database['username'] = ‘uname’;
$database['password'] = ‘upw’;
at http://domain.com
I would like to try it out.

Thanks for the great script. I’m going to do a cashback shopping site. I am also wondering how to track whether a member (registered user) actually makes a purchase after clicking my affiliate link. Because I plan to give some cash back to members when they make a purchase through my link.

I am wondering how to track who makes a purchase at what time? You don’t need to give the script, I only need to know ‘how’.

Thank you so much!

This post is definitely worth a comment. Do you have any idea how long I have been looking for a code like this??! I am thinking there must be a way to add the referrer to this code too. This way you could get a click count, and see where that click came from. I’ll be bookmarking this page and checking back. Great post!!

Great code, although it doesn’t seem to work with affiliate future’s links which start with http://scripts.affiliatefuture.com/AFClick.asp?affiliateID

any suggestions on how I can make it work? It just stops at af’s homepage?

How can you make this work with several products,without adding each one by hand?

great script

Did work for us too. Thanks!

Very clean code, thanks a bunch!

uh oh. this is VERY BAD. if you run a directory or some link exchange website than this will actually do no good to the websites you are linking to and it can even harm you As far as Google is concerned (or any other search engine) you are not pointing to any particular website with these links but rather to a page with no content (as your redirect.php generates no output). Therefore, these links will not be considered neither outbound links nor inbound links. In what regards the search engines, you have a lot of links pointing nowhere…

But, the solution is quite simple and you won’t have to scrap all your code

Before the line

header(“Location:”.$links[$id]);

add

header( “HTTP/1.1 301 Moved Permanently” );

And ta-da, your links are all SEO friendly.

Now, because I was useful, please visit my php relate blog at Zebra PHP Components Framework” and my Do-it yourself Internet promotion website

Is there a similar script that will support links stored in MySQL that are displayed on pages via a php echo from a recordset? Each link is in it’s own record along with the affiliate name.
thx,
Dave

[...] Redirect Scripts (if you love codes try Studge) [...]

If this could be made into a wordpress plugin, it would be of very great help for non-coders out here. Anyone up for the challenge?

[...] counts all the links together. I am not that good at PHP, but the code I used can be found here:rrhttp://studge.com/hiding-links-with-php-and-counting-clicks-with-mysql/rrYou can use the above code or not, your choice.rrI want the clicks displayed in a graph, you can [...]

Hey, thank you, but in the meantime it could be solved easier, isn´t it? Especially if you you use a Wordpressinstallation combined with the widget solving this.

Thanks! Came up 2nd result on google when searching “php redirect script count clicks” this is exactly what I needed.

Thank you for this great script! This is what I need!

I may have missed this, but is it possible to tweak the code to have it count only unique clicks? I’d like to use the script to power a number of “Like” buttons on our pages, but I don’t want people to be able to artificially drive up the scores.

I’m not sure of how affiliate links work but the php code here basically puts a link inside the url bar of your browser. i.e the link that you click on will say http://www.mydomain.com/advert.php?ad=1 and then when you click it the browser url will show http://www.someaffiliateprogram.com/affid=12345. If the user wants to remove this all he really needs to do is remove the affid=12345 in the url and hit enter. If i’m mistaken can someone please set me straight.

Thanks
Clinton

thanks for the clear explanation you are awesome!

The lastet update is that google can follow links over php header links.

On one of my websites i have just changed my redirect script that i have used over years to a javascript version loaded inside a noindex, nofollow page.

the linkedsite.com will get backlink juice…

now..

Redirect to

<!–
window.location = "http://”;
//–>

Going to give it a try. Thanks for the howto.

thanks for you advice and your share