What is the syntax for counting number of rows in PHP Prepared Statement?

Question

Hi,

In using PHP Prepared Statement, what is the syntax for counting number of rows?

---

$stmt = $conn->stmt_init(); $query = "SELECT * FROM TableName";

if($stmt->prepare($query)){
$stmt->num_row(); //SOMETHING SIMILAR TO THIS.... }

Answer 1

$stmt->num_rows

Answer 2

For mysqli its num_rows. Make sure you call store_result beforehand.

Answer 3

Hi, I am assuming your are using mysqli. If so, then affected_rows() should give you the number of rows will give you the number of rows returned by a SELECT operataion.