I want to add a page to my WordPress site that contains a form. On displaying the page, the form needs to be populated from a new table that I will add to the MySQL database. The user can then change the data on the form, and click a Submit button. I then need another WordPress page to process the values returned from the form, insert them in the database, and send the user a confirmatory e-mail message.
What's the easiest way of doing this?
My questions are:
1. Can I just include the PHP to generate the form and populate it from the database in my WordPress page, maybe using the Exec-PHP plugin?
2. What do I put in the Action attribute of the form element? Do I just put the permalink to the form processing page in here?
3. In my form processing page, how do I access the returned values from the form? Can I just access $_POST like I would in PHP?
4. Can I send e-mail from my form processing page? What's the best way of doing this?
Thanks - Rowan