note 86670 added to mysqli-stmt.store-result

From: 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

« previous php.notes (#145917) next »