Banner and Link Click Counter

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="https://www.google.com">Google</a>

you can just add https://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 https://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.