Getting parse error unexpected '")' in a PHP file…

Question

I have no idea why am I getting that error at the end of this line

 $sql = "INSERT INTO person (Name,Email,Date,Gender,WardType)
         VALUES ('$Name','$Email','$Date','$Gender','$WardType')");

Suppose the closing was supposed to be such? or '); but they all giving me the error.

What is that extra parenthesis doing there in the end? – Sergio Tulentsev Sep 28 '17 at 06:26 — Sergio Tulentsev, Sep 28 '17 at 06:26

Ketan Solanki · Answer 1 · 2017-09-28T06:36:26.330

-1

Try This and used concatenation

//$sql = "INSERT INTO person (Name,Email,Date,Gender,WardType) VALUES
//("'.$Name.'","'.$Email.'","'.$Date.'","'.$Gender.'","'.$WardType.'")";

Use this one now:

 $sql = "INSERT INTO person (Name,Email,Date,Gender,WardType) VALUES 
('".$Name."','".$Email."','".$Date."','".$Gender."','".$WardType."')";

There was a trailing ) at the end.

edited Sep 28 '17 at 06:36

answered Sep 28 '17 at 06:26

Ketan Solanki

697
5
13

That leads me to this – Peter Helao Sep 28 '17 at 06:33
Parse error: syntax error, unexpected ''.$Name.'' (T_CONSTANT_ENCAPSED_STRING) in C:\xampp\htdocs\tutorial\insert.php on line 23 – Peter Helao Sep 28 '17 at 06:33
Overal here is the whole thing – Peter Helao Sep 28 '17 at 06:34
$Name = $_POST['username']; $Email= $_POST['email']; $Email= $_POST['date']; $Email= $_POST['gender']; $Email= $_POST['wardtype']; $sql = "INSERT INTO person (Name,Email,Date,Gender,WardType) VALUES ("'.$Name.'","'.$Email.'","'.$Date.'","'.$Gender.'","'.$WardType.'")"; – Peter Helao Sep 28 '17 at 06:35
@PeterHelao I have edited the answer please have a look at it. – Ketan Solanki Sep 28 '17 at 06:37

score -1 · Answer 2 · answered Sep 28 '17 at 06:35

-1

You have an extra closing parethensis )

Should be like this

$sql = "INSERT INTO person (Name,Email,Date,Gender,WardType) VALUES ('$Name','$Email','$Date','$Gender','$WardType')";

answered Sep 28 '17 at 06:35

parpar

329
1
10

score -1 · Answer 3 · answered Sep 28 '17 at 06:47

 $sql = "INSERT INTO person (Name,Email,Date,Gender,WardType) VALUES ('$Name','$Email','$Date','$Gender','$WardType')";

You had a closed parenthesis in the end but it was never opened. Try this one it should work for you. All brackets/parenthesis must open and close if you forget one opened or close one that pairs nowhere you get this error.

Getting parse error unexpected '")' in a PHP file…

3 Answers3