[RESOLVED] mysqli: num_rows with prepared statements?

[void_function]

Hi!

I am having problems finding out the number of rows in the result set, when using prepared statements and bound results.

The manual says I should use stored result set, but that is not, as far as I can see, compatible with prepared statements since two separate objects are being used. Here's the code.

//...

$dbStmt= $dbMysqli->prepare('SELECT a, b FROM table WHERE c=? AND d=?');
$dbStmt->bind_param('ii', $c, $d);
$dbStmt->execute();
$dbStmt->bind_result($a, $b);

// Need number of rows here, before the loop begins

while ($dbStmt->fetch()) {
	// Do someting with returned data
}
//...

[void_function]

Gah! I just found that mysqli_stmt object also has the store_result() method. So the complete code is:

    $dbStmt= $dbMysqli->prepare('SELECT a, b FROM table WHERE c=? AND d=?');
    $dbStmt->bind_param('ii', $c, $d);
	$dbStmt->execute();
	$dbStmt->store_result();
    $dbStmt->bind_result($a, $b);

// Need number of rows here, before the loop begins
   $num_rows= $dbStmt->num_rows;

while ($dbStmt->fetch()) {
    // Do someting with returned data
}