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;
Given that the data type is (following the order): Int, Int, Varchar, Date.
But you are not registering.