Solved

How can I write a PHP/MySQL script that pulls up as many banners on a webpage as I want by sponsor position.

Posted on 2014-11-04
2
220 Views
Last Modified: 2014-11-20
How can I write a PHP/MySQL script that pulls up as many banners on a webpage as I want by sponsor position.  Jim was sponsored by Bob and has to click each banner to get in the program. In other words:
Bob was sponsored by
Sally who was sponsored by
Fred who was sponsored by
Jack who was sponsored by
Jill.

In effect, I'm pulling up his upline's banners for the webpage.

I want 12 banners to a page, so, I need to pull up 7 more banners for my webpage from a database and then put them at the bottom of the line in that database so new banners get pulled up next time.

I also want to record the clicks for Jim and for the people who's banners are clicked.
0
Comment
Question by:QUESTOMNI
2 Comments
 
LVL 108

Accepted Solution

by:
Ray Paseur earned 500 total points
ID: 40423720
Assuming you want to do this in PHP and MySQL you would either need to learn the basics of PHP and MySQL or you would need to hire a programmer who already knew PHP and MySQL.  If you choose to learn it yourself, this article can help guide you to the right learning resources and more importantly, can help you avoid the many terrible examples of wrong/obsolete PHP code that litter the internet.
http://www.experts-exchange.com/Programming/Languages/Scripting/PHP/A_11769-And-by-the-way-I-am-new-to-PHP.html

You may also find that there are some workable or adaptable plug-ins for popular web CMS systems, such as WordPress, Joomla or Drupal.
0
 

Author Comment

by:QUESTOMNI
ID: 40425392
I know enough basics to understand an explanation from a knowledgeable programmer or guy who knows PHP and MySQL.

I'm assuming that's not you. If so, why would you answer the post? If you know the answer, why would you deny me? It can't be that hard to explain.

It obviously has to do with assigning ID's to those sponsored that connect them with the sponsor. Seems to me that the banners would have that information in order to put a tracker on them to count the clicks and attribute them to each party. I would think you could direct me to someone with similar codes already done that I could draw from. Maybe it's not all in one application. You may be holding up getting the question answered by doing what you did. I'm thinking it's a pretty armature question for someone of knowledge about PHP and MySQL.

In order to pull up extra banners from a database and put them on the webpage would involve a counter and where to post them, I'm thinking. The database would have to be separate from the member database. Maybe a flat file database would be better since I want to take as many needed from the top to fill the required 12 spots to be clicked. That would seem easier to put them at the bottom of the database without dealing with the primary key problem which is likely auto incremented.

Hey, I'm just looking for more details. That's why I keep this account. I'm not asking you to write it for me but to give me proper instructions on procedures.

"Deconstruct Problems Until They Are Small Enough to Solve at a Glance" seems to be the best info I can use at the time. I have no idea of where to find a programmer or what prices they charge. That would be helpful.

Haven't looked at the plug-ins for popular web CMS systems, such as WordPress, Joomla or Drupal as yet. Maybe they will be helpful. Don't have the slightest idea of what I'd be looking for there.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Suggested Solutions

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
The viewer will learn how to count occurrences of each item in an array.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now