Multiple actions on submit

SheepWoolie

Hi,

i've got a form wich allows you to put your email and name in a mysql database. This works fine. But now i would like the form to perform two actions. First of all, putting the info into the database (which it already does) and at the same time send the person an email. Anybody know how to do this?

thanks

rIkLuNd

$to = "the.email@domain.com";
$subject = "Welcome";
$message = "Thank You!";

$headers = "Content-Type: text/plain\r\n";
$headers .= "From: your-email@domain.com\r\n";
$headers .= "Reply-To: your-email@domain.com\r\n";

// send it
mail($to,$subject,$message,$headers) or die("Sending Failed");

SheepWoolie

ok this is the existing code:

<?php require_once('Connections/karltest.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    

    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}

$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
  $editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}

if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO testdb (voornaam, achternaam, email, partysize, huidigjaar) VALUES (%s, %s, %s, %s, %s)",
                       GetSQLValueString($HTTP_POST_VARS['voornaam'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['achternaam'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['email'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['partysize'], "int"),
					   GetSQLValueString($HTTP_POST_VARS['huidigjaar'], "int"));

  mysql_select_db($database_karltest, $karltest);
  $Result1 = mysql_query($insertSQL, $karltest) or die(mysql_error());
}

mysql_select_db($database_karltest, $karltest);
$query_Recordset1 = "SELECT * FROM testdb";
$Recordset1 = mysql_query($query_Recordset1, $karltest) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<?php
$query = "select sum(partysize) from testdb where huidigjaar = 2002";
$result = mysql_query($query, $karltest);
$row = mysql_fetch_row($result);

echo number_format($row[0]) . " people are signed up for this conference in 2002.";
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<form method="post" name="form1" action="<?php echo $editFormAction; ?>">
  <table align="center">
    <tr valign="baseline"> 
      <td nowrap align="right">Voornaam:</td>
      <td><input type="text" name="voornaam" value="" size="32"></td>
    </tr>
    <tr valign="baseline"> 
      <td nowrap align="right">Achternaam:</td>
      <td><input type="text" name="achternaam" value="" size="32"></td>
    </tr>
    <tr valign="baseline"> 
      <td nowrap align="right">Email:</td>
      <td><input type="text" name="email" value="" size="32"></td>
    </tr>
    <tr valign="baseline"> 
      <td nowrap align="right">Partysize:</td>
      <td><input type="text" name="partysize" value="2" size="32"></td>
    </tr>
	<tr valign="baseline"> 
      <td nowrap align="right">Invoerjaar:</td>
      <td><input type="text" name="huidigjaar" value="2002" size="32"></td>
    </tr>
    <tr valign="baseline"> 
      <td nowrap align="right">&nbsp;</td>
      <td><input type="submit" value="Insert Record"></td>
    </tr>
  </table>
  <input type="hidden" name="MM_insert" value="form1">
</form>
<p>&nbsp;</p>

</body>
</html>
<?php
mysql_free_result($Recordset1);
?>

Could you tell me where i insert this code of yours? 😕

rIkLuNd

Insert it after $totalRows_Recordset1 = mysql_num_rows($Recordset1);

SheepWoolie

ok😃 , im getting somewhere. i can get it to send email to me so its working. but i'd like it to send the email to the person who just filled in the form.

$to = "karl@bureaugras.nl";
$subject = "Welcome";
$message = "Thank You!";

$headers = "Content-Type: text/plain\r\n";
$headers .= "From: [email]karl@bureaugras.nl[/email]\r\n";
$headers .= "Reply-To: [email]karl@bureaugras.nl[/email]\r\n";

// send it
mail($to,$subject,$message,$headers) or die("Sending Failed");

what change do i have to make to $to, to make this happen

thanks🙂

rIkLuNd

well, this depends on what the email field is named, but I made it email:

$to = $_POST['email'];

SheepWoolie

😃 😃 heheh thanks! thats great. works a charm. is it also possible to send html emails with this?

rIkLuNd

yes, just change text/plain into text/html

SheepWoolie

😃 ok great, thanks for the quick replies btw. 😃 . you've been a real help 🙂

Hamsterpants

I would like to know how I can send two emails with the form submit. I would like to send one to the site owner informing them that a new user has signed up and another email to the new member.

Thanks in advance
Dill

leatherback

Hi Hamsterpants,

Submit the form to a PhP page, then in the page use the mail() command to send an email. Define both emails in the same PhP page:

mail($SubmitterEmail, $subject, $content);
mail($YourEmail, $subject, $content);

Cheers,

Hamsterpants

Thanks ...that now works...
Another question:

How do I add html e.g like hyperlink in the "message" that is sent?

Thanks
Dill

leatherback

Hi Hamsterpants,

please start a new thread if you have new questions...

As for your html email.. Check the manual on multi-part email. It is a bit more complicated then "just mail()"

But I got it to work using the PhP manual&do a search in the forums: There are a lot of messages about this.. Give it a try, and ask again if you get stuck.

Enjoy!