PHP and mysql problem

m_tyhurst2002 · August 14, 2007

I am submitting a form to a mysql database. I have four different tables in the database. I can submit the form to the database but the data for each table does not go in there own tables. I already have the tables in the database. Here is code. Can someone see anything I can do to get the data into there own tables? Thanks!

<html>

<head>

</head>

<body>

<?php

/* grabs the POST variables and puts them into variables that we can use */

$BuyerFirstName=$_POST['BuyerFirstName'];

$BuyerLastName=$_POST['BuyerLastName'];

$BuyerPhone=$_POST['BuyerPhone'];

$BuyerSSN=$_POST['BuyerSSN'];

$BuyerDOB=$_POST['BuyerDOB'];

$BuyerEmail=$_POST['BuyerEmail'];

$BuyerReEnterEmail=$_POST['BuyerReEnterEmail'];

$BuyerAddress=$_POST['BuyerAddress'];

$BuyerCity=$_POST['BuyerCity'];

$BuyerState=$_POST['BuyerState'];

$BuyerZip=$_POST['BuyerZip'];

$BuyerEmployerName=$_POST['BuyerEmployerName'];

$BuyerEmployerAddress=$_POST['BuyerEmployerAddress'];

$BuyerEmployerCity=$_POST['BuyerEmployerCity'];

$BuyerEmployerState=$_POST['BuyerEmployerState'];

$BuyerEmployerZip=$_POST['BuyerEmployerZip'];

$BuyerYearsEmployed=$_POST['BuyerYearsEmployed'];

$BuyerMonthlyIncome=$_POST['BuyerMonthlyIncome'];

$BuyerOtherIncome=$_POST['BuyerOtherIncome'];

$CoBuyerFirstName=$_POST['CoBuyerFirstName'];

$CoBuyerLastName=$_POST['CoBuyerLastName'];

$CoBuyerPhone=$_POST['CoBuyerPhone'];

$CoBuyerSSN=$_POST['CoBuyerSSN'];

$CoBuyerDOB=$_POST['CoBuyerDOB'];

$CoBuyerEmail=$_POST['CoBuyerEmail'];

$CoBuyerReEnterEmail=$_POST['CoBuyerReEnterEmail'];

$CoBuyerAddress=$_POST['CoBuyerAddress'];

$CoBuyerCity=$_POST['CoBuyerCity'];

$CoBuyerState=$_POST['CoBuyerState'];

$CoBuyerZip=$_POST['CoBuyerZip'];

$CoBuyerEmployerName=$_POST['CoBuyerEmployerName'];

$CoBuyerEmployerAddress=$_POST['CoBuyerEmployerAddress'];

$CoBuyerEmployerCity=$_POST['CoBuyerEmployerCity'];

$CoBuyerEmployerState=$_POST['CoBuyerEmployerState'];

$CoBuyerEmployerZip=$_POST['CoBuyerEmployerZip'];

$CoBuyerYearsEmployed=$_POST['CoBuyerYearsEmployed'];

$CoBuyerMonthlyIncome=$_POST['CoBuyerMonthlyIncome'];

$CoBuyerOtherIncome=$_POST['CoBuyerOtherIncome'];

$VehicleInfoYear=$_POST['VehicleInfoYear'];

$VehicleInfoMake=$_POST['VehicleInfoMake'];

$VehicleInfoModel=$_POST['VehicleInfoModel'];

$VehicleInfoColor=$_POST['VehicleInfoColor'];

$VehicleInfoEquipment=$_POST['VehicleInfoEquipment'];

$VehicleInfoComments=$_POST['VehicleInfoComments'];

$TradeInYear=$_POST['TradeInYear'];

$TradeInMake=$_POST['TradeInMake'];

$TradeInModel=$_POST['TradeInModel'];

$TradeInColor=$_POST['TradeInColor'];

$TradeInMiles=$_POST['TradeInMiles'];

$TradeInCondition=$_POST['TradeInCondition'];

$TradeInEquipment=$_POST['TradeInEquipment'];

//---------VALIDATION-------->

if($BuyerFirstName){//----> CHECK input

}

else{

$error.="Please, go back and fill out your first name \n";//----> ERROR if no input

}

