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 #176474 is a reply to message #176472]

Sun, 08 January 2012 10:31

Thomas 'PointedEars'
Messages: 701
Registered: October 2010

Karma:

Senior Member

Denis McMahon wrote:

> On Sat, 07 Jan 2012 15:03:45 -0500, 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 ?
>
> If you're using the improved mysql interface (mysqli) I believe there's a
> function you can call on the result .... can't remember the name, but if
> you check the mysqli result documentation on the php documentation
> website it should be there.

It's mysqli_result::fetch_all(), of course. But PDO also has that feature
(PDOStatement::fetchAll()).

> I have a vague recollection that the availability of said function might
> refer on some php / mysql configuration options as well, or possibly
> build switches.

Posting your beliefs and vague ideas is helping nobody. If you are not sure
at all, simply do not post. We do not depend on you saving the world alone.

PointedEars
--
Anyone who slaps a 'this page is best viewed with Browser X' label on
a Web page appears to be yearning for the bad old days, before the Web,
when you had very little chance of reading a document written on another
computer, another word processor, or another network. -- Tim Berners-Lee

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 16:42:52 GMT 2024

Total time taken to generate the page: 0.03886 seconds