Web Development



AutoPopulate form elements from an OnChange option using Ajax/mySQL/JavaScr

By pcinfoman ·
I have database with 18 tables in it. There is over 550 records in this table. The PRIMARY table in the db is "stock_no". There are never any duplicate values in it (hence the "PRIMARY").

I have a web form at http://www.animalmakers.com/Testing/db_updateexisting.php that 18 fields on it (one for each db table). The "id" and "name" values of each field are exactly the same as the name of the table in the db. 4 of these fields are pull-down menus that are populated from the database.

What I need to do is have it so when the "stock_no" field on the form changes, it queries the db and fills out the form with the results from the db.

How can this be done? Does somebody has some ready javascript/ajax/php coding that I can modify for my purposes?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

This does not do the job

by pcinfoman In reply to PHP Maker

I just downloaded the demo of this program and it does NOT do the job that you suggest that it does.

Any other ideas?

Collapse -

populating form fields from database

by sunnypal In reply to AutoPopulate form element ...

I am trying very similar in php and sql server.
Were you able to find or develop a solution to autopoplate formfields from the database based
on a selection/input of a field?

Appreciate any help.

thank you,

Related Discussions

Related Forums