- 27075 Downloads
- Price: FREE
Banner and Link Click Counter
- version 1.0
- price: free
- 4,785 downloads
description
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.
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.
download
To download Banner and Link Click Counter for FREE you need to login your account.
how to install
Follow these steps to run this Link and Banner click counter free php script1) open database.sql and import all the MYSQL queries in your database. There is a sample record added to the database too.
2) edit config.php file and set MySQL login details to connect to your database
3) using your web browser open example-page.html page and you will see a link. Once you click on that link you will be taken to PHPjabbers.com website home page and your click will be counted. Every time you click on a link the count will increase
4) using your web browser open stat.php and you will see a table with all links in the MySQL table and click count for each one
kvinlon
November 14, 2013 at 15:09 pm
Thanks
Wajid ali
December 7, 2013 at 21:09 pm
very nice web site
anna
November 12, 2013 at 20:45 pm
nice
nfe
November 1, 2013 at 05:10 am
good
abhisek
October 24, 2013 at 09:13 am
thanks
Dennis Boy
August 24, 2013 at 20:27 pm
thanks that I've for a remedy for my website
dasdasd
August 1, 2013 at 18:53 pm
Any chance to add impressions also?
javis
July 5, 2013 at 12:38 pm
thank s
Gus Indra
June 15, 2013 at 16:40 pm
good I like to this script for begining php knowlege
ogi
June 4, 2013 at 05:41 am
okay never mind i'll be patient one script per day
Stephan
April 4, 2013 at 16:02 pm
Download doesnt seems to work?