if($BuyerLastName){//----> CHECK input

}

else{

$error.="Please, go back and fill out your last name \n";//----> ERROR if no input

}

if($BuyerEmail){//----> CHECK input

}

else{

$error.="Please, go back and fill out your e-mail address \n";//----> ERROR if no input

}

if($BuyerReEnterEmail){//----> CHECK input

}

else{

$error.="Please, go back and re-enter your e-mail address \n";//----> ERROR if no input

}

if($BuyerSSN){//----> CHECK input

}

else{

$error.="Please, go back and fill out your social security number \n";//----> ERROR if no input

}

if($BuyerDOB){//----> CHECK input

}

else{

$error.="Please, go back and fill out your date of birth \n";//----> ERROR if no input

}

if($BuyerPhone){//----> CHECK input

}

else{

$error.="Please, go back and fill out your phone number with area code \n";//----> ERROR if no input

}

if($BuyerAddress){//----> CHECK input

}

else{

$error.="Please, go back and fill out your mailing street address \n";//----> ERROR if no input

}

if($BuyerCity){//----> CHECK input

}

else{

$error.="Please, go back and fill out your city name \n";//----> ERROR if no input

}

if($BuyerZip){//----> CHECK input

}

else{

$error.="Please, go back and fill out your zip code \n";//----> ERROR if no input

}

if($BuyerState){//----> CHECK input

}

else{

$error.="Please, go back and select your state \n";//----> ERROR if no input

}

//-------->ERROR FREE??

if($error==""){

echo "Thank you for your Credit Application! A receipt of your submission will be e-mailed to you almost immediately.";

//----------------------------------

$mailContent="--------CONTACT--------\n"

."First Name: ".$BuyerFirstName."\n"

."Last Name: ".$BuyerLastName."\n"

."E-mail: ".$BuyerEmail."\n"

."Phone: ".$BuyerPhone."\n\n--------ADDRESS--------\n"

."Street Address: ".$address."\n"

."City: ".$city."\n"

."State: ".$state."\n"

."Zip Code: ".$zipCode."\n";

//----------------------------------

$toAddress="[email protected]"; /* change this! */

$subject="Consumer World Group Consumer Profile"; /* change this! */

$recipientSubject="MyWebSite.com's Contact Form"; /* change this! */

$receiptMessage = "Thank you ".$firstName." for inquiring about MyWebSite.com's Products!\n\n\nHere is what you submitted to us:\n\n"

."--------CONTACT--------\n"

."First Name: ".$BuyerFirstName."\n"

."Last Name: ".$BuyerLastName."\n"

."E-mail: ".$BuyerEmail."\n"

."Phone: ".$BuyerPhone."\n\n--------ADDRESS--------\n"

."Street Address: ".$address."\n"

."City: ".$city."\n"

."State: ".$state."\n"

."Zip Code: ".$zipCode."\n";

//----------------------------------

mail($email, $subject, $receiptMessage,"From:$toAddress");

//----------------------------------

mail($toAddress,$recipientSubject,$mailContent,"From:$email");

//--->echo $mailContent;

//////////////////////////////////////// CONNECT TO MYSQL DB ////////////////////

// OPEN CONNECTION --->

$connection=mysql_connect("localhost","username", "password") or die("Unable to connect!"); /* change this! */

mysql_select_db("letst5_cwg") or die("Unable to select database!"); /* change this! */

// EXECUTE QUERY --->

$query="INSERT INTO BuyerInfo (

BuyerFirstName,

BuyerLastName,

BuyerPhone,

BuyerSSN,

BuyerDOB,

BuyerEmail,

BuyerReEnterEmail,

BuyerAddress,

BuyerCity,

BuyerState,

BuyerZip,

BuyerEmployerName,

BuyerEmployerAddress,

BuyerEmployerCity,

BuyerEmployerState,

BuyerEmployerZip,

BuyerYearsEmployed,

BuyerMonthlyIncome,

BuyerOtherIncome)

