解析错误：语法错误，意外T_VARIABLE，INSERT INTO，php [重复]

Question

This question already has an answer here:

• PHP parse/syntax errors; and how to solve them? 17 answers
• How to combine two strings together in PHP? 17 answers

I have been looking for answers everywhere but just can't find out why I keep getting parse error for this line.

$sql = "INSERT INTO NIMET(NIMI) VALUES("$_POST['fname']")";

Can anyone tell me why this line gets a parse error?

</div>

Answer 1

$sql = "INSERT INTO NIMET(NIMI) VALUES(".$_POST['fname'].")";

You need to use . to combine strings.

There is also a fanzy way, but for that you need a new enough version from PHP:

$sql = "INSERT INTO NIMET(NIMI) VALUES({$_POST['fname']})";

I think the php-version you need for that is either 5.3 or 5.6. But I'm not shure about that.

Beside that: You shouldn't insert any unvalidated data from $_POST or $_GET into your DB. This could be used to insert malicious code.