StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I had to do this recently myself. Here's what I did, feel free to use what makes sense to you. I tried what seemed like a simple way to myself. </p> <pre><code><select name="department_list" id="department_list" onchange="$('#singleUser').load('yourextraphppage.php?nid='+this.value);"> <option value='none'>Select a department</option> </code></pre> <p>Then load your first select list with data and close the select tag... Add a blank div where you want the 2nd select. I used the value from the first select list for my parameter for the 2nd select list's query. (it was the foreign key in the 2nd table for the 2nd select list)</p> <pre><code><div id="singleUser" class="singleUser"> </div> </code></pre> <p>Last, you need the additional PHP page that you called from the first select list. Here's a barebones version of my code.</p> <pre><code>echo "<option value='none'>Select user</option>"; try { $db = new PDO("mysql:host=$hostname;dbname=$dbname", $username, $password); $stmt = $db->prepare("SELECT dm.empid AS empid, u.name AS name FROM mytable dm JOIN mytable2 u ON dm.empid = u.id WHERE dm.deptid = :id ORDER BY u.name"); $stmt->bindParam(':id', $id); $stmt->execute(); while ($r = $stmt->fetch()) { $empid = $r['empid']; $userName = $r['name']; echo "<option value='".$empid."'>".$userName."</option>"; } echo "</select>"; echo "</p>"; $db = null; } catch (PDOException $ex) { echo "An Error occurred!"; } </code></pre> <p>I hope this helps. I'm rather busy so I can't go in detail explaining it at the moment. I'll check back later to see if you have any questions.</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