Unable to pass parameter by reference in MySQLi

Question

I am trying to pass a string to my prepared MySQLi statement, but it gives me an error:

Unable to pass parameter by reference in MySQLi

Here is the relevant code:

$kv = json_encode(array($key => $value)); $stmt->prepare("insert into rules (application_id, ruletype, rule_name, rule_info) values (?, ?, ?, ?);"); $stmt->bind_param('iiss', $application_id, 1, $config_name, $kv); 

Answer 1

'iiss' and '1' cannot be passed as a reference because they are not variables, but string constants. You need to create two variables with the specified values ​​and pass them, because the bind_param () function expects variables passed by reference.

Edit: this is '1', which causes the problem, not the name of the parameter associated ('iiss'). Sorry for the misinformation, I was in a hurry when I answered your question.

Answer 2

Check the $config_name argument. '1' does not pass as links