Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
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
Medium Priority
?
236 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 111

Accepted Solution

by:
Ray Paseur earned 1500 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

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…
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 create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

718 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