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


Groups > comp.lang.php > #4346

Re: transfering all MySQL rows to an array

From Jerry Stuckle <jstucklex@attglobal.net>
Newsgroups comp.lang.php
Subject Re: transfering all MySQL rows to an array
Date 2012-01-09 07:05 -0500
Organization A noiseless patient Spider
Message-ID <jeel6m$cdl$1@dont-email.me> (permalink)
References (1 earlier) <dunmt8-bre.ln1@luuk.invalid.lan> <jeaq7a$pmm$1@dont-email.me> <9mtlhgFe7jU2@mid.uni-berlin.de> <jedatj$gvq$1@dont-email.me> <9mvobiFoklU1@mid.uni-berlin.de>

Show all headers | View raw


On 1/9/2012 3:55 AM, M. Strobel wrote:
> Am 09.01.2012 01:04, schrieb Norman Peelman:
>> On 01/08/2012 08:54 AM, M. Strobel wrote:
>>> Am 08.01.2012 02:06, schrieb Jerry Stuckle:
>>>> On 1/7/2012 3:53 PM, Luuk wrote:
>>>>> On 07-01-2012 21:03, 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
>>>>>
>>>>> you mean this:
>>>>> http://php.net/manual/en/pdostatement.fetchall.php
>>>>>
>>>>> ?
>>>>>
>>>>> (less than 5 mins of Google)
>>>>>
>>>>
>>>> Which only works if you're using PDO.  It doesn't work if you're
>>>> using the mysql(i)_xxx() functions.
>>>>
>>>
>>> Yes. Then he should use PDO, recommended.
>>>
>>> /Str.
>>
>> http://www.php.net/manual/en/mysqli-result.fetch-all.php
>>
>
> Thanks for telling me. If that function would not exist a foreach
> loop would do it.
>
> But I advocate PDO.
>
> I have the impression that on c.l.p posters do not care much
> about to whom they respond.
>
> /Str.

Your impression is incorrect.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

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