PHP error while update mysql table

Question

I have an update function in my website, when I run my update.php the error comes up.

(This is the error)

Parse error: syntax error, unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING) in C:\Xampp\htdocs\DBLogistic\update.php on line 9

(Here is my update.php)

<?php
include('connectdb.php');

if (isset($_POST['update'])) {

$sql ="UPDATE tbluser SET userNm='$_POST['newname']', userFullNm='$_POST['newfullname']', userEmail='$_POST['newemail']', userPhone='$_POST['newcontact']', userLvlId='$_POST['newlevel']', userStatus='$_POST['newstatus']' WHERE userId='$_POST['id']'"; //this is line 9

mysql_query($sql, $con);

}

?>

Thank you for help, do ask me for more information if needed.

Possible duplicate of PHP Parse/Syntax Errors; and How to solve them? — Machavity
– Machavity ♦, Commented Aug 11, 2016 at 3:05

twodee · Accepted Answer · 2016-08-11 03:19:14Z

1

<?php
include('connectdb.php');

if (isset($_POST['update'])) {

$sql ="UPDATE tbluser SETuserNm='".$_POST['newname']."',      userFullNm='".$_POST['newfullname']."', userEmai l='".$_POST['newemail']."'...";
 //... Represents the rest of the query
mysql_query($sql, $con); }

?>

Use the quotes in the similar way.

answered Aug 11, 2016 at 3:19

twodee

6065 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

rid · Accepted Answer · 2016-08-11 04:54:45Z

0

Change all '$_POST['value']' to "$_POST['value']" because it does not understand the value in ''.

edited Aug 11, 2016 at 4:54

rid

64k31 gold badges159 silver badges201 bronze badges

answered Aug 11, 2016 at 3:12

Văn Tuấn Phạm

6594 silver badges10 bronze badges

Collectives™ on Stack Overflow

PHP error while update mysql table

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related