how to save data in database and sent email

Question

Hi friends I have in my website a contact form and I want to add to the user in an email and data saved in my database how to do please and thanks in advance

Gokhul Varman · Answer

Please refer the link for more detailed explanation:https://stackoverflow.com/questions/27426744/send-email-and-insert-data-to-database-php-mysql

Manikandan Murugesan · Answer

To send email, you can use the basic mail() php function. First, define the headers: $headers = "From: myplace@yourdomain.com
" ; $headers .= "Reply-To: myplace2@yourdomain.com
" ; $headers .= "Return-Path: myplace@yourdomain.com
" ; $headers .= "CC: sombodyelse@anotherdomain.com
" ; $headers .= "BCC: hidden@anotherdomain.com
" ; $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.

" ; $body .= "The name is: " . $name . "
" ; $body .= "The mobile is: " . $mobile . "
" ; $body .= "The email is: " . $email . "
" ; $body .= "The message is: " . $message . "
" ; $body .= "This is the end of the message" ; Finally, you specify the recipient: $to = "recipient@yourdomain.com" ; 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 ouml · Answer

can you give me an example please

Kumar Ravishankar · Answer

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.

how to save data in database and sent email

Answers (4)