0

I want to make data entry form which inserts data to MySQL.

Select (Dropdown) from List A --- Values of dropdown to be populate from database A
Select (Dropdown) from List B ---- Values of dropdown to be populated from database B
....
....
and so on
Select (Dropdown) from List N ---- Values of dropdown to be populated from database n

Submit

Data entered to List C

2
Contributors
1
Reply
14
Views
4 Years
Discussion Span
Last Post by Vedoo
0

If you have attempted something on your own, post them here. If you want to get some idea, i will provide you some basic idea to start with. If you want to obtain data from your database, you must connect to the database in PHP. Search on these commands to understand how the database is connected.

mysql_connect();
mysql_select_db();
mysql_query();
mysql_close();

Next is to create your form where the dropdown list would show the data from the database. To do this, make sure the connection is done right. Data can be fetched in a numeric manner or in an associative array. Search how to do this in database. As you are selecting a value from the dropdown list, you can assign the value to a new variable that can be passed to List C after you have pressed submit button.

This is a basic idea i can provide with. Good Luck :)

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.