note 86670 added to mysqli-stmt.store-result
| From: | neromir at hotmail dot com | Date: | Wed, 29 Oct 2008 03:14:59 +0000 |
| Subject: | note 86670 added to mysqli-stmt.store-result | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-145917@lists.php.net to get a copy of this message | ||
The wording above, in the initial description of the function, can be confusing (quoted below).
"You must call mysqli_stmt_store_result() for every query that successfully produces a result
set (SELECT, SHOW, DESCRIBE, EXPLAIN), and only if you want to buffer the complete result set by the
client, so that the subsequent mysqli_stmt_fetch() call returns buffered data. "
I had initially understood the part saying "and only if you want to buffer..." to mean
that it was only necessary to call this function if you wanted to buffer the result set. This,
however, is not the case, and the misunderstanding caused me quite a bit of grief.
So, to clarify for anyone suffering from the same misunderstanding, you ALWAYS must call this
function for every query that produces a result set (as listed in the parentheses of the quote
above), as far as I can tell.
----
Server IP: 64.71.164.2
Probable Submitter: 67.171.114.52
----
Manual Page -- http://www.php.net/manual/en/mysqli-stmt.store-result.php
Edit -- https://master.php.net/note/edit/86670
Del: integrated -- https://master.php.net/note/delete/86670/integrated
Del: useless -- https://master.php.net/note/delete/86670/useless
Del: bad code -- https://master.php.net/note/delete/86670/bad+code
Del: spam -- https://master.php.net/note/delete/86670/spam
Del: non-english -- https://master.php.net/note/delete/86670/non-english
Del: in docs -- https://master.php.net/note/delete/86670/in+docs
Del: other reasons-- https://master.php.net/note/delete/86670
Reject -- https://master.php.net/note/reject/86670
Search -- https://master.php.net/manage/user-notes.php