I want to create a form based on fields that auto-fills themselves. Here is what I want to do:
1. First field: a dropdown that extracts from a mysql database the names of 600+ students.
2. Second field, third field, forth field: a text field (or something else) that auto-fills itself when a student's name is selected with his school class, his email address and his phone number.
I have a mysql database (utf8/general_ci) that has 4 columns: Fullname, Class, Email, Phone. So, when i select a student's Name from the dropdown (or some other solution like searches for the entire name), I need the next 3 text fields (it can be dropdowns as well) to auto-fill with the associated data.
Example:
- John Doe (first column in database - selected student)
-> Second field: 12th grade
-> Third field: his email address
-> 4th field: his phone number
Thank you in advance for your time and help!
1. First field: a dropdown that extracts from a mysql database the names of 600+ students.
2. Second field, third field, forth field: a text field (or something else) that auto-fills itself when a student's name is selected with his school class, his email address and his phone number.
I have a mysql database (utf8/general_ci) that has 4 columns: Fullname, Class, Email, Phone. So, when i select a student's Name from the dropdown (or some other solution like searches for the entire name), I need the next 3 text fields (it can be dropdowns as well) to auto-fill with the associated data.
Example:
- John Doe (first column in database - selected student)
-> Second field: 12th grade
-> Third field: his email address
-> 4th field: his phone number
Thank you in advance for your time and help!