Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #4304

Re: transfering all MySQL rows to an array

Path csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!news.wtal.de!news.tal.de!fu-berlin.de!uni-berlin.de!not-for-mail
From "M. Strobel" <sorry_no_mail_here@nowhere.dee>
Newsgroups comp.lang.php
Subject Re: transfering all MySQL rows to an array
Date Sun, 08 Jan 2012 18:57:00 +0100
Lines 44
Message-ID <9mu3ncF3n3U1@mid.uni-berlin.de> (permalink)
References <cYSdndOZupi1OJXSnZ2dnUVZ_s2dnZ2d@cablespeedmi.com> <jeac5t$9fm$2@dont-email.me> <Bc-dnXZdBI8hH5TSnZ2dnUVZ_gWdnZ2d@cablespeedmi.com> <9mtls9Fhk7U1@mid.uni-berlin.de> <jeck0e$3kc$1@dont-email.me>
Mime-Version 1.0
Content-Type text/plain; charset=UTF-8
Content-Transfer-Encoding 7bit
X-Trace news.uni-berlin.de 9A6mGmN7kUqo+/s94Wn8xw37jMSKo7hM3b3Ho2NtHwaOWIHws=
User-Agent Mozilla/5.0 (X11; U; Linux x86_64; de; rv:1.9.2.24) Gecko/20111101 SUSE/3.1.16 Lightning/1.0b2 Thunderbird/3.1.16
In-Reply-To <jeck0e$3kc$1@dont-email.me>
Xref x330-a1.tempe.blueboxinc.net comp.lang.php:4304

Show key headers only | View raw

Am 08.01.2012 18:33, schrieb Gregor Kofler:
> Am 2012-01-08 15:00, M. Strobel meinte:
>> Am 08.01.2012 12:49, schrieb bill:
>>> On 1/7/2012 4:07 PM, Jerry Stuckle wrote:
>>>> On 1/7/2012 3:03 PM, bill wrote:
>>>>> Yes, I know I can do it using a while statement, but is there a
>>>>> PHP
>>>>> mysql function to move all the data obtained in a query to an
>>>>> array that
>>>>> can be returned from a user written function in one statement ?
>>>>>
>>>>> bill
>>>>
>>>> No, you need to loop through all the rows returned and place them
>>>> in your own array.
>>>>
>>> Thanks, I will write my own.  But, I like to check before I
>>> reinvent the wheel.
>>>
>>> bill
>>
>> I would recommend to check if you can use PDO. The overhead is
>> minimal due to the fact it is a compiled extension
> 
> Can you elaborate on that? I'd say: Nonsense. (You know, mysqli and
> mysql are also "compiled extensions"...)
> 
> Gregor

PDO is an abstraction layer, but only at the call level. This is
better than none.

I think people only talking about mysql are thinking small. You
should not give away flexibility when it comes at small cost.

Small cost: the alleged performance of PDO is rather my
experience. Additionally the web search turned up in the first hits:
http://www.el-bato.de/it/php-mysql-vs-mysqli-vs-pdo-performance
(sorry, in german)

Before we start discussing benchmarks I would like to know: what
especially do you not like about it?

/Str.

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

