Form processing ideas

stribor40

Hi
I have simple html form that i would like to process in following manner
When user is filling form there will be only one button (submit)
Once user clicks submit i will receive an email and in the emai there will be link which i can click that will lead me back to the page with the form with all fields filled (what user filled).
Now at this point i will see only 2 buttons (accept and reject).
At this point i can change something or add something to what user already filled and i can chose to reject or accept form to be submitted to the database.
Either way user who filled the form will receive an email.

Can anyone suggest how to solve this problem. Any ideas would be appreciated.

bradgrafelman

Use a database (e.g. MySQL) to save the submitted form data, and use [man]mail/man, PEAR::Mail, PHPMailer, XPertMailer, etc. to send the e-mail.

stribor40

I know but how do i approve the form or reject it from email link?

bradgrafelman

You'd want some sort of PRIMARY KEY (an AUTO_INCREMENT column works nicely for this) in your DB; you'd use that value in the link in the e-mail. The link would point to a script that retrieves the stored information and outputs the HTML markup for the form with the fields pre-populated with the stored values.

stribor40

Great. How do i pass that value in the email link?

bradgrafelman

If it was an AUTO_INCREMENT column, you'd retrieve the value after you INSERT the data. Either way, once you have the value, it's just a matter of string concatenation to add it to the hyperlink.

stribor40

Can you give me url example of the script with paramethar

If i create myscript?1.php ( 1 is the key for the record) and write the code for it
What happens when user clicks on www.myscript?2.php. It will say url does not exist?
Can you try to explian a bit how do i do this please

bradgrafelman

The easiest way would be to pass the ID in the query string, meaning you would output URLs such as:

http://yoursite.com/script.php?id=1

stribor40

Ok so i have one file which is form.html
This form will submit to script.php
script.php will send data to db
script.php will now retrieve id of this record
script.php will now email "someone" and inside that email send what link?
script.php?id = 1 or someother.php?=1

stribor40

Hi i got this working but now i need to solve following problem. I have id set as auto increment.
Now how would i check if form data is not already in my database. I cant check based on id because every id will be different in every insertion

laserlight

If you have the notion of "data is not already in my database", then presumably some column (or set of columns) in your database table(s) should be declared unique. One approach would be to either query the database to check that the database does not already contain the data to be inserted for those columns. Another, probably better, approach is to just insert, then handle the unique constraint violation if it happens.