error with php file - insert query

Question

I'm having problems with insert details to mysql server. This is the code (a simple one):

<?php
//Input posted data.
$Fname = $_POST["Fname"];
$Lname = $_POST["Lname"];
$Date = $_POST["Date"];
$Mail = $_POST["Mail"];
$Pass = $_POST["Pass"];

// Create connection
$conn = mysqli_connect('localhost','root',"");

//Check if the connection was opened, if not prompt the error to the page.
if ($conn)
{
die('Could not connect: ' . mysql_error());
}

//Select the data base.
mysqli_select_db("club",$conn);

//Set the character set to utf-8 to allow hebrew.
mysqli_query("SET NAMES 'utf8'");   

//SQL query - user Details 
$sql = "INSERT INTO 'customers' (Fname, Lname, Mail, Date, Pass) 
VALUES('$Fname','$Lname','$Mail','$Date','$Pass');

//Run SQL query
$results = mysqli_query($query) or die (mysql_error());


//Close the SQL connection.
mysqli_close($conn);

?>

I'm getting this error:

Parse error: syntax error, unexpected end of file in C:\xampp\htdocs\Contact.php on line 36 <--- The last line

Can really use your help.

thanks in advance, Jason.

you have not close the query $sql string missing " at the end — ScaisEdge, Sep 04 '17 at 19:58
That's it...and also you code is vulnerable to sql injection. — Hackerman, Sep 04 '17 at 20:00

score 2 · Answer 1 · answered Sep 04 '17 at 20:01

2

$results=mysqli_query($sql);

you have given $query instead of $sql

answered Sep 04 '17 at 20:01

user223321

155
1
15

Good spot! Though – Rotimi Sep 04 '17 at 20:02
(Voted up so you can add this as a comment.) – Progrock Sep 04 '17 at 21:19
I want to thank you all guys with your help. I appreciate it. thanks again. – Jason B. Sep 06 '17 at 12:35
Also thanks JasonB. for assist. – user223321 Sep 06 '17 at 12:40

error with php file - insert query

1 Answers1