Php form email help!

jacrave · May 16, 2013

i am new to php, and its been 10 years since i touched the html or net with coding, and i am trying to post a form to our sql database but also email it so we know when we have a new registration, but when the email arrives it is blank, here is the code...

<?php

$email_to = "jacrave@gmail.com";

$email_subject = "Your email subject line";

$email_message = "Form details below.\n\n";

function clean_string($string) {

$bad = array("content-type","bcc:","to:","cc:","href");

return str_replace($bad,"",$string);

}

$email_message .= "First Name: ".($varFirst)."\n";

$email_message .= "Last Name: ".($varLast)."\n";

$email_message .= "Email: ".($varEmail)."\n";

$email_message .= "Phone Number: ".($varPhone)."\n";

$email_message .= "Address: ".($varAddress1)."\n";

$email_message .= "City: ".($varCity)."\n";

$email_message .= "State: ".($varState)."\n";

$email_message .= "Zip: ".($varZip)."\n";

$email_message .= "DL number: ".($varDlnum)."\n";

$email_message .= "DL State: ".($varDlstate)."\n";

$email_message .= "Gender: ".($varGender)."\n";

// create email headers

$headers = 'From: '.$varEmail."\r\n".

'Reply-To: '.$varEmail."\r\n" .

'X-Mailer: PHP/' . phpversion();

@mail($email_to, $email_subject, $email_message, $headers);

?>

any help would be greatly appricated! thanks in advance

davidannis · May 16, 2013

The @ before the mail suppresses error messages. I would remove it for testing at least. Is the body of the e-mail completely blank? Did it ever work? Is the subject line blank?

jacrave · May 17, 2013

the subject line comes through and the body is as follows:

Form details below.

First Name:
Last Name:
Email:
Phone Number:
Address:
City:
State:
Zip:
DL number:
DL State:
Gender:

the form poplulates but without the inputed data

teynon · May 17, 2013

Either you didn't post the entire code, or that's your problem. This is incomplete code. Or you have global variables on.

davidannis · May 17, 2013

I don't see where your variable, such as $varFirst are assigned values.

jacrave · May 17, 2013

Here is the complete code...

<?php

if($_POST['formSubmit'] == "Submit")

