How do you post form info to both mysql and email recipient

Posts: 2 · Posted: Thu Oct 11, 2007 1:43 pm

I need to be able to send form submission to email recipient and back up that same info in a mysql database. I know how to do each one separately.

Posts: 570 · Posted: Thu Oct 11, 2007 2:30 pm

It can be done easily. What language you are using?

Posts: 2 · Posted: Thu Oct 11, 2007 2:37 pm

Posts: 192 · Posted: Sun Dec 16, 2007 10:52 pm

You would store the data in a variable, then use the variable to send the data to the database server, then use the variable to send an email.

http://us3.php.net/mysql
http://us3.php.net/manual/en/tutorial.forms.php
http://www.php.net/links.php

Here's a mock up:

Code:

<?php
$data = $_POST['data'];
$db = mysql_connect($host, $user, $password)
mysql_query("INSERT INTO table (data) VALUES ($data)", $db)or DIE("Could not insert $data");

$mailData = "$data inserted into database";

mail('me@example.com', 'Query Results!', $mailData) or DIE ("Could not send email!");
?>