Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
shiftty
Forum Newbie
Posts: 2 Joined: Wed Jun 10, 2009 12:32 pm
Post
by shiftty » Wed Jun 10, 2009 12:43 pm
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"> </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.
Last edited by
Benjamin on Wed Jun 10, 2009 1:42 pm, edited 1 time in total.
Reason: Added [code=html] tags.
califdon
Jack of Zircons
Posts: 4484 Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA
Post
by califdon » Wed Jun 10, 2009 12:50 pm
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.
shiftty
Forum Newbie
Posts: 2 Joined: Wed Jun 10, 2009 12:32 pm
Post
by shiftty » Wed Jun 10, 2009 1:21 pm
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"> </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> </p>
<!-- InstanceEndEditable -->
<p class="internallink">[ <a href="#top">Back to top</a> ]
</p>
<h3 class="headerstyle">Banner</h3>
<p class="internallink"> </p>
<p class="internallink"> </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" /> </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"> </div>
</div>
<div id="footer">
<p>© 2009 Straight From Our Mouths. Design by <a href="http://www.strictlydesigns.com" target="_blank">Strictly Designs</a></p>
</div>
</body>
<!-- InstanceEnd --></html>
Last edited by
Benjamin on Wed Jun 10, 2009 1:43 pm, edited 1 time in total.
Reason: Added [code=php] tags.
pickle
Briney Mod
Posts: 6445 Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:
Post
by pickle » Wed Jun 10, 2009 3:27 pm
Right before you redirect the user (line 57), do a call to mail() with the necessary arguments.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.