Any way to get the amount of rows returned using mysqli prepared statements?

Question

Wondering if there is a way to get the amount of rows returned from a query using mysqli prepared statements, sort of like

mysql_num_rows($query);

Answer 1

Use this code:

$result = $mysqli->query($query);
$num_rows = $result->num_rows($result);

Answer 2

Presuming you're doing something like:

$result = $statement->execute();

You can get the number of rows with

$result->num_rows;

See the manual.