With this tutorial you should learn how to make a clicks-counter for external links using PHP, MySql and JavaScript.
Between the head tags of the page that contains external links, put this JS code:
<script type="text/javascript">
function clk(id)
{
par='width=1,height=1,scrollbars=no,resizable=no,menubar=no,status=no';
url='count.php?id='+id;
window.open (url , "page_name", par);
}
</script>
And put in your <a> tags this string: onClick="clk(1)"
For example:
<a href="http:www.firstsite.com" onClick="clk(1)" target="_blank">First Site</a>
<a href="http:www.secondsite.com" onClick="clk(2)" target="_blank">Second Site</a>
Create a table in your MySql db, with these fields:
id -> Int (AutoIncrement=TRUE)
site_name -> Varchar(50)
clicks -> Int
Put some records in this table, for example:
id=1
site_name="First Site"
click=0
Now you have to create the page "count.php" and "config.php". Put these files in the same directory of the other page.
In the file "config.php" you have to put your database access data.
Example (Do not change tha name of the variables):
<?
$db_host="localhost";
$db_user="user";
$db_password="password";
$db_name="name";
$db = mysql_connect($db_host, $db_user, $db_password);
if ($db == FALSE)
die ("Error!");
mysql_select_db($db_name, $db)
or die ("Error");
?>
In the file "count.php" put this code:
<?
include('config.php');
$query="UPDATE clicks SET clicks=clicks+1 WHERE id='$_GET[id]'";
mysql_query($query,$db);
?>
<script type="text/javascript">
window.close()
</script>
This window updates the table and automatically closes itself.
Tutorial is finished, goodbye!! :-)
