Automatic form field filling from DB
Posted: Mon Jan 29, 2007 7:35 am
Hello,
I've got a tricky one:
I'm making a GUI for a database containing error logs from a certain machine. These logs are written down manually from that machine and then entered into the database using my GUI.
I would like to do two things:
- Give the user the possibility to enter up to 10 log entries at a time
- Once the user enters the error code in one of the fields, and leaves that field, that code should be checked against another table in the DB, and if a description for that error already exists, it should auomatically be filled out in another field. If it doens't already exists, the user can input the description, and when submitting the form, not only update the error log table, but also the table containing the error codes and their descriptions.
I know I'm going far here, but there HAS to be a way. Parts can be done in PHP, parts in JavaScript, but both can't be combined because of the client-server difference, except maybe when using AJAX, of which I have no experience at all.
Anyone ? Anyone ?
I've got a tricky one:
I'm making a GUI for a database containing error logs from a certain machine. These logs are written down manually from that machine and then entered into the database using my GUI.
I would like to do two things:
- Give the user the possibility to enter up to 10 log entries at a time
- Once the user enters the error code in one of the fields, and leaves that field, that code should be checked against another table in the DB, and if a description for that error already exists, it should auomatically be filled out in another field. If it doens't already exists, the user can input the description, and when submitting the form, not only update the error log table, but also the table containing the error codes and their descriptions.
I know I'm going far here, but there HAS to be a way. Parts can be done in PHP, parts in JavaScript, but both can't be combined because of the client-server difference, except maybe when using AJAX, of which I have no experience at all.
Anyone ? Anyone ?