我尝试编写插入语句时出现PHP语法错误[重复]

Question

This question already has an answer here:

• PHP parse/syntax errors; and how to solve them? 17 answers

So I am having the $sql variable which is supposed to be a string containing an sql insert statement.Here's the piece of code:

$fields = array('Nume_dep' => $params['Nume_dep'],
                'Id_manager' => $params['Id_manager']);
$id = $params['Id_manager'];
$sql = "insert into departament(Nume_dep,Id_manager) values('$params['Nume_dep']', CONVERT($id, UNSIGNED))";

This is the error message that I get:

Parse error: syntax error, unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING)

The syntax error is in the insert statement, but I don't know how to fix it.

</div>

Answer 1

$id = $params['Id_manager'];
$nume_dep=$params['Nume_dep'];

$sql = "INSERT INTO departament(Nume_dep,Id_manager) values('$nume_dep', CONVERT($id, UNSIGNED))";