For example: If you fill out all the fields in http://www.camarosource.ca/2006_calenda ... s_2006.htm and submit, it writes the info to the DB, but leaves out the ICQ, and CITY are both BLANK.YET the brief summary emailed to me shows it in fact saved the ICQ and CITY in it's correct variables so this means it's not WRITTING them to the DB..
Code: Select all
<?php
// create connection
$conn = mysql_connect("localhost","їPRIVATE]","їPRIVATE]")
or die(mysql_error());
// select database
$db = mysql_select_db("їPRIVATE]", $conn) or die(mysql_error());
// Set entered fields in Request Field as assigned variables
$NAME = $_POSTї'FULL_NAME'];
$EMAIL = $_POSTї'EMAIL'];
$URL = $_POSTї'URL'];
$ICQ = $_POSTї'ICQ'];
$MSN = $_POSTї'MSN'];
$AIM = $_POSTї'AIM'];
$YAHOO = $_POSTї'YAHOO'];
$ADDRESS = $_POSTї'ADDRESS'];
$CITY = $_POSTї'CITY'];
$PROVINCE_STATE = $_POSTї'PROVINCE_STATE'];
$COUNTRY = $_POSTї'COUNTRY'];
$POSTAL_ZIP = $_POSTї'POSTAL_ZIP'];
$YEAR = $_POSTї'CAMARO_YEAR'];
$MODEL = $_POSTї'CAMARO_MODEL'];
$PREFERRED_MONTH = $_POSTї'PREFERRED_MONTH'];
$SAID_TO_PURCHASE = $_POSTї'SAID_TO_PURCHASE'];
$SPECIAL_DATE = $_POSTї'SPECIAL_DATE'];
$CUSTOM_TITLE = $_POSTї'CUSTOM_TITLE'];
$PERSONALIZED_INFO = $_POSTї'PERSONALIZED_INFO'];
$MISSING = false;
//Start IF fields were blank
if ($NAME == "") {
$MISSING = true;
echo "<p><font color="#FF0000" size="4"><b>Please enter your FULL NAME</b></font></p>";
}
if ($EMAIL == "") {
$MISSING = true;
echo "<p><font color="#FF0000" size="4"><b>Please enter your EMAIL Address</b></font></p>";
}
if ($ADDRESS == "") {
$MISSING = true;
echo "<p><font color="#FF0000" size="4"><b>Please enter your ADDRESS</b></font></p>";
}
if ($CITY == "") {
$MISSING = true;
echo "<p><font color="#FF0000" size="4"><b>Please enter your CITY</b></font></p>";
}
if ($PROVINCE_STATE == "") {
$MISSING = true;
echo "<p><font color="#FF0000" size="4"><b>Please enter your PROVINCE / STATE</b></font></p>";
}
if ($COUNTRY == "--- Please Select ---") {
$MISSING = true;
echo "<p><font color="#FF0000" size="4"><b>Please select your COUNTRY</b></font></p>";
}
if ($POSTAL_ZIP == "") {
$MISSING = true;
echo "<p><font color="#FF0000" size="4"><b>Please enter your ZIP / POSTAL CODE</b></font></p>";
}
if ($YEAR == "") {
$MISSING = true;
echo "<p><font color="#FF0000" size="4"><b>Please enter the YEAR of your Camaro</b></font></p>";
}
if ($MODEL == "") {
$MISSING = true;
echo "<p><font color="#FF0000" size="4"><b>Please enter the MODEL of your Camaro</b></font></p>";
}
if ($SAID_TO_PURCHASE == "--- Please Select ---") {
$MISSING = true;
echo "<p><font color="#FF0000" size="4"><b>For Reference Purposes - Please specify how many calendars you would be interested in.</b></font></p>";
}
if ($PERSONALIZED_INFO == "") {
$MISSING = true;
echo "<p><font color="#FF0000" size="4"><b>Please enter your PERSONALIZED INFO.. This is what you want to have said in your Camaro Info bubble. Ie. Car specs, Mods, etc</b></font></p>";
}
if ($MISSING) exit;
// ------------------- Processing submitted data
// build our query
$query = "INSERT INTO user_submissions(FULL_NAME, EMAIL, URL, ICQ, MSN, AIM, YAHOO, ADDRESS, CITY, PROVINCE_STATE, COUNTRY, POSTAL_ZIP,
CAMARO_YEAR, CAMARO_MODEL, PREFERRED_MONTH, SAID_TO_PURCHASE, SPECIAL_DATE, CUSTOM_TITLE, PERSONALIZED_INFO, COMMENTS)
VALUES ('$NAME', '$EMAIL', '$URL', '$ICQ', '$MSN', '$AIM', '$YAHOO', '$ADDRESS', '$CITY', '$PROVINCE_STATE', '$COUNTRY', '$POSTAL_ZIP', '$CAMARO_YEAR',
'$CAMARO_MODEL', '$PREFERRED_MONTH', '$SAID_TO_PURCHASE', '$SPECIAL_DATE', '$CUSTOM_TITLE', '$PERSONALIZED_INFO', '$COMMENTS')";
// execute the query
mysql_query($query, $conn) or die (mysql_error());
submit() ;
// ------------------------------ ї Start compiling Application email to be sent to ME ] -----------------------------
function submit() {
$msg = "The following Person is interested in being in the 2006 Camarosource.ca Camaro Calendar. CHECK THE DATABASE\n\n";
$msg .= "Real Full Name : \t$_POSTїFULL_NAME]\n";
$msg .= "Email Address : \t$_POSTїEMAIL]\n";
$msg .= "Webpage URL : \t$_POSTїURL]\n";
$msg .= "ICQ : \t$_POSTїICQ]\n";
$msg .= "CITY : \t$_POSTїCITY]\n";
$msg .= "MSN : \t$_POSTїMSN]\n";
$msg .= "AIM : \t$_POSTїAIM]\n";
$msg .= "Yahoo! : \t$_POSTїYAHOO]\n";
$msg .= "Comments : \t$_POSTїCOMMENTS]\n";
$mailheaders = "From: \t$_POSTїEMAIL]\n";
$mailheaders .= "Reply-To: \t$_POSTїEMAIL]\n\n";
mail("PRIVATE","їPRIVATE]: 2006 Camaro Calendar Submission - INFO", $msg, $mailheaders);
}
?>