FUDforum: comp.lang.php » transfering all MySQL rows to an array

Home » Imported messages » comp.lang.php » transfering all MySQL rows to an array

Show: Today's Messages :: Polls :: Message Navigator

Re: transfering all MySQL rows to an array [message #176479 is a reply to message #176476]

Sun, 08 January 2012 14:00

M. Strobel
Messages: 386
Registered: December 2011

Karma:

Senior Member

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, and the
object functions are just gorgeous: each row goes into one object.

Together with objects specifically defined for your database
tables this makes an easy start into OO.

/Str.

Report message to a moderator

[Message index]

		transfering all MySQL rows to an array By: bill on Sat, 07 January 2012 20:03
		Re: transfering all MySQL rows to an array By: Luuk on Sat, 07 January 2012 20:53
		Re: transfering all MySQL rows to an array By: Jerry Stuckle on Sun, 08 January 2012 01:06
		Re: transfering all MySQL rows to an array By: M. Strobel on Sun, 08 January 2012 13:54
		Re: transfering all MySQL rows to an array By: Jerry Stuckle on Sun, 08 January 2012 14:12
		Re: transfering all MySQL rows to an array By: Norman Peelman on Mon, 09 January 2012 00:04
		Re: transfering all MySQL rows to an array By: M. Strobel on Mon, 09 January 2012 08:55
		Re: transfering all MySQL rows to an array By: Norman Peelman on Mon, 09 January 2012 11:59
		Re: transfering all MySQL rows to an array By: Jerry Stuckle on Mon, 09 January 2012 12:05
		Re: transfering all MySQL rows to an array By: bill on Sun, 08 January 2012 11:47
		Re: transfering all MySQL rows to an array By: Jerry Stuckle on Sat, 07 January 2012 21:07
		Re: transfering all MySQL rows to an array By: bill on Sun, 08 January 2012 11:49
		Re: transfering all MySQL rows to an array By: M. Strobel on Sun, 08 January 2012 14:00
		Re: transfering all MySQL rows to an array By: Gregor Kofler on Sun, 08 January 2012 17:33
		Re: transfering all MySQL rows to an array By: M. Strobel on Sun, 08 January 2012 17:57
		Re: transfering all MySQL rows to an array By: Gregor Kofler on Sun, 08 January 2012 18:28
		Re: transfering all MySQL rows to an array By: M. Strobel on Sun, 08 January 2012 18:56
		Re: transfering all MySQL rows to an array By: Gregor Kofler on Sun, 08 January 2012 19:04
		Re: transfering all MySQL rows to an array By: M. Strobel on Sun, 08 January 2012 23:07
		Re: transfering all MySQL rows to an array By: Jerry Stuckle on Mon, 09 January 2012 00:02
		Re: transfering all MySQL rows to an array By: Erwin Moller on Mon, 09 January 2012 09:58
		Re: transfering all MySQL rows to an array By: Gregor Kofler on Mon, 09 January 2012 10:09
		Re: transfering all MySQL rows to an array By: Luuk on Mon, 09 January 2012 10:27
		Re: transfering all MySQL rows to an array By: M. Strobel on Mon, 09 January 2012 10:41
		Re: transfering all MySQL rows to an array By: Gregor Kofler on Mon, 09 January 2012 12:24
		Re: transfering all MySQL rows to an array By: Luuk on Mon, 09 January 2012 12:31
		Re: transfering all MySQL rows to an array By: M. Strobel on Mon, 09 January 2012 10:32
		Re: transfering all MySQL rows to an array By: Gregor Kofler on Mon, 09 January 2012 12:30
		Re: transfering all MySQL rows to an array By: M. Strobel on Mon, 09 January 2012 12:45
		Re: transfering all MySQL rows to an array By: Arno Welzel on Sun, 08 January 2012 19:31
		Re: transfering all MySQL rows to an array By: Gregor Kofler on Sun, 08 January 2012 21:43
		Re: transfering all MySQL rows to an array By: M. Strobel on Sun, 08 January 2012 18:22
		Re: transfering all MySQL rows to an array By: Thomas 'PointedEars' on Mon, 09 January 2012 01:05
		Re: transfering all MySQL rows to an array By: Peter on Sun, 08 January 2012 17:56
		Re: transfering all MySQL rows to an array By: Denis McMahon on Sun, 08 January 2012 09:39
		Re: transfering all MySQL rows to an array By: Thomas 'PointedEars' on Sun, 08 January 2012 10:31
		Re: transfering all MySQL rows to an array By: M. Strobel on Sun, 08 January 2012 14:02
		Re: transfering all MySQL rows to an array By: Denis McMahon on Mon, 09 January 2012 00:18
		Re: transfering all MySQL rows to an array By: Thomas 'PointedEars' on Mon, 09 January 2012 01:02
		Re: transfering all MySQL rows to an array By: Jerry Stuckle on Mon, 09 January 2012 03:02
		Re: transfering all MySQL rows to an array By: M. Strobel on Mon, 09 January 2012 09:06

Previous Topic:	sessions timeout
Next Topic:	scoping inside a block

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 05:43:42 GMT 2024

Total time taken to generate the page: 0.05797 seconds