VALUES(

'".$BuyerFirstName."',

'".$BuyerLastName."',

'".$BuyerPhone."',

'".$BuyerSSN."',

'".$BuyerDOB."',

'".$BuyerEmail."',

'".$BuyerReEnterEmail."',

'".$BuyerAddress."',

'".$BuyerCity."',

'".$BuyerState."',

'".$BuyerZip."',

'".$BuyerEmployerName."',

'".$BuyerEmployerAddress."',

'".$BuyerEmployerCity."',

'".$BuyerEmployerState."',

'".$BuyerEmployerZip."',

'".$BuyerYearsEmployed."',

'".$BuyerMonthlyIncome."',

'".$BuyerOtherIncome."')";

$query="INSERT INTO CoBuyerInfo (

CoBuyerFirstName,

CoBuyerLastName,

CoBuyerPhone,

CoBuyerSSN,

CoBuyerDOB,

CoBuyerEmail,

CoBuyerReEnterEmail,

CoBuyerAddress,

CoBuyerCity,

CoBuyerState,

CoBuyerZip,

CoBuyerEmployerName,

CoBuyerEmployerAddress,

CoBuyerEmployerCity,

CoBuyerEmployerState,

CoBuyerEmployerZip,

CoBuyerYearsEmployed,

CoBuyerMonthlyIncome,

CoBuyerOtherIncome)

VALUES(

'".$CoBuyerFirstName."',

'".$CoBuyerLastName."',

'".$CoBuyerPhone."',

'".$CoBuyerSSN."',

'".$CoBuyerDOB."',

'".$CoBuyerEmail."',

'".$CoBuyerReEnterEmail."',

'".$CoBuyerAddress."',

'".$CoBuyerCity."',

'".$CoBuyerState."',

'".$CoBuyerZip."',

'".$CoBuyerEmployerName."',

'".$CoBuyerEmployerAddress."',

'".$CoBuyerEmployerCity."',

'".$CoBuyerEmployerState."',

'".$CoBuyerEmployerZip."',

'".$CoBuyerYearsEmployed."',

'".$CoBuyerMonthlyIncome."',

'".$CoBuyerOtherIncome."')";

$query="INSERT INTO TradeInInfo (

TradeInYear,

TradeInMake,

TradeInModel,

TradeInColor,

TradeInMiles,

TradeInCondition,

TradeInEquipment)

VALUES(

'".$TradeInYear."',

'".$TradeInMake."',

'".$TradeInModel."',

'".$TradeInColor."',

'".$TradeInMiles."',

'".$TradeInCondition."',

'".$TradeInEquipment."')";

$query="INSERT INTO VehicleInfo (

VehicleInfoYear,

VehicleInfoMake,

VehicleInfoModel,

VehicleInfoColor,

VehicleInfoEquipment,

VehicleInfoComments)

VALUES(

'".$VehicleInfoYear."',

'".$VehicleInfoMake."',

'".$VehicleInfoModel."',

'".$VehicleInfoColor."',

'".$VehicleInfoEquipment."',

'".$VehicleInfoComments."')";

//////----->

$result=mysql_query($query) or die("Error in query:".mysql_error());

//if ($result)

//echo mysql_affected_rows()." row inserted into the database effectively.";

// CLOSE CONNECTION --->

mysql_close($connection);

///////////////////////////////////////////////////////////////////////////////////

}

else{

print "Sorry, but the form cannot be sent until the fields indicated are filled out completely - \n";

print "$error \n";

print " \n";

print "Please use your \"Back\" button to return to the form to correct the omissions. Thank you. \n";

}

?>

</body>

</html>

uwannadonkey · August 14, 2007

i may not see it, but did you connect to your mysql database?

nope, you did, hmmm, lemme keep looking

where are the Post variables coming from?

d22552000 · August 14, 2007

the third sql on line 87 has an UNescaped '.

This can cause parse errors, or sql errors.

m_tyhurst2002 · August 14, 2007

The post variables are coming from a seperate html page that "POST" for this contact.php script. I do not see anything on line 87 this is what is on line 87 for me: " else{ "

Thanks

Sign In

PHP and mysql problem

Recommended Posts

m_tyhurst2002

Link to comment

Share on other sites

uwannadonkey

Link to comment

Share on other sites

d22552000

Link to comment

Share on other sites

m_tyhurst2002

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information