Computer Science Canada Auto populate textbox after selecting an item from my listmenu or combobox |
Author: | waltg72 [ Mon Aug 30, 2010 5:50 am ] |
Post subject: | Auto populate textbox after selecting an item from my listmenu or combobox |
I am just starting to learn php and mysql as database. Is there a way to use my data stored from my mysql table as my option list to my list menu in php? Then once I select one of those data displayed from my listmenu, i want to display the item also in a textbox. Is this possible? How? can someone give me a php sample for this? I am spending weeks trying to figure out how to do this stuff. Thanks in advance. |
Author: | DanShadow [ Wed Sep 22, 2010 2:07 pm ] |
Post subject: | Re: Auto populate textbox after selecting an item from my listmenu or combobox |
It's pretty easy actually ![]() I'm running a bit late today, so ill just give you pseudo-code. Danshadow wrote: $array = LOAD_DB_ROW_DATA; echo "<form action='PAGE.PHP' method='post'>"; echo "<select name='FORM SUBMISSION POST NAME'>"; for ($i = 0; $i < count($array); $i++) { echo "<option value='" . $array[$i] . "'>"; echo $array[$i]; echo "</option>"; } echo "</select>"; echo "<input type='Submit' value='Submit Selection!'>"; echo "</form>"; echo "<br><br>"; if (!empty($_POST["FORM SUBMISSION POST NAME"])) { echo "<input type='text' value='" . $_POST["FORM SUBMISSION POST NAME"] . "'>"; } You load the DB row values into an array, populate a dropdown menu with the items (doesnt have to be a dropdown menu), and add a submission form. The bottom checks if a post value has been submitted, and if it has it will set the value of the text box with the selected "option" in the previous form. Hope that helps. |