- 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
raj_gayu
October 8, 2012 at 09:18 am
nice one...
Dianna Clark
August 22, 2012 at 16:05 pm
Nice
jaber
August 16, 2012 at 14:23 pm
tnkz!
very nice..
samod
August 4, 2012 at 18:05 pm
thank you .
Tim
July 29, 2012 at 18:28 pm
never mind :) figured it out.. again very nice
Sasho Valkanov
July 30, 2012 at 14:50 pm
Welcome :)
Tim
July 29, 2012 at 16:34 pm
does this script except affiliate links? I keep getting a error when I try loading in the sql. it cuts off at the first link ( /aff/?ID )
Tim
July 29, 2012 at 15:19 pm
nice script , but call me silly How do you add links to it?
Christos Amarandos
July 21, 2012 at 16:34 pm
This is great for PTH (Pay to Host) schemes.
Mohammad Raihan Mazumder
July 1, 2012 at 06:59 am
its wonderful. but i cant download it.
Sasho Valkanov
July 30, 2012 at 14:51 pm
Can you please try different browser.
maan
June 4, 2012 at 07:25 am
love it