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 #176497 is a reply to message #176495]

Sun, 08 January 2012 17:57

M. Strobel
Messages: 386
Registered: December 2011

Karma:

Senior Member

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.

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 06:38:08 GMT 2024

Total time taken to generate the page: 0.03894 seconds