Page 1 of 1

Post to database and email me at the same time!!!

Posted: Wed Jun 10, 2009 12:43 pm
by shiftty
Hello all,

I am a little new to the programming game, but I have an idea of what going on.

I have a form that is working great but it only submits to the database. How will I get it to submit an email at the same time.

This is my current code if this helps out.

Code: Select all

 
<form action="/in.php?" method="post" id="form2">
  <div align="center"></div>
  <table align="center">
    <tr valign="baseline">
      <td align="right">Name:</td>
      <td><input type="text" name="name" value="" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td align="right">I_am:</td>
      <td><select name="i_am" id="i_am">
        <option>Select...</option>
        <option value="Male">Male</option>
        <option value="Female">Female</option>
        </select>        </td>
    </tr>
    <tr valign="baseline">
      <td align="right">They_are:</td>
      <td><select name="they_are" id="they_are">
        <option>Select...</option>
        <option value="Male">Male</option>
        <option value="Female">Female</option>
        </select>
        </td>
    </tr>
    <tr valign="baseline">
      <td align="right">Email:</td>
      <td><input type="text" name="email" value="" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td align="right">City:</td>
      <td><input type="text" name="city" value="" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td align="right">State:</td>
      <td><select name="state" size="1">
<option value="" selected="selected">Select...</option>
<option value="Alabama">Alabama</option>
<option value="Wyoming">Wyoming</option>
            </select></td>
    </tr>
    <tr valign="baseline">
      <td align="right">Phone:</td>
      <td><input type="text" name="phone" value="" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td align="right">Story:</td>
      <td><textarea name="story" id="story" cols="45" rows="5"></textarea></td>
    </tr>
    <tr valign="baseline">
      <td align="right">&nbsp;</td>
      <td><input type="submit" value="Insert record" /></td>
    </tr>
  </table>
  <div align="center">
    <input type="hidden" name="MM_insert" value="form2" />
  </div>
</form>
 


Thanks for taking a look and helping out.

Re: Post to database and email me at the same time!!!

Posted: Wed Jun 10, 2009 12:50 pm
by califdon
All you have shown us is an HTML form. You haven't shown any PHP or database or email code. We can't help you without seeing what you are currently doing.

If you post here again, please enclose any code that you include within [syntax=php]and[/syntax] tags, to make it more easily read.

Re: Post to database and email me at the same time!!!

Posted: Wed Jun 10, 2009 1:21 pm
by shiftty
OK here is all the code from the page!