transfering all MySQL rows to an array bill <nobody@spamcop.net> - 2012-01-07 15:03 -0500
  Re: transfering all MySQL rows to an array Luuk <Luuk@invalid.lan> - 2012-01-07 21:53 +0100
    Re: transfering all MySQL rows to an array Jerry Stuckle <jstucklex@attglobal.net> - 2012-01-07 20:06 -0500
      Re: transfering all MySQL rows to an array "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-01-08 14:54 +0100
        Re: transfering all MySQL rows to an array Jerry Stuckle <jstucklex@attglobal.net> - 2012-01-08 09:12 -0500
        Re: transfering all MySQL rows to an array Norman Peelman <npeelmandog@cfl.rr.com> - 2012-01-08 19:04 -0500
          Re: transfering all MySQL rows to an array "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-01-09 09:55 +0100
            Re: transfering all MySQL rows to an array Norman Peelman <npeelmandog@cfl.rr.com> - 2012-01-09 06:59 -0500
            Re: transfering all MySQL rows to an array Jerry Stuckle <jstucklex@attglobal.net> - 2012-01-09 07:05 -0500
    Re: transfering all MySQL rows to an array bill <nobody@spamcop.net> - 2012-01-08 06:47 -0500
  Re: transfering all MySQL rows to an array Jerry Stuckle <jstucklex@attglobal.net> - 2012-01-07 16:07 -0500
    Re: transfering all MySQL rows to an array bill <nobody@spamcop.net> - 2012-01-08 06:49 -0500
      Re: transfering all MySQL rows to an array "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-01-08 15:00 +0100
        Re: transfering all MySQL rows to an array Gregor Kofler <usenet@gregorkofler.com> - 2012-01-08 18:33 +0100
          Re: transfering all MySQL rows to an array "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-01-08 18:57 +0100
            Re: transfering all MySQL rows to an array Gregor Kofler <usenet@gregorkofler.com> - 2012-01-08 19:28 +0100
              Re: transfering all MySQL rows to an array "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-01-08 19:56 +0100
                Re: transfering all MySQL rows to an array Gregor Kofler <usenet@gregorkofler.com> - 2012-01-08 20:04 +0100
                Re: transfering all MySQL rows to an array "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-01-09 00:07 +0100
                Re: transfering all MySQL rows to an array Jerry Stuckle <jstucklex@attglobal.net> - 2012-01-08 19:02 -0500
                Re: transfering all MySQL rows to an array Erwin Moller <erwinmoller@xs4all.nl> - 2012-01-09 10:58 +0100
                Re: transfering all MySQL rows to an array Gregor Kofler <usenet@gregorkofler.com> - 2012-01-09 11:09 +0100
                Re: transfering all MySQL rows to an array Luuk <Luuk@invalid.lan> - 2012-01-09 11:27 +0100
                Re: transfering all MySQL rows to an array "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-01-09 11:41 +0100
                Re: transfering all MySQL rows to an array Gregor Kofler <usenet@gregorkofler.com> - 2012-01-09 13:24 +0100
                Re: transfering all MySQL rows to an array Luuk <Luuk@invalid.lan> - 2012-01-09 13:31 +0100
                Re: transfering all MySQL rows to an array "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-01-09 11:32 +0100
                Re: transfering all MySQL rows to an array Gregor Kofler <usenet@gregorkofler.com> - 2012-01-09 13:30 +0100
                Re: transfering all MySQL rows to an array "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-01-09 13:45 +0100
              Re: transfering all MySQL rows to an array Arno Welzel <usenet@arnowelzel.de> - 2012-01-08 20:31 +0100
                Re: transfering all MySQL rows to an array Gregor Kofler <usenet@gregorkofler.com> - 2012-01-08 22:43 +0100
          Re: transfering all MySQL rows to an array "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-01-08 19:22 +0100
          Re: transfering all MySQL rows to an array Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-01-09 02:05 +0100
      Re: transfering all MySQL rows to an array Peter <pete.ivesAll_stRESS@blueyonder.co.uk> - 2012-01-08 17:56 +0000
  Re: transfering all MySQL rows to an array Denis McMahon <denismfmcmahon@gmail.com> - 2012-01-08 09:39 +0000
    Re: transfering all MySQL rows to an array Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-01-08 11:31 +0100
      Re: transfering all MySQL rows to an array "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-01-08 15:02 +0100
        Re: transfering all MySQL rows to an array Denis McMahon <denismfmcmahon@gmail.com> - 2012-01-09 00:18 +0000
        Re: transfering all MySQL rows to an array Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-01-09 02:02 +0100
          Re: transfering all MySQL rows to an array Jerry Stuckle <jstucklex@attglobal.net> - 2012-01-08 22:02 -0500
          Re: transfering all MySQL rows to an array "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-01-09 10:06 +0100

csiph-web