{

$errorMessage = "";

if(empty($_POST['formFirst']))

{

$errorMessage .= "<li>You forgot to enter a First Name!</li>";

}

if(empty($_POST['formLast']))

{

$errorMessage .= "<li>You forgot to enter a Last Name!</li>";

}

if(empty($_POST['formPhone']))

{

$errorMessage .= "<li>You forgot to enter a Phone Number!</li>";

}

if(empty($_POST['formEmail']))

{

$errorMessage .= "<li>You forgot to enter a Email Address</li>";

}

if(empty($_POST['formAddress1']))

{

$errorMessage .= "<li>You forgot to enter a Address!</li>";

}

if(empty($_POST['formCity']))

{

$errorMessage .= "<li>You forgot to enter a City!</li>";

}

if(empty($_POST['formZip']))

{

$errorMessage .= "<li>You forgot to enter a Zip Code!</li>";

}

if(empty($_POST['formDlnum']))

{

$errorMessage .= "<li>You forgot to enter a Driver License Number!</li>";

}

if(empty($_POST['formGender']))

{

$errorMessage .= "<li>You forgot to select your Gender!</li>";

}

if(empty($_POST['formDlstate']))

{

$errorMessage .= "<li>You forgot to select your Driver License State!</li>";

}

if(empty($_POST['formState']))

{

$errorMessage .= "<li>You forgot to select your State!</li>";

}

$varFirst = $_POST['formFirst'];

$varLast = $_POST['formLast'];

$varEmail = $_POST['formEmail'];

$varPhone = $_POST['formPhone'];

$varAddress1 = $_POST['formAddress1'];

$varCity = $_POST['formCity'];

$varZip = $_POST['formZip'];

$varDlnum = $_POST['formDlnum'];

$varGender = $_POST['formGender'];

$varDlstate = $_POST['formDlstate'];

$varState = $_POST['formState'];

if(empty($errorMessage))

{

$db = mysql_connect("XXX.XXX.XXX.XXX","XXXXXXXXX","XXXXXXXXX!!");

if(!$db) die("Error connecting to MySQL database.");

mysql_select_db("XXXXXXXXX" ,$db);

$sql = "INSERT INTO XXXXXXXXX (formFirst, formLast, formEmail, formPhone, formAddress1, formCity, formState, formZip, formDlnum, formDlstate, formGender) VALUES (".

PrepSQL($varFirst) . ", " .

PrepSQL($varLast) . ", " .

PrepSQL($varEmail) . ", " .

PrepSQL($varPhone) . "," .

PrepSQL($varAddress1) . ", " .

PrepSQL($varCity) . ", " .

PrepSQL($varState) . ", " .

PrepSQL($varZip) . ", " .

PrepSQL($varDlnum) . ", " .

PrepSQL($varDlstate) . ", " .

PrepSQL($varGender) . ")";

mysql_query($sql);

header("Location: thankyou.html");

exit();

}

// function: PrepSQL()

// use stripslashes and mysql_real_escape_string PHP functions

// to sanitize a string for use in an SQL query

//

// also puts single quotes around the string

//

function PrepSQL($value)

{

// Stripslashes

if(get_magic_quotes_gpc())

{

$value = stripslashes($value);

}

// Quote

$value = "'" . mysql_real_escape_string($value) . "'";

return($value);

}

?>

<?php

$email_to = "jacrave@gmail.com";

$email_subject = "MM Signup";

$email_message = "Form details below.\n\n";

function clean_string($string) {

$bad = array("content-type","bcc:","to:","cc:","href");

return str_replace($bad,"",$string);

}

$email_message .= "First Name: ".($varFirst)."\n";

$email_message .= "Last Name: ".($varLast)."\n";

$email_message .= "Email: ".($varEmail)."\n";

$email_message .= "Phone Number: ".($varPhone)."\n";

$email_message .= "Address: ".($varAddress1)."\n";

$email_message .= "City: ".($varCity)."\n";

$email_message .= "State: ".($varState)."\n";

$email_message .= "Zip: ".($varZip)."\n";

$email_message .= "DL number: ".($varDlnum)."\n";

$email_message .= "DL State: ".($varDlstate)."\n";

$email_message .= "Gender: ".($varGender)."\n";

// create email headers

$headers = 'From: '.$varEmail."\r\n".

'Reply-To: '.$varEmail."\r\n" .

'X-Mailer: PHP/' . phpversion();

@mail($email_to, $email_subject, $email_message, $headers);

?>

<html>

<head>

<style>

label,a

{

font-family : Arial, Helvetica, sans-serif;

font-size : 12px;

}

</style>

</head>

<body>

<?php

if(!empty($errorMessage))

{

echo("<p>There was an error with your form:</p>\n");

echo("<ul>" . $errorMessage . "</ul>\n");

}

?>

<form action="<?php echo htmlentities($_SERVER['PHP_SELF']); ?>" method="post">

<p>

<label for='formFirst'>First Name?</label><br/>

</p>

<p>

</p>

<p>

<label for='formEmail'>Email Address?</label><br/>

</p>

<p>

<label for='formPhone'>Phone Number?</label><br/>

</p>

<p>

<label for='formAddress1'>Street Address?</label><br/>

</p>

<p>

</p>

<p>

<label for='formState'> State?</label><br/>

<option selected value="">State...</option>

<option value="AL"<? if($varState=="AL") echo(" selected=\"selected\"");?>>Alabama</option>

<option value="AK"<? if($varState=="AK") echo(" selected=\"selected\"");?>>Alaska</option>

<option value="AZ"<? if($varState=="AZ") echo(" selected=\"selected\"");?>>Arizona</option>

<option value="AR"<? if($varState=="AR") echo(" selected=\"selected\"");?>>Arkansas</option>

<option value="CA"<? if($varState=="CA") echo(" selected=\"selected\"");?>>California</option>

<option value="CO"<? if($varState=="CO") echo(" selected=\"selected\"");?>>Colorado</option>

<option value="CT"<? if($varState=="CT") echo(" selected=\"selected\"");?>>Connecticut</option>

<option value="DE"<? if($varState=="DE") echo(" selected=\"selected\"");?>>Delaware</option>

<option value="FL"<? if($varState=="FL") echo(" selected=\"selected\"");?>>Florida</option>

<option value="GA"<? if($varState=="GA") echo(" selected=\"selected\"");?>>Georgia</option>

<option value="HI"<? if($varState=="HI") echo(" selected=\"selected\"");?>>Hawaii</option>

<option value="ID"<? if($varState=="ID") echo(" selected=\"selected\"");?>>Idaho</option>

<option value="IL"<? if($varState=="IL") echo(" selected=\"selected\"");?>>Illinois</option>

<option value="IN"<? if($varState=="IN") echo(" selected=\"selected\"");?>>Indiana</option>

<option value="KS"<? if($varState=="KS") echo(" selected=\"selected\"");?>>Kansas</option>

<option value="KY"<? if($varState=="KY") echo(" selected=\"selected\"");?>>Kentucky</option>

<option value="LA"<? if($varState=="LA") echo(" selected=\"selected\"");?>>Louisiana</option>

<option value="ME"<? if($varState=="ME") echo(" selected=\"selected\"");?>>Maine</option>

<option value="MD"<? if($varState=="MD") echo(" selected=\"selected\"");?>>Maryland</option>

<option value="MA"<? if($varState=="MA") echo(" selected=\"selected\"");?>>Massachusetts</option>

<option value="MI"<? if($varState=="MI") echo(" selected=\"selected\"");?>>Michigan</option>

<option value="MN"<? if($varState=="MN") echo(" selected=\"selected\"");?>>Minnesota</option>

<option value="MS"<? if($varState=="MS") echo(" selected=\"selected\"");?>>Mississippi</option>

<option value="MO"<? if($varState=="MO") echo(" selected=\"selected\"");?>>Missouri</option>

<option value="MT"<? if($varState=="MT") echo(" selected=\"selected\"");?>>Montana</option>

<option value="NE"<? if($varState=="NE") echo(" selected=\"selected\"");?>>Nebraska</option>

<option value="NV"<? if($varState=="NV") echo(" selected=\"selected\"");?>>Nevada</option>

<option value="NH"<? if($varState=="NH") echo(" selected=\"selected\"");?>>New Hampshire</option>

<option value="NJ"<? if($varState=="NJ") echo(" selected=\"selected\"");?>>New Jersey</option>

<option value="NM"<? if($varState=="NM") echo(" selected=\"selected\"");?>>New Mexico</option>

<option value="NC"<? if($varState=="NC") echo(" selected=\"selected\"");?>>North Carolina</option>

<option value="ND"<? if($varState=="ND") echo(" selected=\"selected\"");?>>North Dakota</option>

<option value="OK"<? if($varState=="OK") echo(" selected=\"selected\"");?>>Oklahoma</option>

<option value="OR"<? if($varState=="OR") echo(" selected=\"selected\"");?>>Oregon</option>

<option value="PA"<? if($varState=="PA") echo(" selected=\"selected\"");?>>Pennsylvania</option>

<option value="RI"<? if($varState=="RI") echo(" selected=\"selected\"");?>>Rhode Island</option>

<option value="SC"<? if($varState=="SC") echo(" selected=\"selected\"");?>>South Carolina</option>

<option value="SD"<? if($varState=="SD") echo(" selected=\"selected\"");?>>South Dakota</option>

<option value="TN"<? if($varState=="TN") echo(" selected=\"selected\"");?>>Tennessee</option>

<option value="TX"<? if($varState=="TX") echo(" selected=\"selected\"");?>>Texas</option>

<option value="VT"<? if($varState=="VT") echo(" selected=\"selected\"");?>>Vermont</option>

<option value="VA"<? if($varState=="VA") echo(" selected=\"selected\"");?>>Virginia</option>

<option value="WA"<? if($varState=="WA") echo(" selected=\"selected\"");?>>Washington</option>

<option value="WV"<? if($varState=="WV") echo(" selected=\"selected\"");?>>West Virginia</option>

<option value="WI"<? if($varState=="WI") echo(" selected=\"selected\"");?>>Wisconsin</option>

<option value="WY"<? if($varState=="WY") echo(" selected=\"selected\"");?>>Wyoming</option>

</select>

</p>

<p>

</p>

<p>

<label for='formDlnum'>Driver License Number?</label>

<br/>

</p>

<label for='formDlstate'> State?</label><br/>

<option selected value="">State...</option>

<option value="AL"<? if($varDlstate=="AL") echo(" selected=\"selected\"");?>>Alabama</option>

<option value="AK"<? if($varDlstate=="AK") echo(" selected=\"selected\"");?>>Alaska</option>

<option value="AZ"<? if($varDlstate=="AZ") echo(" selected=\"selected\"");?>>Arizona</option>

<option value="AR"<? if($varDlstate=="AR") echo(" selected=\"selected\"");?>>Arkansas</option>

<option value="CA"<? if($varDlstate=="CA") echo(" selected=\"selected\"");?>>California</option>

<option value="CO"<? if($varDlstate=="CO") echo(" selected=\"selected\"");?>>Colorado</option>

<option value="CT"<? if($varDlstate=="CT") echo(" selected=\"selected\"");?>>Connecticut</option>

<option value="DE"<? if($varDlstate=="DE") echo(" selected=\"selected\"");?>>Delaware</option>

<option value="FL"<? if($varDlstate=="FL") echo(" selected=\"selected\"");?>>Florida</option>

<option value="GA"<? if($varDlstate=="GA") echo(" selected=\"selected\"");?>>Georgia</option>

<option value="HI"<? if($varDlstate=="HI") echo(" selected=\"selected\"");?>>Hawaii</option>

<option value="ID"<? if($varDlstate=="ID") echo(" selected=\"selected\"");?>>Idaho</option>

<option value="IL"<? if($varDlstate=="IL") echo(" selected=\"selected\"");?>>Illinois</option>

<option value="IN"<? if($varDlstate=="IN") echo(" selected=\"selected\"");?>>Indiana</option>

<option value="KS"<? if($varDlstate=="KS") echo(" selected=\"selected\"");?>>Kansas</option>

<option value="KY"<? if($varDlstate=="KY") echo(" selected=\"selected\"");?>>Kentucky</option>

<option value="LA"<? if($varDlstate=="LA") echo(" selected=\"selected\"");?>>Louisiana</option>

<option value="ME"<? if($varDlstate=="ME") echo(" selected=\"selected\"");?>>Maine</option>

<option value="MD"<? if($varDlstate=="MD") echo(" selected=\"selected\"");?>>Maryland</option>

<option value="MA"<? if($varDlstate=="MA") echo(" selected=\"selected\"");?>>Massachusetts</option>

<option value="MI"<? if($varDlstate=="MI") echo(" selected=\"selected\"");?>>Michigan</option>

<option value="MN"<? if($varDlstate=="MN") echo(" selected=\"selected\"");?>>Minnesota</option>

<option value="MS"<? if($varDlstate=="MS") echo(" selected=\"selected\"");?>>Mississippi</option>

<option value="MO"<? if($varDlstate=="MO") echo(" selected=\"selected\"");?>>Missouri</option>

<option value="MT"<? if($varDlstate=="MT") echo(" selected=\"selected\"");?>>Montana</option>

<option value="NE"<? if($varDlstate=="NE") echo(" selected=\"selected\"");?>>Nebraska</option>

<option value="NV"<? if($varDlstate=="NV") echo(" selected=\"selected\"");?>>Nevada</option>

<option value="NH"<? if($varDlstate=="NH") echo(" selected=\"selected\"");?>>New Hampshire</option>

<option value="NJ"<? if($varDlstate=="NJ") echo(" selected=\"selected\"");?>>New Jersey</option>

<option value="NM"<? if($varDlstate=="NM") echo(" selected=\"selected\"");?>>New Mexico</option>

<option value="NC"<? if($varDlstate=="NC") echo(" selected=\"selected\"");?>>North Carolina</option>

<option value="ND"<? if($varDlstate=="ND") echo(" selected=\"selected\"");?>>North Dakota</option>

<option value="OK"<? if($varDlstate=="OK") echo(" selected=\"selected\"");?>>Oklahoma</option>

<option value="OR"<? if($varDlstate=="OR") echo(" selected=\"selected\"");?>>Oregon</option>

<option value="PA"<? if($varDlstate=="PA") echo(" selected=\"selected\"");?>>Pennsylvania</option>

<option value="RI"<? if($varDlstate=="RI") echo(" selected=\"selected\"");?>>Rhode Island</option>

<option value="SC"<? if($varDlstate=="SC") echo(" selected=\"selected\"");?>>South Carolina</option>

<option value="SD"<? if($varDlstate=="SD") echo(" selected=\"selected\"");?>>South Dakota</option>

<option value="TN"<? if($varDlstate=="TN") echo(" selected=\"selected\"");?>>Tennessee</option>

<option value="TX"<? if($varDlstate=="TX") echo(" selected=\"selected\"");?>>Texas</option>

<option value="VT"<? if($varDlstate=="VT") echo(" selected=\"selected\"");?>>Vermont</option>

<option value="VA"<? if($varDlstate=="VA") echo(" selected=\"selected\"");?>>Virginia</option>

<option value="WA"<? if($varDlstate=="WA") echo(" selected=\"selected\"");?>>Washington</option>

<option value="WV"<? if($varDlstate=="WV") echo(" selected=\"selected\"");?>>West Virginia</option>

<option value="WI"<? if($varDlstate=="WI") echo(" selected=\"selected\"");?>>Wisconsin</option>

<option value="WY"<? if($varDlstate=="WY") echo(" selected=\"selected\"");?>>Wyoming</option>

</select>

</p>

<p>

<label for='formGender'>Gender?</label><br/>

<option value="">Select...</option>

<option value="F"<? if($varGender=="F") echo(" selected=\"selected\"");?>>Female</option>

</select>

</p>

</form>

</p>

</body>

</html>

jazzman1 · May 17, 2013

Wow....dude...a lot of code, use the code (<>) tags that the editor of the forum provides us

Just put down error_reporting(-1) on the top of your files and for debugging sql's use mysql_error()

jacrave · May 17, 2013

ohh sorry lol

davidannis · May 17, 2013

I can't see the error. Does error reporting tell you anything?

Sign In

Php form email help!

Recommended Posts

jacrave

Link to comment

Share on other sites

davidannis

Link to comment

Share on other sites

jacrave

Link to comment

Share on other sites

teynon

Link to comment

Share on other sites

davidannis

Link to comment

Share on other sites

jacrave

Link to comment

Share on other sites

jazzman1

Link to comment

Share on other sites

jacrave

Link to comment

Share on other sites

davidannis

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information