dawg1 Posted May 20, 2011 Share Posted May 20, 2011 Well cause it's missing out the whole of the while bit I guess the query is not returning anything. But I'm also not sure the while loop is using the right syntax. Could you try changing the page to this and see what happens? dd3ck.php works and give me the results I want and need when not trying to post them to a div so I don't think the syntax is wrong there (but what do I rally know?). Could it be I am not calling the right variables in the function? I tried what you gave me and got the alert There was a problem while using XMLHTTP Internal Server Error Quote Link to comment https://forums.phpfreaks.com/topic/209322-how-to-change-3-dropdown-list-without-page-reloading-some-help-please/page/2/#findComment-1217993 Share on other sites More sharing options...
chipowski Posted May 20, 2011 Share Posted May 20, 2011 ok. no you're right - if your php does work when not posting to a div then there's something else up. i can't really look into this properly till I'm back home. will get back to you soon Quote Link to comment https://forums.phpfreaks.com/topic/209322-how-to-change-3-dropdown-list-without-page-reloading-some-help-please/page/2/#findComment-1218004 Share on other sites More sharing options...
chipowski Posted May 21, 2011 Share Posted May 21, 2011 The reason the query is returning nothing is because the selected values are are not posting to dd3ck.php. Not sure why this is happening at the moment. Quote Link to comment https://forums.phpfreaks.com/topic/209322-how-to-change-3-dropdown-list-without-page-reloading-some-help-please/page/2/#findComment-1218382 Share on other sites More sharing options...
chipowski Posted May 23, 2011 Share Posted May 23, 2011 Hi. Can you repost or attach your main.php with the new function that was added. Are find course and find curr the same as when you first posted them? I just want to make sure I'm looking at the right code. Quote Link to comment https://forums.phpfreaks.com/topic/209322-how-to-change-3-dropdown-list-without-page-reloading-some-help-please/page/2/#findComment-1219020 Share on other sites More sharing options...
dawg1 Posted May 23, 2011 Share Posted May 23, 2011 main.php <!doctype html public "-//w3c//dtd html 3.2//en"> <html> <head> <title>OCBS Textbooks</title> <meta name="GENERATOR" content="Arachnophilia 4.0"> <meta name="FORMATTER" content="Arachnophilia 4.0"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta http-equiv="Content-Style-Type" content="text/css"> <link href="css/00000001/style.css" rel="stylesheet" type="text/css"> <link href="css/00000001/layout.css" rel="stylesheet" type="text/css"> <script language="javascript" type="text/javascript"> // Roshan's Ajax dropdown code with php // This notice must stay intact for legal use // Copyright reserved to Roshan Bhattarai - nepaliboy007@yahoo.com // If you have any problem contact me at http://roshanbh.com.np function getXMLHTTP() { //fuction to return the xml http object var xmlhttp=false; try{ xmlhttp=new XMLHttpRequest(); } catch(e) { try{ xmlhttp= new ActiveXObject("Microsoft.XMLHTTP"); } catch(e){ try{ xmlhttp = new ActiveXObject("Msxml2.XMLHTTP"); } catch(e1){ xmlhttp=false; } } } return xmlhttp; } function get_CURR(TERM) { var strURL="findCURR.php?TERM="+TERM; var req = getXMLHTTP(); if (req) { req.onreadystatechange = function() { if (req.readyState == 4) { // only if "OK" if (req.status == 200) { document.getElementById('CURR_div').innerHTML=req.responseText; } else { alert("There was a problem while using XMLHTTP:\n" + req.statusText); } } } req.open("GET", strURL, true); req.send(null); } } function get_COURSE(CURR) { var strURL="findCOURSE.php?CURR="+CURR; var req = getXMLHTTP(); if (req) { req.onreadystatechange = function() { if (req.readyState == 4) { // only if "OK" if (req.status == 200) { document.getElementById('COURSE_div').innerHTML=req.responseText; } else { alert("There was a problem while using XMLHTTP:\n" + req.statusText); } } } req.open("GET", strURL, true); req.send(null); } } function get_Results(TERM,CURR,COURSE) { var strURL="textbookresults.php?TERM="+TERM+"&CURR="+CURR+"&COURSE="+COURSE; var req = getXMLHTTP(); if (req) { req.onreadystatechange = function() { if (req.readyState == 4) { // only if "OK" if (req.status == 200) { alert("Response "+req.responseText); document.getElementById('RESULTS_div').innerHTML=req.responseText; } else { alert("There was a problem while using XMLHTTP:\n" + req.statusText); } } } req.open("GET", strURL, true); req.send(null); } } </script> <script type="text/javascript" src="js/jquery-1.3.2.min.js"></script> <script type="text/javascript" src="js/cufon-yui.js"></script> <script type="text/javascript" src="js/Futura_MdCn_BT_400.font.js"></script> <script type="text/javascript" src="js/cufon-replace.js"></script> <script type="text/javascript" src="js/maxheight.js"></script> <script type="text/javascript">var GB_ROOT_DIR = "http://shopocbs.com/greybox/";</script> <script type="text/javascript" src="greybox/AJS.js"></script> <script type="text/javascript" src="greybox/AJS_fx.js"></script> <script type="text/javascript" src="greybox/gb_scripts.js"></script> <link href="greybox/gb_styles.css" rel="stylesheet" type="text/css"> <!--[if lt IE 7]> <link href="ie.css" rel="stylesheet" type="text/css" /> <![endif]--> </head> <body id="page2" onload="new ElementMaxHeight();"> <div id="main-tail-hor"> <div id="main-bg"> <div id="main-tail-ver"> <div id="main-bg-top"> <div id="main-bg-bot"> <div id="main"> <!-- header --> <div id="textbookheader"> <a href="shopocbs.com"><img src="graphics/00000001/images/logo.gif" id="logo" alt=""></a> <a href="#" id="rss">RSS Submit</a> <div id="menu"> <ul> <li><a href="http://www.shopocbs.com/ABUS.html"><span><span>Store Info</span></span></a></li> <li><a href="http://www.shopocbs.com/Apply.html"><span><span>Apply</span></span></a></li> <li><a href="http://www.shopocbs.com/TSRV.html"><span><span>Tech Services</span></span></a></li> <li><a href="http://www.shopocbs.com/GEAR.html"><span><span>UGA Gear</span></span></a></li> <li class="act"><a href="#"><span><span>TEXTBOOKS</span></span></a></li> </ul> </div> <div id="HOME" onclick="location.href='http://www.shopocbs.com';" style="cursor:pointer;"></div> <img src="graphics/00000001/images/textbookslogan.gif" id="slogan" alt=""> </div> <!-- content --> <div id="content"> <div class="row-1"> <div class="wrapper"> <div class="col-1 maxheight"> <h2><b><b>Select Your Books</b></b></h2> <div class="indent-1"> <form method=post name=textbookform action='textbookresults.php' target='iframe'> <div id="first_drop_down"> <select name="TERM" onChange="get_CURR(this.value)"> <option>Select Term</option> <option value=SU11>SU11</option> </select> </div> <div id="CURR_div"><select><option>Select Term First</option></select></div> <div id="COURSE_div"><select><option>Select Curriculum First</option></select></div><br /> <input type="button" value="Get My Books" onClick="get_Results();"> </form></div> <div class="indent-1"> <h4>Textbook Rental Program</h4> <a href="http://www.shopocbs.com/rentals.html" onclick="return GB_showCenter('Rental Agreement', this.href)" class="link">Rental Agreement</a> <div class="clear"></div> <a href="#" class="link">Registration Form</a> </div> <div class="indent-1"> <h4>Baxter Street Bookstore</h4> <a href="#" class="link">UGA Law School Books</a> </div> <div class="indent-1"> <h4>East Campus Bookstore</h4> <a href="http://www.ecbsonline.com" class="link">UGA IDL Books</a> <div class="clear"></div> <a href="http://wwww.ecbsonline.com" class="link">Athens Tech Books</a> <div class="clear"></div> <a href="http://ecbsonline.com" class="link">GSC Books</a> <div class="clear"></div> </div> </div> <div class="col-2 maxheight"> <h2><b><b>Your Textbook Information</b></b></h2> <div class="indent-1"> <iframe id="iframe" name="iframe" width="100%" height="35%"> <p>Your browser does not support iframes.</p> </iframe></div> </div> </div> </div> </div> <div class="row-2"> <h3><span><span><strong>Interesting Links</strong></span></span></h3> <div class="box"> <div class="inner-1"> <div class="wrapper"> <ul class="list-2"> <li> <a href="http://oasisweb.uga.edu"><img src="graphics/00000001/images/oasis.jpg" alt="Oasis Web" /></a> <strong><a href="http://oasisweb.uga.edu">Oasisweb.uga.edu</a></strong> Online Access to UGA Student Information Systems </li> <li> <a href="http://www.studentnotes.com/UGAstudent_notes.html"><img src="graphics/00000001/images/student_notes.jpg" alt="Student Notes" /></a> <strong><a href="http://www.studentnotes.com/UGAstudent_notes.html">Student Notes</a></strong>Study Guides complied by students with a 3.4+ G.P.A.</li> <li><a href="http://www.secsports.com"><img src="graphics/00000001/images/sec.jpg" alt="SEC Sports" /></a> <strong><a href="http://www.secsports.com">SECsports.com</a></strong> The official site of the Southeastern Conference </li> <li class="extra"> <a href="http://www.dawgwear.net"><img src="graphics/00000001/images/dawgwear.jpg" alt="Dawgwear.net" /></a> <strong><a href="http://www.dawgwear.net">Dawgwear.net</a></strong> UGA Merchandise, apparel, gifts, Diploma Frames, and more!</li> </ul> </div> </div> </div> </div> </div> <!-- footer --> <div id="footer"> <p>OCBS, Inc.<span> © 2009</span> | <a href="http://www.facebook.com/pages/Off-Campus-Bookstore/51670009168" target="blank"> <img src="facebook_footer.png" alt="Find us on Facebook" /></a></p> </div> </div> </div> </div> </div> </div> </div> <script type="text/javascript"> Cufon.now(); </script> </body> </html> I think these are the same but I will report them just to make sure... findCURR <!--//---------------------------------+ // Developed by Roshan Bhattarai | // http://roshanbh.com.np | // Contact for custom scripts | // or implementation help. | // email-nepaliboy007@yahoo.com | //---------------------------------+--> <? #### Roshan's Ajax dropdown code with php #### Copyright reserved to Roshan Bhattarai - nepaliboy007@yahoo.com #### if you have any problem contact me at http://roshanbh.com.np #### fell free to visit my blog http://roshanbh.com.np ?> <select name="CURR" onchange="get_COURSE(this.value)"> <option>Select Curriculum</option> <?php require "config.php"; $TERM=$_GET['TERM']; $query = "SELECT DISTINCT CURR FROM UGASU11 WHERE TERM = '$TERM' order by CURR"; $result=mysql_query($query); while($row=mysql_fetch_array($result)) { ?> <option value=<?php echo $row['CURR']?>><?php echo $row['CURR']?></option> <? } ?> </select> findCOURSE <!--//---------------------------------+ // Developed by Roshan Bhattarai | // http://roshanbh.com.np | // Contact for custom scripts | // or implementation help. | // email-nepaliboy007@yahoo.com | //---------------------------------+--> <? #### Roshan's Ajax dropdown code with php #### Copyright reserved to Roshan Bhattarai - nepaliboy007@yahoo.com #### if you have any problem contact me at http://roshanbh.com.np #### fell free to visit my blog http://roshanbh.com.np ?> <select name="COURSE"> <option>Select Course</option> <?php require "config.php"; $CURR=$_GET['CURR']; $query = "SELECT DISTINCT COURSE FROM UGASU11 WHERE CURR = '$CURR' order by COURSE"; $result=mysql_query($query); while($row=mysql_fetch_array($result)) { ?> <option value=<?php echo $row['COURSE']?>><?php echo $row['COURSE']?></option> <? } ?> </select> Quote Link to comment https://forums.phpfreaks.com/topic/209322-how-to-change-3-dropdown-list-without-page-reloading-some-help-please/page/2/#findComment-1219125 Share on other sites More sharing options...
dawg1 Posted May 25, 2011 Share Posted May 25, 2011 the alert box is telling me that my variables (TERM,CURR,COURSE) are undefined... Quote Link to comment https://forums.phpfreaks.com/topic/209322-how-to-change-3-dropdown-list-without-page-reloading-some-help-please/page/2/#findComment-1220106 Share on other sites More sharing options...
dawg1 Posted May 25, 2011 Share Posted May 25, 2011 RESOLVED! I don't know why I didn't think of this earlier, but I didn't need to string my variables together (TERM,CURR,COURSE) as the function somehow already stored the first two variables. Quote Link to comment https://forums.phpfreaks.com/topic/209322-how-to-change-3-dropdown-list-without-page-reloading-some-help-please/page/2/#findComment-1220128 Share on other sites More sharing options...
chipowski Posted May 25, 2011 Share Posted May 25, 2011 Cool. So is everything working as it should now? Quote Link to comment https://forums.phpfreaks.com/topic/209322-how-to-change-3-dropdown-list-without-page-reloading-some-help-please/page/2/#findComment-1220132 Share on other sites More sharing options...
dawg1 Posted May 25, 2011 Share Posted May 25, 2011 It is. Thank You SO MUCH for all of your help! I really can't give you even praise and thanks! Quote Link to comment https://forums.phpfreaks.com/topic/209322-how-to-change-3-dropdown-list-without-page-reloading-some-help-please/page/2/#findComment-1220140 Share on other sites More sharing options...
dawg1 Posted June 2, 2011 Share Posted June 2, 2011 so... it isn't working as I need it to. The last function get_Results is only calling the COURSE variable. I need it to call TERM, CURR, and COURSE in order to find the correct results. Quote Link to comment https://forums.phpfreaks.com/topic/209322-how-to-change-3-dropdown-list-without-page-reloading-some-help-please/page/2/#findComment-1224322 Share on other sites More sharing options...
dawg1 Posted June 3, 2011 Share Posted June 3, 2011 So far I've gotten this to work.. findCOURSE.php <select name="COURSE" onChange="get_Results(this.value)"> <option>Select Course</option> <?php require "config.php"; $CURR=$_GET['CURR']; $COURSE=$_GET['COURSE']; $query = "SELECT DISTINCT CURR, COURSE FROM UGASU11 WHERE CURR = '$CURR' order by COURSE"; $result=mysql_query($query); while($row=mysql_fetch_array($result)) { ?> <option value=<?php echo $row['CURR'],$row['COURSE']?>><?php echo $row['COURSE']?></option> <? } ?> </select> outputs... <select name="COURSE" onChange="get_Results(this.value)"> <option>Select Course</option> <option value=ADPR3110>3110</option> <option value=ADPR3520>3520</option> <option value=ADPR5910>5910</option> <option value=ADPR5990 H>5990 H</option> </select> which is what I need. But, I can't figure out the next step. This is the function that should submit to textbooks.php for the results (doesn't work) function get_Results(CURR,COURSE) { var strURL="/textbookresults.php?CURR="+CURR+"&COURSE="+COURSE; var req = getXMLHTTP(); if (req) { req.onreadystatechange = function() { if (req.readyState == 4) { if (req.status == 200) { document.getElementById('RESULTS_div').innerHTML=req.responseText; } else { alert("There was a problem while using XMLHTTP:\n" + req.statusText); } } } req.open("GET", strURL, true); req.send(null); } } and this is the last query used to display the results... $query = "SELECT * FROM UGASU11 WHERE CURR = '$CURR' AND COURSE = '$COURSE' order by INSTRUCTOR"; Quote Link to comment https://forums.phpfreaks.com/topic/209322-how-to-change-3-dropdown-list-without-page-reloading-some-help-please/page/2/#findComment-1224667 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.