Edit report at https://bugs.php.net/bug.php?id=19777&edit=1
ID: 19777
Comment by: risto78 at gmail dot com
Reported by: bav at graphit dot ru
Summary: We need mysql_fetch_all($mysql_result,[TYPE])
Status: Wont fix
Type: Feature/Change Request
Package: Feature/Change Request
Operating System: All
PHP Version: 4CVS-2002-10-06
Block user comment: N
Private report: N
New Comment:
the function overhead alone of calling this function in a loop several thousand
times should be enough to make a mysql_fetch_all function
Previous Comments:
------------------------------------------------------------------------
[2010-12-19 06:49:58] hafizanil at hotmail dot com
Currently on 2010.Everything data fetch in json.If the mysql result can directly push to json
data.It much speedier then looping the data and json_encode it again.
------------------------------------------------------------------------
[2002-10-10 09:03:28] bav at graphit dot ru
Sorry, but I see an advantage. Only one - speed.
Yes, I know, I can write php function for fetching :)
We are not idiots :)
------------------------------------------------------------------------
[2002-10-06 14:14:04] georg@php.net
Looks like the only reason is, that you don't want to write an addidtional line to fetch the
rows in a loop.
Do you see any other benefits?!
I only see disadvantages... if you need such functionality, why don't write a php-function
for?! Personally I don't know any Database, which supports such kind of functionality; who ever
introduced such a function in pgsql must be drunk :)
------------------------------------------------------------------------
[2002-10-06 05:05:20] bav at graphit dot ru
So, please, we need an analog of pg_fetch_all for mysql...
for speed
Assume TYPE of fetching is MYSQL_ASSOC etc...
We want to avoid manual fetching like following:
$rt = mysql_query("select from...");
while($cur = mysql_fetch_assoc($rt))
$result[]=$cur;
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=19777&edit=1