I am designing a web form that will:
- have an input field for the user that upon entering a record id will then search a table in the MYSQL database and pull out data from several fields to populate the form.
- Accept user input into a text field.
- Upon clicking the submit button, the form will update the data base ( the text field on the form has a related field in the table), and then it will email the form to an email address.
I have the basic code ready to go for the e-mail part of the form, however I don’t know what to look for when it comes to a tutorial for the other part of it. What would that be called?
I figured that one of you guys has run across this in the past, this combination of data retrieval and input / database update, and you would be able to point me in the direction of either a tutorial or just what term to look up to learn how to do it. I have a SAMS php/MYSQL/Apache book, as well as Larry Ullmans “PHP for the WWW” book.
PS. I have accomplished most of this with MSACCESS, except the e-mail part, so that is why I want to try and get it done on the web with PHP.
Thanks a lot for any help you can give.