With this free Banner and Link Click Counter PHP script you can count how many times each link on your website is clicked. MySQL table is used to store information about all links and click count for each of them.
CREATE TABLE IF NOT EXISTS `banner_clicks` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`url` varchar(250) NOT NULL,
`clicks` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
Each link has unique ID which is used in the links you put on your website. Instead of creating an external link on your website like
<a href="http://www.google.com">Google</a>
you can just add http://www.google.com in the MySQL table and then use the ID for it to create a new link
<a href="click.php?id=1">Google</a>
Now when this link is clicked the click.php script will update the clicks count value for Google.com link and will redirect you to http://www.google.com
There is also a stats.php page which will show all the links in your MySQL database and click count for each of them.
To download Banner and Link Click Counter for FREE you need to login your account.