teccyspice Posted May 8, 2009 Share Posted May 8, 2009 Hi, I've been stuck for ages trying to get a form working. A mockup is here; http://www.nutworks.co.uk/allocate/multibook.php The idea is for the user to enter the details, who, where and the date range then click on the Additional Systems checkboxes. This extracts the list of free systems from the database and displays these within the form using AJAX/Javascript. I have tried to extract the value of the individual systems when checked as the php script puts these in a reference[] array but I cant get any values from the updated form, reference[] does not seem to exist. I'm obviously missing something but my php skills are limited and my java/ajax are kinda limited to what I have done here. ========================= allocate.js /* Use AJAX functions to populate the system fieldsets with the output from the getsystems.php script */ var xmlHttp // Get the system, start and end dates function showSUN(system,frm_startdate,frm_enddate) { xmlHttp=GetXmlHttpObject() if (xmlHttp==null) { alert ("Browser does not support HTTP Request") return } // Execute getsystems.php and pass the system selected with the start and end dates from the form. var url="getsystems.php?system="+system+"&frm_startdate="+frm_startdate+"&frm_enddate="+frm_enddate // If the state is changed, changeSUN and pass the output from url. xmlHttp.onreadystatechange=changeSUN xmlHttp.open("GET",url,true) xmlHttp.send(null) } /* If the ready state = 4 (or complete) then get the Element id "txtSUN" and replace the element with the output of getsystems.php Repeat the change function for every platform type */ function changeSUN() { if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete") { document.getElementById("txtSUN").innerHTML=xmlHttp.responseText } } ========================================= getsystems.php <?php error_reporting(E_ALL); // START THE OUTPUT BUFFER ob_start(); // GET THE DATA echo "\nGET: "; var_dump($_GET); echo "\nPOST: "; var_dump($_POST); $system = ''; $frm_startdate = ''; $frm_enddate = ''; $system = $_GET["system"]; $frm_startdate = $_GET["frm_startdate"]; $frm_enddate = $_GET["frm_enddate"]; //echo "SYSTEM = " . $system . "<br>"; //echo "START_DATE = " . $frm_startdate . "<br>"; //echo "END_DATE = " . $frm_enddate . "<br>"; $con = mysql_connect($dbhost,$dbuser,$dbpass); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db($database, $con); if ( $system == "TAPE"){ $sql="SELECT DISTINCT a.location, a.hwtype, a.reference, a.make, a.model, a.sys_otherio, a.sys_tape FROM system_list a LEFT JOIN test_dates b ON b.referen ce = a.reference WHERE a.location = 'LEI' AND a.reference LIKE '%" . $system . "%' AND a.reference NOT IN ( SELECT DISTINCT l.reference FROM system_list l L EFT JOIN test_dates d ON d.reference = l.reference WHERE d.reference IS NOT null AND ( d.start_date BETWEEN '" . $frm_startdate . "' AND '" . $frm_enddate . "' OR d.end_date BETWEEN '" . $frm_startdate . "' AND '" . $frm_enddate . "' OR (d.start_date <= '" . $frm_startdate . "' AND d.end_date >= '" . $f rm_enddate . "'))) GROUP BY a.reference ORDER BY a.sys_tape"; //echo $sql; } else { $sql="SELECT DISTINCT a.location, a.hwtype, a.reference, a.make, a.model, a.sys_numcpu, a.sys_cputype, a.sys_memory, a.sys_totaldisk, a.sys_disk, a.sys_cd dvd, a.sys_network, a.sys_otherio, a.sys_tape FROM system_list a LEFT JOIN test_dates b ON b.reference = a.reference WHERE a.reference LIKE 'QS-" . $system . "%' AND a.reference NOT IN ( SELECT DISTINCT l.reference FROM system_list l LEFT JOIN test_dates d ON d.reference = l.reference WHERE d.reference IS NOT nu ll AND ( d.start_date BETWEEN '" . $frm_startdate . "' AND '" . $frm_enddate . "' OR d.end_date BETWEEN '" . $frm_startdate . "' AND '" . $frm_enddate . "' OR (d.start_date <= '" . $frm_startdate . "' AND d.end_date >= '" . $frm_enddate . "'))) GROUP BY a.reference"; //echo $sql; } $result = mysql_query($sql); while($row = mysql_fetch_array($result)) { if ( $system == "SUN" ){ $systemtip = $row['reference'] . "<br>" . $row['model'] . "<br>" . $row['sys_numcpu'] . " x " . $row['sys_cputype'] . "<br>" . $row['sys_memory'] . " MB Memory<br>" . $row['sys_totaldisk'] . " GB Disk (" . $row['sys_disk'] . "GB )<br>" . $row['sys_cddvd'] . "<br>" . $row['sys_network'] . "<br>" . $row['sy s_otherio'] . "<br>" . $row['sys_tape'] . "<br>"; $systemref = $row['reference'] . "<br> <small>" . $row['model'] . "</small><br>"; } if ( $system == "HP"){ $systemtip = $row['reference'] . "<br>" . $row['model'] . "<br>" . $row['sys_numcpu'] . " x " . $row['sys_cputype'] . "<br>" . $row['sys_memory'] . " MB Memory<br>" . $row['sys_totaldisk'] . " GB Disk (" . $row['sys_disk'] . "GB )<br>" . $row['sys_cddvd'] . "<br>" . $row['sys_network'] . "<br>" . $row['sy s_otherio'] . "<br>" . $row['sys_tape'] . "<br>"; $systemref = $row['reference'] . "<br> <small>" . $row['model'] . "</small><br>"; } if ( $system == "RS"){ $systemtip = $row['reference'] . "<br>" . $row['model'] . "<br>" . $row['sys_numcpu'] . " x " . $row['sys_cputype'] . "<br>" . $row['sys_memory'] . " MB Memory<br>" . $row['sys_totaldisk'] . " GB Disk (" . $row['sys_disk'] . "GB )<br>" . $row['sys_cddvd'] . "<br>" . $row['sys_network'] . "<br>" . $row['sy s_otherio'] . "<br>" . $row['sys_tape'] . "<br>"; $systemref = $row['reference'] . "<br> <small>" . $row['model'] . "</small><br>"; } if ( $system == "INTEL"){ $systemtip = $row['reference'] . "<br>" . $row['model'] . "<br>" . $row['sys_numcpu'] . " x " . $row['sys_cputype'] . "<br>" . $row['sys_memory'] . " MB Memory<br>" . $row['sys_totaldisk'] . " GB Disk (" . $row['sys_disk'] . "GB )<br>" . $row['sys_cddvd'] . "<br>" . $row['sys_network'] . "<br>" . $row['sy s_otherio'] . "<br>" . $row['sys_tape'] . "<br>"; $systemref = $row['reference'] . "<br> <small>" . $row['model'] . "</small><br>"; } if ( $system == "AS400"){ $systemtip = $row['reference'] . "<br>" . $row['model'] . "<br>" . $row['sys_numcpu'] . " x " . $row['sys_cputype'] . "<br>" . $row['sys_memory'] . " MB Memory<br>" . $row['sys_totaldisk'] . " GB Disk (" . $row['sys_disk'] . "GB )<br>" . $row['sys_cddvd'] . "<br>" . $row['sys_network'] . "<br>" . $row['sy s_otherio'] . "<br>" . $row['sys_tape'] . "<br>"; $systemref = $row['reference'] . "<br> <small>" . $row['model'] . "</small><br>"; } if ( $system == "DISK"){ $systemtip = $row['reference'] . "<br>" . $row['model'] . "<br>"; $systemtip = $row['reference'] . "<br>" . $row['model'] . "<br>" . $row['sys_totaldisk'] . " GB Disk (" . $row['sys_disk'] . "GB )<br>" . $row['sys_o therio'] . "<br>"; $systemref = $row['reference'] . "<br> <small>" . $row['model'] . "</small><br>"; } if ( $system == "TAPE"){ $systemtip = $row['reference'] . "<br>" . $row['model'] . "<br>"; $systemref = $row['reference'] . "<br> <small>" . $row['sys_tape'] . " - " . $row['sys_otherio'] . "</small><br>"; } if ( $system == "MTS"){ $systemtip = $row['reference'] . "<br>" . $row['model'] . "<br>"; $systemref = $row['reference'] . "<br> <small>" . $row['model'] . "</small><br>"; } if ( $system == "CON"){ $systemtip = $row['reference'] . "<br>" . $row['model'] . "<br>"; $systemref = $row['reference'] . "<br> <small>" . $row['model'] . "</small><br>"; } echo "<div class='reference'><input type='checkbox' name='" . $row['reference'] . "' id='" . $row['reference'] . "' /><a onmouseover=\"Tip('" . $systemt ip . "',TITLE,'SYSTEM INFORMATION',TITLEALIGN,'center',SHADOW,'true')\" onmouseout=\"UnTip()\">" . $systemref . "</a></div>"; } mysql_close($con); ?> Quote Link to comment https://forums.phpfreaks.com/topic/157351-extracting-info-from-a-database-and-adding-checkboxes-to-an-existing-form/ Share on other sites More sharing options...
Ken2k7 Posted May 8, 2009 Share Posted May 8, 2009 Please read #4 of Forum DOs using the link in my signature. And while you're at it, please read the others. Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/157351-extracting-info-from-a-database-and-adding-checkboxes-to-an-existing-form/#findComment-829415 Share on other sites More sharing options...
teccyspice Posted May 8, 2009 Author Share Posted May 8, 2009 sorry about that... I'll preview next time. allocate.js /* Use AJAX functions to populate the system fieldsets with the output from the getsystems.php script */ var xmlHttp // Get the system, start and end dates function showSUN(system,frm_startdate,frm_enddate) { xmlHttp=GetXmlHttpObject() if (xmlHttp==null) { alert ("Browser does not support HTTP Request") return } // Execute getsystems.php and pass the system selected with the start and end dates from the form. var url="getsystems.php?system="+system+"&frm_startdate="+frm_startdate+"&frm_enddate="+frm_enddate // If the state is changed, changeSUN and pass the output from url. xmlHttp.onreadystatechange=changeSUN xmlHttp.open("GET",url,true) xmlHttp.send(null) } /* If the ready state = 4 (or complete) then get the Element id "txtSUN" and replace the element with the output of getsystems.php Repeat the change function for every platform type */ function changeSUN() { if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete") { document.getElementById("txtSUN").innerHTML=xmlHttp.responseText } } getsystems.php <?php error_reporting(E_ALL); // START THE OUTPUT BUFFER ob_start(); // GET THE DATA echo "\nGET: "; var_dump($_GET); echo "\nPOST: "; var_dump($_POST); $system = ''; $frm_startdate = ''; $frm_enddate = ''; $system = $_GET["system"]; $frm_startdate = $_GET["frm_startdate"]; $frm_enddate = $_GET["frm_enddate"]; //echo "SYSTEM = " . $system . "<br>"; //echo "START_DATE = " . $frm_startdate . "<br>"; //echo "END_DATE = " . $frm_enddate . "<br>"; $con = mysql_connect($dbhost,$dbuser,$dbpass); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db($database, $con); if ( $system == "TAPE"){ $sql="SELECT DISTINCT a.location, a.hwtype, a.reference, a.make, a.model, a.sys_otherio, a.sys_tape FROM system_list a LEFT JOIN test_dates b ON b.referen ce = a.reference WHERE a.location = 'LEI' AND a.reference LIKE '%" . $system . "%' AND a.reference NOT IN ( SELECT DISTINCT l.reference FROM system_list l L EFT JOIN test_dates d ON d.reference = l.reference WHERE d.reference IS NOT null AND ( d.start_date BETWEEN '" . $frm_startdate . "' AND '" . $frm_enddate . "' OR d.end_date BETWEEN '" . $frm_startdate . "' AND '" . $frm_enddate . "' OR (d.start_date <= '" . $frm_startdate . "' AND d.end_date >= '" . $f rm_enddate . "'))) GROUP BY a.reference ORDER BY a.sys_tape"; //echo $sql; } else { $sql="SELECT DISTINCT a.location, a.hwtype, a.reference, a.make, a.model, a.sys_numcpu, a.sys_cputype, a.sys_memory, a.sys_totaldisk, a.sys_disk, a.sys_cd dvd, a.sys_network, a.sys_otherio, a.sys_tape FROM system_list a LEFT JOIN test_dates b ON b.reference = a.reference WHERE a.reference LIKE 'QS-" . $system . "%' AND a.reference NOT IN ( SELECT DISTINCT l.reference FROM system_list l LEFT JOIN test_dates d ON d.reference = l.reference WHERE d.reference IS NOT nu ll AND ( d.start_date BETWEEN '" . $frm_startdate . "' AND '" . $frm_enddate . "' OR d.end_date BETWEEN '" . $frm_startdate . "' AND '" . $frm_enddate . "' OR (d.start_date <= '" . $frm_startdate . "' AND d.end_date >= '" . $frm_enddate . "'))) GROUP BY a.reference"; //echo $sql; } $result = mysql_query($sql); while($row = mysql_fetch_array($result)) { if ( $system == "SUN" ){ $systemtip = $row['reference'] . "<br>" . $row['model'] . "<br>" . $row['sys_numcpu'] . " x " . $row['sys_cputype'] . "<br>" . $row['sys_memory'] . " MB Memory<br>" . $row['sys_totaldisk'] . " GB Disk (" . $row['sys_disk'] . "GB )<br>" . $row['sys_cddvd'] . "<br>" . $row['sys_network'] . "<br>" . $row['sy s_otherio'] . "<br>" . $row['sys_tape'] . "<br>"; $systemref = $row['reference'] . "<br> <small>" . $row['model'] . "</small><br>"; } if ( $system == "HP"){ $systemtip = $row['reference'] . "<br>" . $row['model'] . "<br>" . $row['sys_numcpu'] . " x " . $row['sys_cputype'] . "<br>" . $row['sys_memory'] . " MB Memory<br>" . $row['sys_totaldisk'] . " GB Disk (" . $row['sys_disk'] . "GB )<br>" . $row['sys_cddvd'] . "<br>" . $row['sys_network'] . "<br>" . $row['sy s_otherio'] . "<br>" . $row['sys_tape'] . "<br>"; $systemref = $row['reference'] . "<br> <small>" . $row['model'] . "</small><br>"; } if ( $system == "RS"){ $systemtip = $row['reference'] . "<br>" . $row['model'] . "<br>" . $row['sys_numcpu'] . " x " . $row['sys_cputype'] . "<br>" . $row['sys_memory'] . " MB Memory<br>" . $row['sys_totaldisk'] . " GB Disk (" . $row['sys_disk'] . "GB )<br>" . $row['sys_cddvd'] . "<br>" . $row['sys_network'] . "<br>" . $row['sy s_otherio'] . "<br>" . $row['sys_tape'] . "<br>"; $systemref = $row['reference'] . "<br> <small>" . $row['model'] . "</small><br>"; } if ( $system == "INTEL"){ $systemtip = $row['reference'] . "<br>" . $row['model'] . "<br>" . $row['sys_numcpu'] . " x " . $row['sys_cputype'] . "<br>" . $row['sys_memory'] . " MB Memory<br>" . $row['sys_totaldisk'] . " GB Disk (" . $row['sys_disk'] . "GB )<br>" . $row['sys_cddvd'] . "<br>" . $row['sys_network'] . "<br>" . $row['sy s_otherio'] . "<br>" . $row['sys_tape'] . "<br>"; $systemref = $row['reference'] . "<br> <small>" . $row['model'] . "</small><br>"; } if ( $system == "AS400"){ $systemtip = $row['reference'] . "<br>" . $row['model'] . "<br>" . $row['sys_numcpu'] . " x " . $row['sys_cputype'] . "<br>" . $row['sys_memory'] . " MB Memory<br>" . $row['sys_totaldisk'] . " GB Disk (" . $row['sys_disk'] . "GB )<br>" . $row['sys_cddvd'] . "<br>" . $row['sys_network'] . "<br>" . $row['sy s_otherio'] . "<br>" . $row['sys_tape'] . "<br>"; $systemref = $row['reference'] . "<br> <small>" . $row['model'] . "</small><br>"; } if ( $system == "DISK"){ $systemtip = $row['reference'] . "<br>" . $row['model'] . "<br>"; $systemtip = $row['reference'] . "<br>" . $row['model'] . "<br>" . $row['sys_totaldisk'] . " GB Disk (" . $row['sys_disk'] . "GB )<br>" . $row['sys_o therio'] . "<br>"; $systemref = $row['reference'] . "<br> <small>" . $row['model'] . "</small><br>"; } if ( $system == "TAPE"){ $systemtip = $row['reference'] . "<br>" . $row['model'] . "<br>"; $systemref = $row['reference'] . "<br> <small>" . $row['sys_tape'] . " - " . $row['sys_otherio'] . "</small><br>"; } if ( $system == "MTS"){ $systemtip = $row['reference'] . "<br>" . $row['model'] . "<br>"; $systemref = $row['reference'] . "<br> <small>" . $row['model'] . "</small><br>"; } if ( $system == "CON"){ $systemtip = $row['reference'] . "<br>" . $row['model'] . "<br>"; $systemref = $row['reference'] . "<br> <small>" . $row['model'] . "</small><br>"; } echo "<div class='reference'><input type='checkbox' name='" . $row['reference'] . "' id='" . $row['reference'] . "' /><a onmouseover=\"Tip('" . $systemt ip . "',TITLE,'SYSTEM INFORMATION',TITLEALIGN,'center',SHADOW,'true')\" onmouseout=\"UnTip()\">" . $systemref . "</a></div>"; } mysql_close($con); ?> Quote Link to comment https://forums.phpfreaks.com/topic/157351-extracting-info-from-a-database-and-adding-checkboxes-to-an-existing-form/#findComment-829462 Share on other sites More sharing options...
Ken2k7 Posted May 8, 2009 Share Posted May 8, 2009 Where is this reference array? Quote Link to comment https://forums.phpfreaks.com/topic/157351-extracting-info-from-a-database-and-adding-checkboxes-to-an-existing-form/#findComment-829497 Share on other sites More sharing options...
teccyspice Posted May 8, 2009 Author Share Posted May 8, 2009 Oh dear, it looks like I made sooo many changed I trashed that bit... It's in the getsystems.php right at the bottom and it now looks like this; echo "<div class='reference'><input type='checkbox' name='reference[]' id='reference[]' /><a onmouseover=\"Tip('" . $systemtip . "',TITLE,'SYSTEM INFORMATION',TITLEALIGN,'center',SHADOW,'true')\" onmouseout=\"UnTip()\">" . $systemref . "</a></div>"; [code] Quote Link to comment https://forums.phpfreaks.com/topic/157351-extracting-info-from-a-database-and-adding-checkboxes-to-an-existing-form/#findComment-829744 Share on other sites More sharing options...
teccyspice Posted May 8, 2009 Author Share Posted May 8, 2009 I can post the full multibook.php code if it helps, I'll even close the tag properly as well (sorry again, it's been a while since I posted to a forum). I didnt want to post too much code or it may just get in the way. Quote Link to comment https://forums.phpfreaks.com/topic/157351-extracting-info-from-a-database-and-adding-checkboxes-to-an-existing-form/#findComment-829767 Share on other sites More sharing options...
Ken2k7 Posted May 8, 2009 Share Posted May 8, 2009 Okay so in your JavaScript function: function showSUN(system,frm_startdate,frm_enddate) { xmlHttp=GetXmlHttpObject() if (xmlHttp==null) { alert ("Browser does not support HTTP Request") return } // Execute getsystems.php and pass the system selected with the start and end dates from the form. var url="getsystems.php?system="+system+"&frm_startdate="+frm_startdate+"&frm_enddate="+frm_enddate // If the state is changed, changeSUN and pass the output from url. xmlHttp.onreadystatechange=changeSUN xmlHttp.open("GET",url,true) xmlHttp.send(null) } It doesn't pass the reference parameter to the AJAX url. I don't know where you called that function, but perhaps you should add reference to the AJAX URL. Quote Link to comment https://forums.phpfreaks.com/topic/157351-extracting-info-from-a-database-and-adding-checkboxes-to-an-existing-form/#findComment-829829 Share on other sites More sharing options...
teccyspice Posted May 8, 2009 Author Share Posted May 8, 2009 It doesn't pass the reference parameter to the AJAX url. I don't know where you called that function, but perhaps you should add reference to the AJAX URL. The code from the multibooking.php script is here. <fieldset> <legend>Additional Systems</legend> <div class="systems"><input type="checkbox" name="SUN" id="SUN" value="SUN" onclick="showSUN(this.value,this.form.frm_startdate.value,this.form.frm_enddate.value); " /><label for="multi_systems">SUN</label> </div> <div class="systems"><input type="checkbox" name="RS" id="RS" value="RS" onclick="showRS(this.value,this.form.frm_startdate.value,this.form.frm_enddate.value); " /><label for="RS">RS6000</label></div> <div class="systems"><input type="checkbox" name="HP" id="HP" value="HP" onclick="showHP(this.value,this.form.frm_startdate.value,this.form.frm_enddate.value)" /><label for="HP">HP9000</label></div> <div class="systems"><input type="checkbox" name="INTEL" id="INTEL" value="INTEL" onclick="showINTEL(this.value,this.form.frm_startdate.value,this.form.frm_enddate.value)" /><label for="INTEL">INTEL</label></div> <div class="systems"><input type="checkbox" name="AS400" id="AS400" value="AS400" onclick="showAS400(this.value,this.form.frm_startdate.value,this.form.frm_enddate.value)" /><label for="AS400">AS400</label></div> <br /> <div class="systems"><input type="checkbox" name="DISK" id="DISK" value="DISK" onclick="showDISK(this.value,this.form.frm_startdate.value,this.form.frm_enddate.value)" /><label for="DISK">DISK</label></div> <div class="systems"><input type="checkbox" name="TAPE" id="TAPE" value="TAPE" onclick="showTAPE(this.value,this.form.frm_startdate.value,this.form.frm_enddate.value)" /><label for="TAPE">TAPE</label></div> <div class="systems"><input type="checkbox" name="MTS" id="MTS" value="MTS" onclick="showMTS(this.value,this.form.frm_startdate.value,this.form.frm_enddate.value)" /><label for="CYCLADES">CYCLADES</label></div> <div class="systems"><input type="checkbox" name="CON" id="CON" value="CON" onclick="showCON(this.value,this.form.frm_startdate.value,this.form.frm_enddate.value)" /><label for="CON">CONSOLE</label></div> <div class="systems"><input type="checkbox" name="MOBILE" id="MOBILE" value="MOBILE" onclick="showMOB(this.value,this.form.frm_startdate.value,this.form.frm_enddate.value)" /><label for="MOBILE">MOBILES</label></div> </fieldset> <br /> <fieldset class="results"> <legend>SUN</legend> <div id="txtSUN"> <div align="center">Item has not been selected.</div> </div> </fieldset> When the user clicks on the SUN checkbox, it is sent to getsystems.php with the start and end dates, this does the search within the date range and posts the results back to the txtSUN div... bear in mind that I only did AJAX and Javascript for this I whilst I did manage to get it working (of sorts) I'm not by any stretch of the imagination, an expert... When you say I need to add reference to the ajax url, I dont really know what you mean... Quote Link to comment https://forums.phpfreaks.com/topic/157351-extracting-info-from-a-database-and-adding-checkboxes-to-an-existing-form/#findComment-829856 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.