Saturday 4 November 2017

php - Trying to Insert data into mysql table and getting a parse error for unexpected end of file

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<br /> Appointment








id="FirstName">



for="LastName">Last Name:
name="LastName" id="LastName">





name="Address" id="Address">





type="City" name="City" id="City">





type="State" name="State" id="State">












id="PhoneNumber">



for="Email">Email:
id="Email">





name="PetType" id="PetType">





name="Breed" id="Breed">





for="PetName">PetName:
name="PetName" id="PetName">






id="NeuteredOrSpayed">





type="PetBirthday" name="PetBirthday" id="PetBirthday">











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

php - file_get_contents shows unexpected output while reading a file

I want to output an inline jpg image as a base64 encoded string, however when I do this : $contents = file_get_contents($filename); print &q...