StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>You need to change your PHP code to acheive this scenario. If you want the rooms to be dynamical populated when changing the building name you can user jquery. Include jQUery library in your script.You need to do an ajax call to dynamically populate the list.</p> <p>I have added only from building part. Rest all above is same. In the foreach loop remove the building from the array.Change your current php code to this.</p> <p>PHP CODE:</p> <pre><code> $sql = "SELECT DISTINCT Building FROM Room"; $sqlresult = mysql_query($sql); $buildings = array(); // easier if you don't use generic names for data $buildingHTML = ""; $buildingHTML = "<form action=\"\" method=\"post\">"; $buildingHTML .= '<select name="buildings" id="buildingssDrop" onchange="getRooms();">'.PHP_EOL; $buildingHTML .= '<option value="">Please Select</option>'.PHP_EOL; while($sqlrow = mysql_fetch_array($sqlresult)) { $building = $sqlrow['Building']; $buildingHTML .= "<option value='".$building."'>" . $building . "</option>".PHP_EOL; } $buildingHTML .= '</select>'; $buildingHTML .= '</form>'; $roomHTML = ""; $roomHTML .= '<select name="rooms" id="roomsDrop">'.PHP_EOL; $roomHTML .= '<option value="">Please Select</option>'.PHP_EOL; $roomHTML .= '</select>'; echo $buildingHTML; echo $roomHTML; </code></pre> <p>You need to add a script for dynamic population.</p> <p>JS CODE:</p> <pre><code>function getRooms() { var building = jQuery("#buildingssDrop").val(); jQuery('#roomsDrop').empty(); jQuery('#roomsDrop').html('<option value="">Please Select</option>'); jQuery.ajax({ type: "post", url: "rooms.php", data: "building="+building, success: function(response){ jQuery('#roomsDrop').append(response); } }); } </code></pre> <p>Here the rooms.php is the ajax file you need to call for dynamic population of data:</p> <p>rooms.php</p> <pre><code>$building = isset($_POST['building']) ? $_POST['building'] : ''; $sql = "SELECT Room FROM Room WHERE Building ='".$building."'"; $sqlresult = mysql_query($sql); $roomHTML = ""; while($sqlrow = mysql_fetch_array($sqlresult)) { $room = $sqlrow['Room']; $roomHTML .= "<option value='".$room."'>" . $room . "</option>".PHP_EOL; } echo $roomHTML; </code></pre> <p>Hope this helps for you</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload