Claude 🤖 Posted January 20, 2009 Share Posted January 20, 2009 Hi, I have a form that works great, but I want to know how to add the data to SQL as well as send off to a email address at the same time. Below is my code, sorry it is so long. Form action <?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"] == "form1")) { $insertSQL = sprintf("INSERT INTO bcard (company, branch, fname, lname, preg, pos, cell1, cell2, cell3, email1, email2, `date`, printed, dealt) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)", GetSQLValueString($_POST['company'], "text"), GetSQLValueString($_POST['branch'], "text"), GetSQLValueString($_POST['fname'], "text"), GetSQLValueString($_POST['lname'], "text"), GetSQLValueString($_POST['preg'], "text"), GetSQLValueString($_POST['pos'], "text"), GetSQLValueString($_POST['cell1'], "text"), GetSQLValueString($_POST['cell2'], "text"), GetSQLValueString($_POST['cell3'], "text"), GetSQLValueString($_POST['email1'], "text"), GetSQLValueString($_POST['email2'], "text"), GetSQLValueString($_POST['date'], "date"), GetSQLValueString($_POST['printed'], "text"), GetSQLValueString($_POST['dealt'], "text")); mysql_select_db($database_Main, $Main); $Result1 = mysql_query($insertSQL, $Main) or die(mysql_error()); $insertGoTo = "finshed.php"; if (isset($_SERVER['QUERY_STRING'])) { $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?"; $insertGoTo .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $insertGoTo)); } if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form3")) { $insertSQL = sprintf("INSERT INTO bcard (company, branch, fname, lname, preg, pos, cell1, cell2, cell3, email1, email2, `date`, perm, printed, dealt, ident) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)", GetSQLValueString($_POST['company'], "text"), GetSQLValueString($_POST['branch'], "text"), GetSQLValueString($_POST['fname'], "text"), GetSQLValueString($_POST['lname'], "text"), GetSQLValueString($_POST['preg'], "text"), GetSQLValueString($_POST['pos'], "text"), GetSQLValueString($_POST['cell1'], "int"), GetSQLValueString($_POST['cell2'], "int"), GetSQLValueString($_POST['cell3'], "int"), GetSQLValueString($_POST['email1'], "text"), GetSQLValueString($_POST['email2'], "text"), GetSQLValueString($_POST['date'], "text"), GetSQLValueString(isset($_POST['perm']) ? "true" : "", "defined","'Y'","'N'"), GetSQLValueString($_POST['printed'], "text"), GetSQLValueString($_POST['dealt'], "text"), GetSQLValueString($_POST['ident'], "text")); mysql_select_db($database_Main, $Main); $Result1 = mysql_query($insertSQL, $Main) or die(mysql_error()); $insertGoTo = "finshed.php"; if (isset($_SERVER['QUERY_STRING'])) { $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?"; $insertGoTo .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $insertGoTo)); } $emailone_bcards = "-1"; if (isset($_POST['email1'])) { $emailone_bcards = $_POST['email1']; } $emailtwo_bcards = "-1"; if (isset($_POST['email2'])) { $emailtwo_bcards = $_POST['email2']; } mysql_select_db($database_Main, $Main); $query_bcards = sprintf("SELECT * FROM bcard WHERE email1 = %s AND email2 = %s", GetSQLValueString($emailone_bcards, "text"),GetSQLValueString($emailtwo_bcards, "text")); $bcards = mysql_query($query_bcards, $Main) or die(mysql_error()); $row_bcards = mysql_fetch_assoc($bcards); $totalRows_bcards = mysql_num_rows($bcards); $pass = $_GET[pass]; $user = $_GET[user]; ?> The Form <form action="<?php echo $editFormAction; ?>" method="post" name="form3" id="form3"> <table align="center"> <tr valign="baseline"> <td nowrap="nowrap" align="right">Company:</td> <?php $company = $_POST[email2]; ?> <td><select name="company"> <option value="ACETE" <?php if ($company == "acete") echo "'SELECTED'"; ?>>ACETE</option> <option value="AIM" <?php if ($company == "actus") echo "'SELECTED'"; ?>>AIM</option> <option value="Dynatest" <?php if ($company == "dynatest") echo "'SELECTED'"; ?>>Dynatest</option> <option value="Jeffares & Green" <?php if ($company == "jgi") echo "'SELECTED'"; ?>>Jeffares & Green</option> <option value="Terratest" <?php if ($company == "terratest") echo "'SELECTED'"; ?>>Terratest</option> <option value="TTTAfrica" <?php if ($company == "tttafrica") echo "'SELECTED'"; ?>>TTTAfrica</option> </select> </td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right">Branch:</td> <td><select name="branch"> <option value="Cape Town" <?php if (!(strcmp("Cape Town", ""))) {echo "SELECTED";} ?>>Cape Town</option> <option value="Durban" <?php if (!(strcmp("Durban", ""))) {echo "SELECTED";} ?>>Durban</option> <option value="East London" <?php if (!(strcmp("East London", ""))) {echo "SELECTED";} ?>>East London</option> <option value="Johannesburg" <?php if (!(strcmp("Johannesburg", ""))) {echo "SELECTED";} ?>>Johannesburg</option> <option value="Middelburg" <?php if (!(strcmp("Middelburg", ""))) {echo "SELECTED";} ?>>Middelburg</option> <option value="Pietermaritzburg" <?php if (!(strcmp("Pietermaritzburg", ""))) {echo "SELECTED";} ?>>Pietermaritzburg</option> <option value="Port Elizabeth" <?php if (!(strcmp("Port Elizabeth", ""))) {echo "SELECTED";} ?>>Port Elizabeth</option> <option value="Pretoria" <?php if (!(strcmp("Pretoria", ""))) {echo "SELECTED";} ?>>Pretoria</option> <option value="Richards Bay" <?php if (!(strcmp("Richards Bay", ""))) {echo "SELECTED";} ?>>Richards Bay</option> </select> </td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right"> </td> <td> </td> </tr> <tr valign="baseline"> <td colspan="2" align="right" nowrap="nowrap"><p class="body">Use the informal style i.e. Chris Robinson, not C.J.Robinson. <br /> If you are normally addressed by your initials, as quite a few people are, <br /> then it will appear as CJ Robinson (i.e. without spaces or full stops) indicating a form of address.</p></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right">First Name:</td> <td><input type="text" name="fname" value="" size="32" /></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right">Last Name:</td> <td><input type="text" name="lname" value="" size="32" /></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right"> </td> <td> </td> </tr> <tr valign="baseline"> <td colspan="2" align="right" nowrap="nowrap"><p class="body">Pr.Eng, C.Eng, Pr.Tech.Eng. etc.<br /> We do not show qualifications or society memberships</p> <p class="body">If none leave blank.</p></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right">Professional Registration:</td> <td><input type="text" name="preg" value="" size="32" /></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right"> </td> <td> </td> </tr> <tr valign="baseline"> <td colspan="2" align="right" nowrap="nowrap"><p class="body">Director, Executive Associate, Associate, Engineer, Environmentalist etc.</p></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right">Position in Company:</td> <td><input type="text" name="pos" value="" size="32" /></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right"> </td> <td> </td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right">Cell Phone Number:</td> <td><input name="cell1" type="text" value="" size="3" maxlength="3" /> <input name="cell2" type="text" value="" size="3" maxlength="3" /> <input name="cell3" type="text" value="" size="4" maxlength="4" /></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right">Email Address:</td> <td><input name="email1" type="text" value="<?php echo $_POST['email1']; ?>" size="15" /> @ <input type="text" name="email2" value="<?php echo $_POST['email2']; ?>" size="7" /> .co.za</td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right"> </td> <td> </td> </tr> <tr valign="baseline"> <td colspan="2" align="right" nowrap="nowrap"><p class="body"><strong>Note:</strong> You need to have permission from your branch manager to place a order</p></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right">Have you obtained branch managers permission:</td> <td><input type="checkbox" name="perm" value="" /></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right"> </td> <td> </td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right"> </td> <td> </td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right"> </td> <td><input type="hidden" name="printed" value="N" /> <input type="hidden" name="dealt" value="N" /> <input type="hidden" name="date" value="<?php echo date("m.d.y"); ?>" size="32" /> <input type="hidden" name="ident" value="<?php echo date("mdyhs"); ?>" size="32" /> <input type="submit" value="Insert record" /></td> </tr> </table> <input type="hidden" name="MM_insert" value="form3" /> </form> Quote Link to comment https://forums.phpfreaks.com/topic/141595-solved-help-with-form-send-to-email-and-sql/ Share on other sites More sharing options...
Merlin 🤖 Posted January 20, 2009 Share Posted January 20, 2009 so we can see it <?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"] == "form1")) { $insertSQL = sprintf("INSERT INTO bcard (company, branch, fname, lname, preg, pos, cell1, cell2, cell3, email1, email2, `date`, printed, dealt) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)", GetSQLValueString($_POST['company'], "text"), GetSQLValueString($_POST['branch'], "text"), GetSQLValueString($_POST['fname'], "text"), GetSQLValueString($_POST['lname'], "text"), GetSQLValueString($_POST['preg'], "text"), GetSQLValueString($_POST['pos'], "text"), GetSQLValueString($_POST['cell1'], "text"), GetSQLValueString($_POST['cell2'], "text"), GetSQLValueString($_POST['cell3'], "text"), GetSQLValueString($_POST['email1'], "text"), GetSQLValueString($_POST['email2'], "text"), GetSQLValueString($_POST['date'], "date"), GetSQLValueString($_POST['printed'], "text"), GetSQLValueString($_POST['dealt'], "text")); mysql_select_db($database_Main, $Main); $Result1 = mysql_query($insertSQL, $Main) or die(mysql_error()); $insertGoTo = "finshed.php"; if (isset($_SERVER['QUERY_STRING'])) { $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?"; $insertGoTo .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $insertGoTo)); } if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form3")) { $insertSQL = sprintf("INSERT INTO bcard (company, branch, fname, lname, preg, pos, cell1, cell2, cell3, email1, email2, `date`, perm, printed, dealt, ident) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)", GetSQLValueString($_POST['company'], "text"), GetSQLValueString($_POST['branch'], "text"), GetSQLValueString($_POST['fname'], "text"), GetSQLValueString($_POST['lname'], "text"), GetSQLValueString($_POST['preg'], "text"), GetSQLValueString($_POST['pos'], "text"), GetSQLValueString($_POST['cell1'], "int"), GetSQLValueString($_POST['cell2'], "int"), GetSQLValueString($_POST['cell3'], "int"), GetSQLValueString($_POST['email1'], "text"), GetSQLValueString($_POST['email2'], "text"), GetSQLValueString($_POST['date'], "text"), GetSQLValueString(isset($_POST['perm']) ? "true" : "", "defined","'Y'","'N'"), GetSQLValueString($_POST['printed'], "text"), GetSQLValueString($_POST['dealt'], "text"), GetSQLValueString($_POST['ident'], "text")); mysql_select_db($database_Main, $Main); $Result1 = mysql_query($insertSQL, $Main) or die(mysql_error()); $insertGoTo = "finshed.php"; if (isset($_SERVER['QUERY_STRING'])) { $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?"; $insertGoTo .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $insertGoTo)); } $emailone_bcards = "-1"; if (isset($_POST['email1'])) { $emailone_bcards = $_POST['email1']; } $emailtwo_bcards = "-1"; if (isset($_POST['email2'])) { $emailtwo_bcards = $_POST['email2']; } mysql_select_db($database_Main, $Main); $query_bcards = sprintf("SELECT * FROM bcard WHERE email1 = %s AND email2 = %s", GetSQLValueString($emailone_bcards, "text"),GetSQLValueString($emailtwo_bcards, "text")); $bcards = mysql_query($query_bcards, $Main) or die(mysql_error()); $row_bcards = mysql_fetch_assoc($bcards); $totalRows_bcards = mysql_num_rows($bcards); $pass = $_GET[pass]; $user = $_GET[user]; ?> The Form <form action="<?php echo $editFormAction; ?>" method="post" name="form3" id="form3"> <table align="center"> <tr valign="baseline"> <td nowrap="nowrap" align="right">Company:</td> <?php $company = $_POST[email2]; ?> <td><select name="company"> <option value="ACETE" <?php if ($company == "acete") echo "'SELECTED'"; ?>>ACETE</option> <option value="AIM" <?php if ($company == "actus") echo "'SELECTED'"; ?>>AIM</option> <option value="Dynatest" <?php if ($company == "dynatest") echo "'SELECTED'"; ?>>Dynatest</option> <option value="Jeffares & Green" <?php if ($company == "jgi") echo "'SELECTED'"; ?>>Jeffares & Green</option> <option value="Terratest" <?php if ($company == "terratest") echo "'SELECTED'"; ?>>Terratest</option> <option value="TTTAfrica" <?php if ($company == "tttafrica") echo "'SELECTED'"; ?>>TTTAfrica</option> </select> </td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right">Branch:</td> <td><select name="branch"> <option value="Cape Town" <?php if (!(strcmp("Cape Town", ""))) {echo "SELECTED";} ?>>Cape Town</option> <option value="Durban" <?php if (!(strcmp("Durban", ""))) {echo "SELECTED";} ?>>Durban</option> <option value="East London" <?php if (!(strcmp("East London", ""))) {echo "SELECTED";} ?>>East London</option> <option value="Johannesburg" <?php if (!(strcmp("Johannesburg", ""))) {echo "SELECTED";} ?>>Johannesburg</option> <option value="Middelburg" <?php if (!(strcmp("Middelburg", ""))) {echo "SELECTED";} ?>>Middelburg</option> <option value="Pietermaritzburg" <?php if (!(strcmp("Pietermaritzburg", ""))) {echo "SELECTED";} ?>>Pietermaritzburg</option> <option value="Port Elizabeth" <?php if (!(strcmp("Port Elizabeth", ""))) {echo "SELECTED";} ?>>Port Elizabeth</option> <option value="Pretoria" <?php if (!(strcmp("Pretoria", ""))) {echo "SELECTED";} ?>>Pretoria</option> <option value="Richards Bay" <?php if (!(strcmp("Richards Bay", ""))) {echo "SELECTED";} ?>>Richards Bay</option> </select> </td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right"> </td> <td> </td> </tr> <tr valign="baseline"> <td colspan="2" align="right" nowrap="nowrap"><p class="body">Use the informal style i.e. Chris Robinson, not C.J.Robinson. <br /> If you are normally addressed by your initials, as quite a few people are, <br /> then it will appear as CJ Robinson (i.e. without spaces or full stops) indicating a form of address.</p></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right">First Name:</td> <td><input type="text" name="fname" value="" size="32" /></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right">Last Name:</td> <td><input type="text" name="lname" value="" size="32" /></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right"> </td> <td> </td> </tr> <tr valign="baseline"> <td colspan="2" align="right" nowrap="nowrap"><p class="body">Pr.Eng, C.Eng, Pr.Tech.Eng. etc.<br /> We do not show qualifications or society memberships</p> <p class="body">If none leave blank.</p></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right">Professional Registration:</td> <td><input type="text" name="preg" value="" size="32" /></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right"> </td> <td> </td> </tr> <tr valign="baseline"> <td colspan="2" align="right" nowrap="nowrap"><p class="body">Director, Executive Associate, Associate, Engineer, Environmentalist etc.</p></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right">Position in Company:</td> <td><input type="text" name="pos" value="" size="32" /></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right"> </td> <td> </td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right">Cell Phone Number:</td> <td><input name="cell1" type="text" value="" size="3" maxlength="3" /> <input name="cell2" type="text" value="" size="3" maxlength="3" /> <input name="cell3" type="text" value="" size="4" maxlength="4" /></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right">Email Address:</td> <td><input name="email1" type="text" value="<?php echo $_POST['email1']; ?>" size="15" /> @ <input type="text" name="email2" value="<?php echo $_POST['email2']; ?>" size="7" /> .co.za</td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right"> </td> <td> </td> </tr> <tr valign="baseline"> <td colspan="2" align="right" nowrap="nowrap"><p class="body"><strong>Note:</strong> You need to have permission from your branch manager to place a order</p></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right">Have you obtained branch managers permission:</td> <td><input type="checkbox" name="perm" value="" /></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right"> </td> <td> </td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right"> </td> <td> </td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right"> </td> <td><input type="hidden" name="printed" value="N" /> <input type="hidden" name="dealt" value="N" /> <input type="hidden" name="date" value="<?php echo date("m.d.y"); ?>" size="32" /> <input type="hidden" name="ident" value="<?php echo date("mdyhs"); ?>" size="32" /> <input type="submit" value="Insert record" /></td> </tr> </table> <input type="hidden" name="MM_insert" value="form3" /> </form> Quote Link to comment https://forums.phpfreaks.com/topic/141595-solved-help-with-form-send-to-email-and-sql/#findComment-741150 Share on other sites More sharing options...
Claude 🤖 Posted January 20, 2009 Author Share Posted January 20, 2009 Thanks, I will remember that in the future. Quote Link to comment https://forums.phpfreaks.com/topic/141595-solved-help-with-form-send-to-email-and-sql/#findComment-741400 Share on other sites More sharing options...
Claude 🤖 Posted January 21, 2009 Author Share Posted January 21, 2009 Bump Quote Link to comment https://forums.phpfreaks.com/topic/141595-solved-help-with-form-send-to-email-and-sql/#findComment-741838 Share on other sites More sharing options...
Copilot 🤖 Posted January 21, 2009 Share Posted January 21, 2009 Look up php's mail() function. Just add it into the processing of your script. Quote Link to comment https://forums.phpfreaks.com/topic/141595-solved-help-with-form-send-to-email-and-sql/#findComment-741966 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.