how to save data in database and sent email

To send email, you can use the basic mail() php function.

First, define the headers:

$headers = "From: [email protected]\r\n";
$headers .= "Reply-To: [email protected]\r\n";
$headers .= "Return-Path: [email protected]\r\n";
$headers .= "CC: [email protected]\r\n";
$headers .= "BCC: [email protected]\r\n";
$headers .= "X-Mailer: PHP/" . phpversion();

After that, put the subject line in a variable for easier use:

$subject = "My example email subject";

Next you do the same for the email's body:

$body = "This is the body of the email.\n\n";
$body .= "The name is: ".$name."\n";
$body .= "The mobile is: ".$mobile."\n";
$body .= "The email is: ".$email."\n";
$body .= "The message is: ".$message."\n";
$body .= "This is the end of the message";
Finally, you specify the recipient:
```
$to = "[email protected]";
```
Wrap it up to mail function like that:
```
mail($to, $subject, $body, $headers);
```
And you are done with the mail!

More about mail function you can find here.

As for updating the mysql, you can do this:

First make sure how you are going to identify the table. This can be done for example by the row id:
```
$id = "3"; //3 is hypothetical
```
Then run the query:
```
mysql_query=("UPDATE other_tbl_name SET fco_name = '$name', fco_mobile = '$mobile', fco_email = '$email', fco_text = '$message' WHERE id = '$id'"); //here we used the row's id to specify which row to update
```
Hope this was what you were looking for...

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gokhul Varman9y ago
Please refer the link for more detailed explanation:https://stackoverflow.com/questions/27426744/send-email-and-insert-data-to-database-php-mysql
Manikandan Murugesan9y ago
To send email, you can use the basic mail() php function.

First, define the headers:
$headers = "From: [email protected]\r\n";
$headers .= "Reply-To: [email protected]\r\n";
$headers .= "Return-Path: [email protected]\r\n";
$headers .= "CC: [email protected]\r\n";
$headers .= "BCC: [email protected]\r\n";
$headers .= "X-Mailer: PHP/" . phpversion();
After that, put the subject line in a variable for easier use:
$subject = "My example email subject";
Next you do the same for the email's body:
$body = "This is the body of the email.\n\n";
$body .= "The name is: ".$name."\n";
$body .= "The mobile is: ".$mobile."\n";
$body .= "The email is: ".$email."\n";
$body .= "The message is: ".$message."\n";
$body .= "This is the end of the message";
Finally, you specify the recipient:

$to = "[email protected]";

Wrap it up to mail function like that:

mail($to, $subject, $body, $headers);

And you are done with the mail!

More about mail function you can find here.

As for updating the mysql, you can do this:

First make sure how you are going to identify the table. This can be done for example by the row id:

$id = "3"; //3 is hypothetical

Then run the query:

mysql_query=("UPDATE other_tbl_name SET fco_name = '$name', fco_mobile = '$mobile', fco_email = '$email', fco_text = '$message' WHERE id = '$id'"); //here we used the row's id to specify which row to update

Hope this was what you were looking for...
ma ouml9y ago
can you give me an example please
Kumar Ravishankar9y ago
First Create Function To Store Your Query Details in DataBase and store the value in Session as well,if your data is saved in, then write function to Send Mail, and pass the details with your mail credientials.