faqts : Computers : Programming : Languages : PHP

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

24 of 40 people (60%) answered Yes
Recently 7 of 10 people (70%) answered Yes

Entry

How can I populate a pull down with with a few data fields from one table and then upon selection then intire row fills out the apropiate form fields?

Feb 18th, 2008 19:31
dman, Philip Olson, Kelson Vibber, Greg West, http://www.ttnr.org


You'll need to combine PHP with JavaScript for this one. 
In the <head> area of the HTML page, write some JavaScript to define
several arrays (or a single, multidimensional array) containing the data
you want to use for the form.  You'll need to use PHP to generate the
JavaScript code that defines the arrays.
In the same block of JavaScript, write a function that takes the
selected value from the pull-down menu and chooses which array or array
slice to use and fill in the form.
In the form, define the pull-down menu using a <select> tag, and assign
the function you created above to the onChange attribute.  Then use PHP
to generate the <option> tags for the menu items.
A couple tutorials exist on this subject, they are as such :
    chainedSelectors: A Better Way to Drop-down a PHP List   :
    ----------------------------------------------------------
    http://www.zend.com/zend/tut/drop-down.php
    Loading JavaScript Arrays with MySQL Data                :
    ----------------------------------------------------------
    http://devshed.com/Server_Side/MySQL/JS_Arrays/