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
222 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 109

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

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…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

776 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