How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask TheDoctor Your Own Question

TheDoctor
TheDoctor, Software Engineer
Category: Programming
Satisfied Customers: 1430
Experience:  M.S. in Internet Information Systems
Type Your Programming Question Here...
TheDoctor is online now
A new question is answered every 9 seconds

**For TheDoctor** Changing to prepared statements from my

Resolved Question:

**For TheDoctor**
Changing to prepared statements from my already written code. I have several other pages I believe not as complicated as the others you helped me with. These pages work right now but need their code swapped out to prepared statements. I can give you access again, you'll also need access to my wordpress backend to edit one of these pages that has some insert PHP code in it. Also if possible some additional code written to my shows pages to show song play # XXXXX #. I'll explain. Please contact me for details. Thank you.

Dave
Submitted: 9 months ago.
Category: Programming
Expert:  TheDoctor replied 9 months ago.
Hello again Dave! Thank you for requesting me.

My previous access is working. What pages do I need to look at?
Expert:  TheDoctor replied 9 months ago.
Hello again Dave!

I have completed all of your requests. The tours pages has gone from over 4000 lines of code to 208 lines.

The testshow page now uses dynamic album names and has gone from over 800 lines of code to 295.

The other pages now use prepared statements where appropriate; and I addressed the issues that you found on the tours page.

Please let me know if you have any questions.

Please remember to rate my answer. Thank you so much and have a wonderful day!
Customer: replied 9 months ago.

TheDoctor,


 


Thank you I have noticed that the odd returns at the bottom of the tours page are gone but the count of shows on the right per year I believe are still counting those odd returns see year 2004 as an example. They maybe hidden but they are still being counted....I dont know where that data is coming from I don't believe that's in the database.


 


I may have forgotten to mention my Albums page (albums.php). Could you look at the prepared statements in that page. I hadn't notice that does GET a value and probably should have the code change.


 


Also the tours page still doesn't link the venue to a venue. The ?= is empty.


 


Thank you,


 


Dave


 


 


 


 

Customer: replied 9 months ago.

I also noticed on my tours page I had the years closed up and not visible until the viewer clicked the year other than the current year which was open when the page opened can you edit that so it still has the years other than the current year hidden away?


 


Thank you.

Customer: replied 9 months ago.

Sorry TheDoctor...
I fixed my problem with the links not working in the venues it was just because of a typo in the tours page.... but can you take a look at the other issues I still have above... and is the Tours page. Also the Albums page. Thank you.


 


Dave

Expert:  TheDoctor replied 9 months ago.
The according wasn't closed up on the other years when I got there, but I can see if I can make that happen.

I know what is going on with the tours page and I will take a look at the albums page.

Thank you
Customer: replied 9 months ago.

Yes if the according could be closed on all but the current year...


I'm going to be adding in shows that are in the future and want those accordions closed as well.... is there anyway that shows in the future can have a different row background color?


 


I tried to figure that out the other day but couldnt get it to work....

Expert:  TheDoctor replied 9 months ago.
Hello again Dave,

The tours issue with show count is resolved.

The according will be open to the current year, if the current year. The other years are closed until clicked upon.

In the tours, I added the ability to style future rows. If you add tour dates that are in the future, they will have a class on the row called future-date.

So you simply need to style that in your CSS with something like:

tr.future-date {
background-color: #00CCCC !important;
}


Of course, use whatever color and style you want.

I also changed the albums page to use prepared statements.

Please remember to rate my answer. Thank you again!
Customer: replied 9 months ago.

That all works great.


I hate to ask but I removed it before giving you the code. I did have an if statement that if there was no data in the show_page, that it says NO SETLIST AVAILABLE and it hides the main songs table, the graph, and the color legend. But the venue table is still visible. If you could fit that in I'll release the funds to you with a tip.Thank you.

Expert:  TheDoctor replied 9 months ago.
Hello again Dave!

I'll check it out and implement that for you.
Customer: replied 9 months ago.

oh and for some reason 1991 shows show no data...in the shows?

Expert:  TheDoctor replied 9 months ago.
Can you provide me with a link to that please?
Customer: replied 9 months ago.

I'm looking into that there maybe nothing in the database... but http://www.livefootsteps.org/shows/?show_id=75 this is just one of them

Customer: replied 9 months ago.

It was just the database missing content... if you could just put in the if no data in the show_page, that it says NO SETLIST AVAILABLE and it hides the main songs table, the graph, and the color legend. But the venue table is still visible. thanks

Expert:  TheDoctor replied 9 months ago.
No problem. I will contact you once that is complete.
Expert:  TheDoctor replied 9 months ago.
Hello again Dave!

That change is now made:

http://www.livefootsteps.org/shows/?show_id=103
TheDoctor, Software Engineer
Category: Programming
Satisfied Customers: 1430
Experience: M.S. in Internet Information Systems
TheDoctor and 4 other Programming Specialists are ready to help you
Customer: replied 9 months ago.

Thank you very much!!!! You've been great and excellent to work with.

Expert:  TheDoctor replied 9 months ago.
You are very welcome and thank you again!

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • ATLPROG

    Computer Software Engineer

    Satisfied Customers:

    7463
    MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
< Last | Next >
  • http://ww2.justanswer.com/uploads/SP/spatlanta2010/2011-6-23_12450_photo.64x64.gif ATLPROG's Avatar

    ATLPROG

    Computer Software Engineer

    Satisfied Customers:

    7463
    MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
  • http://ww2.justanswer.com/uploads/ComputersGuru/2010-02-13_051118_Photo41.JPG LogicPro's Avatar

    LogicPro

    Computer Software Engineer

    Satisfied Customers:

    5603
    Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.
  • http://ww2.justanswer.com/uploads/unvadim/2010-11-15_210218_avatar.jpg unvadim's Avatar

    unvadim

    Computer Software Engineer

    Satisfied Customers:

    1158
    Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.
  • http://ww2.justanswer.com/uploads/lifesaver333/2010-10-17_191349_ls.jpeg lifesaver's Avatar

    lifesaver

    Computer Software Engineer

    Satisfied Customers:

    950
    Several years of intensive programming and application development experience in various platforms.
  • http://ww2.justanswer.com/uploads/EH/ehabtutor/2012-8-2_202016_1.64x64.jpg ehabtutor's Avatar

    ehabtutor

    Computer Software Engineer

    Satisfied Customers:

    864
    Bachelor of computer science, 5+ years experience in software development, software company owner
  • http://ww2.justanswer.com/uploads/RA/rajivsharma086/2012-6-6_17128_displaypic.64x64.jpg Raj's Avatar

    Raj

    Computer Engg.

    Satisfied Customers:

    860
    BE CS, 4+ Experience in Programming and Database (ERP)
  • http://ww2.justanswer.com/uploads/eljonis/2010-01-06_130406_eljon2.jpg Eljon's Avatar

    Eljon

    Consultant

    Satisfied Customers:

    590
    11 yrs of programming (PHP, WordPress, XSL, SQL, JavaScript)