Application Form to Database and FormMail
Access Data Base, upload an Application form and send email with the contents of the same form.
I would like to learn how to take the information from an application form on the web and have it be entered into a database and also send the same information via FormMail.
It would be useful in both asp and php
Comments
Email form and enter into database
I believe Macromedia do/did have a tutorial in their Technotes on this...I have seen and used it somewhere on www.
Simply put, you place your email script inside your Dreamweaver Insert/Update script and it send on executing the Insert/Update.
Locate this code in page:
If (Not MM_abortEdit) Then
' execute the insert
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close
<<-place your email script here
If (MM_editRedirectUrl <> "") Then
Response.Redirect(MM_editRedirectUrl)
End If
End If
Smart Mailer for PHP or ASP
Check out the Smart Mailer extension. There is a version for ASP and PHP.
ASP version: http://www.dmxzone.com/go?5578
PHP version: http://www.dmxzone.com/go?5628
Martha Graham
DMXzone.com
RE: Email form and enter into database
I have a form called "form1" and I collect the information from the form and send it to my Domain's E-Mail adress with a cgi script called "form1.cgi". I want to utilize my WebServer's autoresponder capability, however I do not know how to make form1.cgi extract the end user's E-Mail address into a "sent from" or "reply to" field so as my Domain's E-Mail address can know where to send the autoresponse. I am wondering if someone might assist me with this task?
RE: RE: Email form and enter into database
If you want the email being sent to your to be from the person's email who completed the form, normally there is a option to set the Email field, so the email will be from this email address.
If not, why not just add a second email script which is sent to the Email of the person who completed it, thus the To: field would be the Email field details from your form.
You must me logged in to write a comment.