note 90089 added to mysqli-stmt.error

From: Date: Mon, 06 Apr 2009 00:55:27 +0000
Subject: note 90089 added to mysqli-stmt.error
Groups: php.notes 
Request: Send a blank email to php-notes+get-152846@lists.php.net to get a copy of this message
Note: The mysqli_stmt::num_rows doesn't work when used without mysqli_stmt::store_result. It may need more explanations as to why in the code above. <?php $stmt = $db->prepare('SELECT FirstName, LastName, Age FROM users WHERE UserID = ? ORDER BY LastName'); $stmt->execute(); $stmt->store_result(); $stmt->bind_result($firstname, $lastname, $age); if ($stmt->num_rows > 0) { while ($stmt->fetch()) { echo $firstname.' '.$lastname.': '.$age.' years old.'; } } else { echo 'No users with that ID.'; } ?> ---- Server IP: 69.147.83.197 Probable Submitter: 66.130.113.128 ---- Manual Page -- http://www.php.net/manual/en/mysqli-stmt.error.php Edit -- https://master.php.net/note/edit/90089 Del: integrated -- https://master.php.net/note/delete/90089/integrated Del: useless -- https://master.php.net/note/delete/90089/useless Del: bad code -- https://master.php.net/note/delete/90089/bad+code Del: spam -- https://master.php.net/note/delete/90089/spam Del: non-english -- https://master.php.net/note/delete/90089/non-english Del: in docs -- https://master.php.net/note/delete/90089/in+docs Del: other reasons-- https://master.php.net/note/delete/90089 Reject -- https://master.php.net/note/reject/90089 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#152846) next »