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
221 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Foreword (July, 2015) Since I first wrote this article, years ago, a great many more people have begun using the internet.  They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

863 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

20 Experts available now in Live!

Get 1:1 Help Now