Custom PHP/mySQL Banner Rotator Scripts for affiliate membership website.
I have a membership website where members will be allowed to add banner ads and have them displayed randomly online. My site will keep display and click trough counters for member’s ads.
The scripts files you need to create:
1. 468×60.php & 125×125.php
2. counter.php
3. banners_468x60/index.php
4. optional support file
I would need to call and display random banners for each affiliate. The script will also record display and click counter/stats for each affiliate’s’ banner.
To call the script, I would use two methods: 1 – iframe and 2 – by using two links. For example, below is how I would call the script and display a banner for affiliate id = 203:
1. iframe call to be used in html :
<div align=”center”><p><iframe src=”http://mywebsite.com/banners/468×60.php?id=203″ width=”470″ height=”62″ scrolling=”no” frameborder=”0″></iframe>
2. Two links to call script if using outside website ad service (don’t know how this would be done.)
Target url: http://mywebsite.com/banners_468x60/203
Image url: http://mywebsite.com/banners_468x60/203.jpg
SCRIPT 1: Your scrip, /banners/468×60.php, would do the following:
• Open the banner 468×60 table
• $banner = the script would select the 468×60 table to get a random banner record where affiliate id = ‘203’ and active = ‘yes’
• The $banner record has the fields: target link, image link, active tag, hit counter and click counter fields. the above select would return the id number of banner record to display
• It will display clickable image:
<center><a href=”click_counter.php?id=<?php echo $banner->id ; ?>”<img src=”<?php echo $banner->target_img ; ?>”></a></center>
• It would UPDATE the $banner->hits +1 counter (not INSERT a new record like you did)
• If the image is clicked, then:
It would call click_counter.php?id=203 script in a new window
o This scrip will open and select $banner record where id = 203,
o Add +1 to the $banner->clicks field.
o Redirect user to a $banner->target_url
Script 2: display banners via two links.
This script would use the two links to display the random, active banner of affiliate. Because many ad resources ask for the two links, Target url and image url, your script would need to work by supplying these two links. For example, to display banners for affiliate id = ‘203’, use the following format:
o target url: http://mywebsite.com/banners_468x60/203
o image url: http://mywebsite.com/banners_468x60/203.jpg
The same object is the same. Display banner, add to display counter, and if Clicked, then add to click counter and redirect user to the target url.
Please read above for the details of what’s needed.
Only bid if you can do this job. No students who are just learning. do not over bid.
The past week, I’ve not had a good experience getting new people to work with so if you want to win this job, …
Please do not bid if you can not do this for $50(or less)
Please do not bid if you do not understand and know how to do option #2 above with the affiliate links.
if you have any questions, please let me know before taking job.
Also, if work is not done in reasonable amount of time, I will cancel and not pay for the work. Almost every programmer is going 4-7 days past eta… if you think this will take longer, you must communicate with me before taking the bid.
looking forward to finding good programmers to work with.
thank you
Arvell
