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
233 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 110

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

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

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

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
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 …

630 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