[RESOLVED] Insert record and send results by email

[pb1uk]

Hello all,

I have a registration page on my website for users to sign up to use the site. It was setup using the insert record form wizard in Dreamweaver cs4 and works fine. What i would like to do is that when the user hits the button to insert the record into the database, they also receive an email with their registration details. I have searched around and have been unable to find a a method of how to achieve this. The only methods i found us ASP and my site is in PHP. Any help or advice would be grealty appreciated,

Thanks,

Peter

[Pikachu2000]

If your host allows the use of php's mail() function, use the submitted $_POST array (after sanitization, of course) for the insert, then to generate an email if the insert succeeds, or an error message and log entry if it fails.

[pb1uk]

Pikachu2000;10946167 wrote:

If your host allows the use of php's mail() function, use the submitted $_POST array (after sanitization, of course) for the insert, then to generate an email if the insert succeeds, or an error message and log entry if it fails.

Do you know of any example code or tutorials i could look at?

[Pikachu2000]

The PHP manual page is worth a read: [man]mail()[/man], and there are tons of results if you google it. Basically, it'll end up looking like this.

$to = "[e-mail]";
$subject = "I just sent you an email";
$message = "This is the body of my email. I'll put in a line feed, too!\r\n";
$headers = "From: [e-mail]";

if( mail($to, $subject, $message, $headers) ) {
     echo( "Mail sent successfully." );
} else {
     echo( "Mail didn't send. Try again later."
     trigger_error( "Mail failed to send");  // if mail fails, log it instead of killing the script.
}

[pb1uk]

Pikachu2000;10946336 wrote:

The PHP manual page is worth a read: [man]mail()[/man], and there are tons of results if you google it. Basically, it'll end up looking like this.

$to = "[e-mail]";
$subject = "I just sent you an email";
$message = "This is the body of my email. I'll put in a line feed, too!\r\n";
$headers = "From: [e-mail]";

if( mail($to, $subject, $message, $headers) ) {
     echo( "Mail sent successfully." );
} else {
     echo( "Mail didn't send. Try again later."
     trigger_error( "Mail failed to send");  // if mail fails, log it instead of killing the script.
}

Thanks. I'm away of mail() i have a contact form on my site that follow similar to the code above. My problem is where to put this code in the insert record page?

On my contact form the action is mailto but the form for inserting the record already has an action called editformaction.

[Pikachu2000]

Oh, if that's the case you can use it in an if/else conditional with the insert. Check if the insert succeeded, then send the mail, else display and/or log an error.

[pb1uk]

Pikachu2000;10946438 wrote:

Oh, if that's the case you can use it in an if/else conditional with the insert. Check if the insert succeeded, then send the mail, else display and/or log an error.

Thanks. I got it solved. After the insert i used the following:

if($result)
{
mail code here
}
else
{
log error, no mail sent
}