PHP错误“T_ENCAPSED_AND_WHITESPACE，期待T_STRING”[关闭]

Question

I'm getting this error from when I updated my SQL query.

The error is on this line:

$update_sql = "UPDATE table SET `column1` = IF(LENGTH('$_POST['column1']')=0, column1, '$_POST['column1']'), `column2` =  '".$_POST['column2']."' WHERE name='".$_POST['movie_name']."';";

The error is:

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING

What's wrong with my code?

Answer 1

Bad string concatenation.

$update_sql = "UPDATE movies SET `nowvideo` = IF(LENGTH('" . $_POST['nowvideo'] . "')=0, nowvideo, '" . $_POST['nowvideo'] . "'), `nowvideohd` =  '".$_POST['nowvideohd']."' WHERE name='".$_POST['movie_name']."';";

As a side note, your query is very insecure. You're putting data directly from the form into a query. Read up on SQL injection & sanitizing your queries.

I'd also read up on PDO if you're planning on securing your queries anyway.