kindoman Posted January 21, 2009 Share Posted January 21, 2009 Hi I posted this question here before but I put the code in a very unreadable format. I cannot find an edit post link, so here it goes again. 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]; ?> 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/141714-solved-form-help-form-to-sql-and-email-again/ Share on other sites More sharing options...
jkewlo Posted January 21, 2009 Share Posted January 21, 2009 try this at the end of your script $to = $email; $subject = "Your subject to send"; $message = "Body of the Message Here "; $from = "your@email"; $headers = "From: $from"; mail($to, $subject, $message, $headers); Quote Link to comment https://forums.phpfreaks.com/topic/141714-solved-form-help-form-to-sql-and-email-again/#findComment-741899 Share on other sites More sharing options...
kindoman Posted January 21, 2009 Author Share Posted January 21, 2009 Thanks I did not know that it was that easy. I ajusted the mail script slightly: $fname = $_POST[fname]; $lname = $_POST[lname]; if ($fname != "" && $lname != "") { $sendto = "name@domain.co.za"; $subject = "New Business Card Order!"; $message = "There is a new business card order waiting to be processed\n From: $fname $lname"; $fromEmail = 'non-reply@jgi.co.za'; $headers = "From: $fromEmail"; mail($sendto,$subject,$message,$headers);} Quote Link to comment https://forums.phpfreaks.com/topic/141714-solved-form-help-form-to-sql-and-email-again/#findComment-741919 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.