Code: Select all

 
<?php require_once('Connections/story.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
 
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($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 = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
 
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form2")) {
  $insertSQL = sprintf("INSERT INTO stories (name, i_am, they_are, email, city, `state`, phone, story) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['name'], "text"),
                       GetSQLValueString($_POST['i_am'], "text"),
                       GetSQLValueString($_POST['they_are'], "text"),
                       GetSQLValueString($_POST['email'], "text"),
                       GetSQLValueString($_POST['city'], "text"),
                       GetSQLValueString($_POST['state'], "text"),
                       GetSQLValueString($_POST['phone'], "text"),
                       GetSQLValueString($_POST['story'], "text"));
 
  mysql_select_db($database_story, $story);
  $Result1 = mysql_query($insertSQL, $story) or die(mysql_error());
 
  $insertGoTo = "thankyou.html";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en"><!-- InstanceBegin template="/Templates/Template.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1" />
<meta name="description" content="_your description goes here_" />
<meta name="keywords" content="_your,keywords,goes,here_" />
<meta name="author" content="_your name goes here_  / Original design: Andreas Viklund - http://andreasviklund.com/" />
<link rel="stylesheet" type="text/css" href="andreas03.css" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>Straight From Our Mouths</title>
<!-- InstanceEndEditable -->
<style type="text/css">
<!--
.style1 {font-size: 1em}
-->
</style>
<!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable -->
</head>
 
<body>
<div id="thetop">
<a id="top"></a>
<p class="hide">Skip to: <a href="#sitemenu" accesskey="2">Site menu</a> | <a href="#maincontent" accesskey="3">Main content</a></p>
</div>
 
<div id="container">
<div id="main"><img src="img/top_image.jpg" alt="top_image" width="523" height="206" /><br/>
<h3 class="headerstyle"><!-- InstanceBeginEditable name="EditRegion9" -->The idea behind the design<!-- InstanceEndEditable --></h3>
<!-- InstanceBeginEditable name="EditRegion" -->
<form action="<?php echo $editFormAction; ?>" method="post" id="form2">
  <div align="center"></div>
  <table align="center">
    <tr valign="baseline">
      <td align="right">Name:</td>
      <td><input type="text" name="name" value="" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td align="right">I am:</td>
      <td><select name="i_am" id="i_am">
        <option>Select...</option>
        <option value="Male">Male</option>
        <option value="Female">Female</option>
        </select>        </td>
    </tr>
    <tr valign="baseline">
      <td align="right">They are:</td>
      <td><select name="they_are" id="they_are">
        <option>Select...</option>
        <option value="Male">Male</option>
        <option value="Female">Female</option>
        </select>
        </td>
    </tr>
    <tr valign="baseline">
      <td align="right">Email:</td>
      <td><input type="text" name="email" value="" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td align="right">City:</td>
      <td><input type="text" name="city" value="" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td align="right">State:</td>
      <td><select name="state" size="1">
<option value="" selected="selected">Select...</option>
<option value="Alabama">Alabama</option>
<option value="Alaska">Alaska</option>
<option value="Arizona">Arizona</option>
<option value="Arkansas">Arkansas</option>
<option value="California">California</option>
<option value="Colorado">Colorado</option>
<option value="Connecticut">Connecticut</option>
<option value="Delaware">Delaware</option>
<option value="Florida">Florida</option>
<option value="Georgia">Georgia</option>
<option value="Hawaii">Hawaii</option>
<option value="Idaho">Idaho</option>
<option value="Illinois">Illinois</option>
<option value="Indiana">Indiana</option>
<option value="Iowa">Iowa</option>
<option value="Kansas">Kansas</option>
<option value="Kentucky">Kentucky</option>
<option value="Louisiana">Louisiana</option>
<option value="Maine">Maine</option>
<option value="Maryland">Maryland</option>
<option value="Massachusetts">Massachusetts</option>
<option value="Michigan">Michigan</option>
<option value="Minnesota">Minnesota</option>
<option value="Mississippi">Mississippi</option>
<option value="Missouri">Missouri</option>
<option value="Montana">Montana</option>
<option value="Nebraska">Nebraska</option>
<option value="Nevada">Nevada</option>
<option value="New Hampshire">New Hampshire</option>
<option value="New Jersey">New Jersey</option>
<option value="New Mexico">New Mexico</option>
<option value="New York">New York</option>
<option value="North Carolina">North Carolina</option>
<option value="North Dakota">North Dakota</option>
<option value="Ohio">Ohio</option>
<option value="Oklahoma">Oklahoma</option>
<option value="Oregon">Oregon</option>
<option value="Pennsylvania">Pennsylvania</option>
<option value="Rhode Island">Rhode Island</option>
<option value="South Carolina">South Carolina</option>
<option value="South Dakota">South Dakota</option>
<option value="Tennessee">Tennessee</option>
<option value="Texas">Texas</option>
<option value="Utah">Utah</option>
<option value="Vermont">Vermont</option>
<option value="Virginia">Virginia</option>
<option value="Washington">Washington</option>
<option value="West Virginia">West Virginia</option>
<option value="Wisconsin">Wisconsin</option>
<option value="Wyoming">Wyoming</option>
            </select></td>
    </tr>
    <tr valign="baseline">
      <td align="right">Phone:</td>
      <td><input type="text" name="phone" value="" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td align="right">Story:</td>
      <td><textarea name="story" id="story" cols="45" rows="5"></textarea></td>
    </tr>
    <tr valign="baseline">
      <td align="right">&nbsp;</td>
      <td><input type="submit" value="Insert record" /></td>
    </tr>
  </table>
  <div align="center">
    <input type="hidden" name="MM_insert" value="form2" />
  </div>
</form>
<p>&nbsp;</p>
<!-- InstanceEndEditable -->
<p class="internallink">[ <a href="#top">Back to top</a> ]
</p>
<h3 class="headerstyle">Banner</h3>
<p class="internallink">&nbsp;</p>
<p class="internallink">&nbsp;</p>
<p class="internallink">[ <a href="#top">Back to top</a> ]</p>
</div>
 
<div id="sidebar">
 
<h2 class="sidelink menuheader"><a id="sitemenu"></a>Site menu:</h2>
<a class="sidelink" href="index1.html">Home</a>
<span class="hide"> | </span>
<a class="sidelink" href="aboutus.html">About Us</a>
<span class="hide"> | </span>
<a class="sidelink" href="tell.html">Tell Your Story</a>
<span class="hide"> | </span>
<a class="sidelink" href="sowhatsnext.html">So What's Next?</a>
<span class="hide"> | </span>
<a class="sidelink" href="sample_stories.html">Sample Stories</a>
<span class="hide"> | </span><a class="sidelink" href="contactus.html">Contact Us</a><span class="hide"> | </span>
 
<a class="hide" href="#top" accesskey="1">Top of page</a>
 
<h3><br />
  Gear</h3>
<p>Now you can rock Hot Gear from SFOM.<br />
<a href="#">Click Here</a></p>
<p><center>
  <img src="img/shirt.jpg" alt="" width="125" height="138" />&nbsp;</center></p>
<h3>Alternate versions</h3>
<p>Included in this template are the following example files:<br />
- <a href="index.html">Main version</a><br />
- <a href="noimg.html">No images version</a><br />
- <a href="text-only.html">No CSS version</a></p>
<h3>Links</h3>
<p>
- <a href="http://andreasviklund.com/templates">Free website templates</a><br />
- <a href="http://openwebdesign.org">Open Web Design</a><br />
- <a href="http://oswd.org">OSWD.org</a><br />
- <a href="http://andreasviklund.com/music/lagoona">Lagoona MP3s</a>
</p>
 
</div>
<div class="clear">&nbsp;</div>
</div>
 
<div id="footer">
  <p>&copy; 2009 Straight From Our Mouths. Design by <a href="http://www.strictlydesigns.com" target="_blank">Strictly Designs</a></p>
</div>
 
</body>
<!-- InstanceEnd --></html>

Re: Post to database and email me at the same time!!!

Posted: Wed Jun 10, 2009 3:27 pm
by pickle
Right before you redirect the user (line 57), do a call to mail() with the necessary arguments.