Home / Questions / 357282
Accepted
Fernando Iam
Asked: 2020-05-20 10:37:56 +0800 CST 2020-05-20 10:37:56 +0800 CST

num_rows does not detect the rows in a valid query [duplicate]

  • 772

I want to validate if a query receives a record or not, and for that I am using num_rows, but it always detects 0 rows. But I try to make the query, and it prints data. I want to detect if it receives any data, because if not I want it to do an insert later.

$sql = "SELECT  id_oferta,id_usuario FROM historial WHERE id_oferta = ? AND id_usuario = ?";

                $stmt = $this->conn->prepare($sql);
                 $stmt->bind_param('ii',$id_oferta,$id_usuario);
                 $stmt->execute();   
                 $stmt->bind_result($oferta,$usuario);
                 $stmt->fetch();

                 $row_cnt = $stmt->num_rows;

                 printf("Result set has %d rows.\n", $row_cnt);

             $stmt->close();
            $this->conn->close();
php

1 Answers

  1. Best Answer

    Varies a bit using prepared statements: mysqli_stmt::$num_rows

    $stmt->execute();
// ...
$stmt->store_result();  
$row_cnt = $stmt->num_rows;
    • 1