-4
Hello everyone I’m with a problem I can not understand or solve I’m novice in php. this code it inserts the data into the normal database but of that error.
Warning: mysqli_stmt::bind_param():
Number of variables doesn't match number of parameters in prepared statement in
Insertion code
$insert_data =("INSERT INTO acompanhamento (nome, email, fone, mensagem, date, hora, local, tipoproc, inlineRadioOptions, num_processo)
VALUES ('".$dados['nome']."', '".$dados['email']."', '".$dados['fone']."','".$dados['mensagem']."','".$dados['date']."','".$dados['hora']."','".$dados['local']."','".$dados['tipoproc']."','".$dados['inlineRadioOptions']."','".$dados['num_processo']."')");
$insert_data = $conn->prepare($insert_data);
$insert_data->execute();
$insert_data->bind_param('ssssssssss', $nome,$email,$fone,$mensagem,$date,$hora,$local,$inlineRadioOptions,$num_processo,$tipoproc);
Related: Comparing prepare() vs query() with mysqli
– Icaro Martins
Related: Insert data into database using mysqli
– Icaro Martins