Affected_rows返回负-1但插入

Question

I have the following PHP code, and when I execute it, affected_rows returns -1, but when I run a select in HeidiSQL, the data is in the table. Why does this happen?

$id = filter_input(INPUT_POST, 'id', FILTER_VALIDATE_INT);
$estatus = filter_input(INPUT_POST, 'estatus');
$larga = filter_input(INPUT_POST, 'larga');
$corta = filter_input(INPUT_POST, 'corta');
$fecha = filter_input(INPUT_POST, 'fecha');
$usuario = $_SESSION['id'];
$query = 'INSERT INTO tarea(oportunidad_id, estatus, usuarioId, tareaTarea, fechaLimite, tareaCorta)'
       . 'VALUES(' . $id . ', "' . utf8_decode($estatus) . '", ' . $usuario . ', "' . $larga . '", "' . $fecha .
     '", "' . $corta . '")';
$con->query($query) or exit("Error: " . $con->errno . ": " . $con->error);
if ($con->affected_rows > 0) {
    echo 'Tarea agregada';
} else {
    exit($con->mensaje_error());
}

Answer 1

if ($result = $con->query($query)){
    if($result->num_rows > 0){
        echo 'Tarea agregada';
    }
} else {
    exit($con->mensaje_error());
}

Try using num_rows instead of affected rows. And you are allowed to do $result = $con->query inside of this if statement, it does the same thing as $con->query($query) or exit(...

You can't ask the connection for the affected rows, you have to save the result as a variable and do ->affected_rows on that result.

The query isn't failing, the way you check the query is failing