I am trying to insert into a mysql table and I'm getting a
parse error for an unexpected end of file. I am using a html file with a basic form for
users to enter data. I have a php file working alongside and when a user enters data it
is failing because of a parse error. I am a beginner in php so I would appreciate any
advice.
here is my html code:
html>
charset="UTF-8">
Grooming
Appointment
here is
my php:
$host="";
$port=3306;
$socket="";
$user="";
$password="";
$dbname="";
$con = new mysqli($host, $user, $password, $dbname,
$port, $socket)
or die ('Could not connect to the database server' .
mysqli_connect_error());
if( $_POST )
{
$con = mysql_connect("localhost","","");
if
(!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("pet_shop3",
$con);
$FirstName = $_POST['FirstName'];
$LastName = $_POST['LastName'];
$Address = $_POST['Address'];
$City = $_POST['City'];
$State = $_POST['State'];
$Zip =
$_POST['Zip'];
$PhoneNumber = $_POST['PhoneNumber'];
$Email =
$_POST['Email'];
$PetType = $_POST['PetType'];
$Breed =
$_POST['Breed'];
$PetName = $_POST['PetName'];
$NeuteredOrSpayed =
$_POST['NeuteredOrSpayed'];
$PetBirthday =
$_POST['PetBirthday'];
$query = "
INSERT INTO
`grooming` (`FirstName`, `LastName`, `Address`,
`City`, `State`, `Zip`,
`PhoneNumber`, `Email`, `PetType`, `Breed`, `PetName`, `NeuteredOrSpayed`,
`PetBirthday`) VALUES (NULL, '$users_FirstName','$users_LastName', '$users_Address',
'$users_City', '$users_Address', '$users_State', '$users_Zip', '$users_PhoneNumber',
'$users_Email', '$users_PetType', '$users_PetName', '$users_Breed', '$users_PetName',
'$users_NeuteredOrSpayed', '$users_PetBirthday',);";
mysql_query($query);
echo "Thank you, we will
contact you shortly!
";
mysql_close($con);
?>
No comments:
Post a Comment