Mysqli Cannot pass Parameter 2 by Ference

Question

Colleagues.

I have the following code below:

$conexao = new mysqli('127.0.0.1','root','','teste');
if(mysqli_connect_errno()) die(trigger_error(mysqli_connect_errno()));

$cadastrar  = $conexao->prepare("INSERT INTO cad_produtos VALUES(?,?,?,?)");     
        $cadastrar->bind_param('iiss',
                                null,
                                '111',
                                '11',
                                '2016-03-01');
$cadastrar->execute();
$idCod = $cadastrar->insert_id;

The data type being (following the order): Int, Int, Varchar, Date.

But you are not registering.

Answer 1

bind_param() does not accept values as second argument, only references or variables, make the assignment of values in it and solved problem.

The error generated is:

Fatal error: Cannot pass Parameter 2 by Reference in

Change:

$cadastrar->bind_param('iiss', null, '111', '11', '2016-03-01');

To:

$id = null;
$var = 111;
var2= 11;
$data= '2016-03-01';
$cadastrar->bind_param('iiss', $id, $var, $va2, $data);