Prepare Shows no error

Question

Does anyone know why you’re not showing error if you fail the execute of prepare?

$rs = $mysqli->prepare("INSERT INTO tabela (campo1, campo2, campo3) VALUES (?, ?, ?) ");

$rs->bind_param('sss',
    $_POST['campo1'],
    $_POST['campo2'],
    $_POST['campo3']
    );

$rs->execute();


if ($rs->errno) {
    echo 'Erro: ', $rs->error;
} else {
    echo "<script>window.location='PAGINA.php'</script>";
}

Answer 1

In your code the if is incorrect

if ($rs->errno)

is Rrno and not error.

In case of nothing you can test the

erroInfo()

for more information follow the documentation with examples:

https://www.php.net/manual/en/pdo.errorinfo.php