- 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
karim
March 16, 2013 at 15:37 pm
download link not work . please send me another link to download. thanks
himanshu
August 14, 2013 at 14:02 pm
please send me another link to download. thanks
okenesia.com
March 15, 2013 at 07:48 am
how to put his code where?
deepak
March 6, 2013 at 18:57 pm
send the download link....
melvin
February 21, 2013 at 06:40 am
good script. download it
melvin
February 21, 2013 at 06:28 am
hey its very useful .... thanks
Naveen Kumar s
January 8, 2013 at 14:52 pm
NICE...... its useful
Evrim Altay Koluaçık
December 21, 2012 at 20:38 pm
Very good script. Download it very quickly ...
Balamurugan
December 21, 2012 at 11:30 am
Its very useful.
praful
November 20, 2012 at 12:50 pm
nice................
Shivam Gautam
November 19, 2012 at 09:42 am
hey! its showing an error "request "Could not execute SQL query" SELECT * FROM banner_clicks WHERE id='1'"
Tim
January 2, 2013 at 20:02 pm
Hi Shivam;
Did you get it working? This script is one very easy one to work with.