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

Groups > comp.lang.php > #4268 > unrolled thread

transfering all MySQL rows to an array

Back to article view | Back to comp.lang.php

Contents

  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

Page 2 of 3 — ← Prev page 1 [2] 3  Next page →

#4340

On 1/9/2012 1:02 AM, Jerry Stuckle wrote:
> On 1/8/2012 6:07 PM, M. Strobel wrote:
>> Am 08.01.2012 20:04, schrieb Gregor Kofler:
>>> Am 2012-01-08 19:56, M. Strobel meinte:
>> -------cut
>>>> compiled extension in C vs. extension in PHP.
>>>
>>> I'm not aware of extensions written in PHP. You could have classes or a
>>> framework written in PHP.
>>>
>>> Gregor
>>>
>>
>> Most or all of: Mailers, Filers, AJAX, ADODB, PEAR stuff, ...
>>
>> Maybe you would not call it extension...
>>
>> /Str.
>
> No, those are not extensions.
>

Hi Jerry and Gregor,

I am also confused by the naming used regarding extensions used in PHP.
I know extensions you enable in php.ini are "real" extensions in the 
sense that uncommenting them will add functionality to PHP (by means of 
exposing the functionality in a so or dll to PHP.).
This in contrast to adding functionality WRITTEN in PHP to PHP. (Like 
any function you write yourself in PHP.)

But the word "extension" is used a lot.
For example in PEAR:
PEAR - PHP Extension and Application Repository
while all in PEAR is only PHP-code (to my knowledge).

Just saying I can really understand Strobels confusion. :-)

Can you shed some light on that?
Was PEAR maybe a misnomer?

Regards,
Erwin Moller

-- 
"That which can be asserted without evidence, can be dismissed without 
evidence."
-- Christopher Hitchens

[toc] | [prev] | [next] | [standalone]

#4341

Am 2012-01-09 10:58, Erwin Moller meinte:
> On 1/9/2012 1:02 AM, Jerry Stuckle wrote:
>> On 1/8/2012 6:07 PM, M. Strobel wrote:
>>> Am 08.01.2012 20:04, schrieb Gregor Kofler:
>>>> Am 2012-01-08 19:56, M. Strobel meinte:
>>> -------cut
>>>>> compiled extension in C vs. extension in PHP.
>>>>
>>>> I'm not aware of extensions written in PHP. You could have classes or a
>>>> framework written in PHP.
>>>>
>>>> Gregor
>>>>
>>>
>>> Most or all of: Mailers, Filers, AJAX, ADODB, PEAR stuff, ...
>>>
>>> Maybe you would not call it extension...
>>>
>>> /Str.
>>
>> No, those are not extensions.
>>
> 
> Hi Jerry and Gregor,
> 
> I am also confused by the naming used regarding extensions used in PHP.
> I know extensions you enable in php.ini are "real" extensions in the
> sense that uncommenting them will add functionality to PHP (by means of
> exposing the functionality in a so or dll to PHP.).
> This in contrast to adding functionality WRITTEN in PHP to PHP. (Like
> any function you write yourself in PHP.)
> 
> But the word "extension" is used a lot.
> For example in PEAR:
> PEAR - PHP Extension and Application Repository
> while all in PEAR is only PHP-code (to my knowledge).
> 
> Just saying I can really understand Strobels confusion. :-)
> 
> Can you shed some light on that?

The manual features a list of "real" extensions:

http://php.net/manual/en/extensions.php

> Was PEAR maybe a misnomer?

IMO: Yes.

Gregor

[toc] | [prev] | [next] | [standalone]

#4342

On 09-01-2012 11:09, Gregor Kofler wrote:
> Am 2012-01-09 10:58, Erwin Moller meinte:
>> On 1/9/2012 1:02 AM, Jerry Stuckle wrote:
>>> On 1/8/2012 6:07 PM, M. Strobel wrote:
>>>> Am 08.01.2012 20:04, schrieb Gregor Kofler:
>>>>> Am 2012-01-08 19:56, M. Strobel meinte:
>>>> -------cut
>>>>>> compiled extension in C vs. extension in PHP.
>>>>>
>>>>> I'm not aware of extensions written in PHP. You could have classes or a
>>>>> framework written in PHP.
>>>>>
>>>>> Gregor
>>>>>
>>>>
>>>> Most or all of: Mailers, Filers, AJAX, ADODB, PEAR stuff, ...
>>>>
>>>> Maybe you would not call it extension...
>>>>
>>>> /Str.
>>>
>>> No, those are not extensions.
>>>
>>
>> Hi Jerry and Gregor,
>>
>> I am also confused by the naming used regarding extensions used in PHP.
>> I know extensions you enable in php.ini are "real" extensions in the
>> sense that uncommenting them will add functionality to PHP (by means of
>> exposing the functionality in a so or dll to PHP.).
>> This in contrast to adding functionality WRITTEN in PHP to PHP. (Like
>> any function you write yourself in PHP.)
>>
>> But the word "extension" is used a lot.
>> For example in PEAR:
>> PEAR - PHP Extension and Application Repository
>> while all in PEAR is only PHP-code (to my knowledge).
>>
>> Just saying I can really understand Strobels confusion. :-)
>>
>> Can you shed some light on that?
> 
> The manual features a list of "real" extensions:
> 
> http://php.net/manual/en/extensions.php
> 
>> Was PEAR maybe a misnomer?
> 
> IMO: Yes.
> 
> Gregor

Interesting reading from "What is PHP's MySQL Native Driver?" on
http://www.php.net/manual/en/mysqli.overview.php#mysqli.overview.mysqlnd

The mysql extension, the mysqli extension and the PDO MySQL driver *can*
each be individually configured to use either libmysql or mysqlnd. As
mysqlnd is designed specifically to be utilised in the PHP system it has
numerous memory and speed enhancements over libmysql. You are strongly
encouraged to take advantage of these improvements.

The table at the end suggests that PDO is the future when talking about
PHP<-->MySQL


-- 
Luuk

[toc] | [prev] | [next] | [standalone]

#4344

Am 09.01.2012 11:27, schrieb Luuk:

> Interesting reading from "What is PHP's MySQL Native Driver?" on
> http://www.php.net/manual/en/mysqli.overview.php#mysqli.overview.mysqlnd
> 
> The mysql extension, the mysqli extension and the PDO MySQL driver *can*
> each be individually configured to use either libmysql or mysqlnd. As
> mysqlnd is designed specifically to be utilised in the PHP system it has
> numerous memory and speed enhancements over libmysql. You are strongly
> encouraged to take advantage of these improvements.
> 
> The table at the end suggests that PDO is the future when talking about
> PHP<-->MySQL
> 
> 

Please all (interested in the subject) update my post (date
2012-01-08 18:57 MET) with this mysqlnd information.

/Str.

[toc] | [prev] | [next] | [standalone]

#4347

Am 2012-01-09 11:27, Luuk meinte:
> On 09-01-2012 11:09, Gregor Kofler wrote:
>> Am 2012-01-09 10:58, Erwin Moller meinte:
>>> On 1/9/2012 1:02 AM, Jerry Stuckle wrote:
>>>> On 1/8/2012 6:07 PM, M. Strobel wrote:
>>>>> Am 08.01.2012 20:04, schrieb Gregor Kofler:
>>>>>> Am 2012-01-08 19:56, M. Strobel meinte:
>>>>> -------cut
>>>>>>> compiled extension in C vs. extension in PHP.
>>>>>>
>>>>>> I'm not aware of extensions written in PHP. You could have classes or a
>>>>>> framework written in PHP.
>>>>>>
>>>>>> Gregor
>>>>>>
>>>>>
>>>>> Most or all of: Mailers, Filers, AJAX, ADODB, PEAR stuff, ...
>>>>>
>>>>> Maybe you would not call it extension...
>>>>>
>>>>> /Str.
>>>>
>>>> No, those are not extensions.
>>>>
>>>
>>> Hi Jerry and Gregor,
>>>
>>> I am also confused by the naming used regarding extensions used in PHP.
>>> I know extensions you enable in php.ini are "real" extensions in the
>>> sense that uncommenting them will add functionality to PHP (by means of
>>> exposing the functionality in a so or dll to PHP.).
>>> This in contrast to adding functionality WRITTEN in PHP to PHP. (Like
>>> any function you write yourself in PHP.)
>>>
>>> But the word "extension" is used a lot.
>>> For example in PEAR:
>>> PEAR - PHP Extension and Application Repository
>>> while all in PEAR is only PHP-code (to my knowledge).
>>>
>>> Just saying I can really understand Strobels confusion. :-)
>>>
>>> Can you shed some light on that?
>>
>> The manual features a list of "real" extensions:
>>
>> http://php.net/manual/en/extensions.php
>>
>>> Was PEAR maybe a misnomer?
>>
>> IMO: Yes.
>>
>> Gregor
> 
> Interesting reading from "What is PHP's MySQL Native Driver?" on
> http://www.php.net/manual/en/mysqli.overview.php#mysqli.overview.mysqlnd
> 
> The mysql extension, the mysqli extension and the PDO MySQL driver *can*
> each be individually configured to use either libmysql or mysqlnd. As
> mysqlnd is designed specifically to be utilised in the PHP system it has
> numerous memory and speed enhancements over libmysql. You are strongly
> encouraged to take advantage of these improvements.
> 
> The table at the end suggests that PDO is the future when talking about
> PHP<-->MySQL

Erm...

"
[...]

Recommended by MySQL for new projects
mysqli: Yes - preferred option
PDO: Yes

[...]
"

There's nothing wrong with PDO, but I can't see how this table proves
your claim.

Gregor

[toc] | [prev] | [next] | [standalone]

#4349

On 09-01-2012 13:24, Gregor Kofler wrote:
> Am 2012-01-09 11:27, Luuk meinte:
>> On 09-01-2012 11:09, Gregor Kofler wrote:
>>> Am 2012-01-09 10:58, Erwin Moller meinte:
>>>> On 1/9/2012 1:02 AM, Jerry Stuckle wrote:
>>>>> On 1/8/2012 6:07 PM, M. Strobel wrote:
>>>>>> Am 08.01.2012 20:04, schrieb Gregor Kofler:
>>>>>>> Am 2012-01-08 19:56, M. Strobel meinte:
>>>>>> -------cut
>>>>>>>> compiled extension in C vs. extension in PHP.
>>>>>>>
>>>>>>> I'm not aware of extensions written in PHP. You could have classes or a
>>>>>>> framework written in PHP.
>>>>>>>
>>>>>>> Gregor
>>>>>>>
>>>>>>
>>>>>> Most or all of: Mailers, Filers, AJAX, ADODB, PEAR stuff, ...
>>>>>>
>>>>>> Maybe you would not call it extension...
>>>>>>
>>>>>> /Str.
>>>>>
>>>>> No, those are not extensions.
>>>>>
>>>>
>>>> Hi Jerry and Gregor,
>>>>
>>>> I am also confused by the naming used regarding extensions used in PHP.
>>>> I know extensions you enable in php.ini are "real" extensions in the
>>>> sense that uncommenting them will add functionality to PHP (by means of
>>>> exposing the functionality in a so or dll to PHP.).
>>>> This in contrast to adding functionality WRITTEN in PHP to PHP. (Like
>>>> any function you write yourself in PHP.)
>>>>
>>>> But the word "extension" is used a lot.
>>>> For example in PEAR:
>>>> PEAR - PHP Extension and Application Repository
>>>> while all in PEAR is only PHP-code (to my knowledge).
>>>>
>>>> Just saying I can really understand Strobels confusion. :-)
>>>>
>>>> Can you shed some light on that?
>>>
>>> The manual features a list of "real" extensions:
>>>
>>> http://php.net/manual/en/extensions.php
>>>
>>>> Was PEAR maybe a misnomer?
>>>
>>> IMO: Yes.
>>>
>>> Gregor
>>
>> Interesting reading from "What is PHP's MySQL Native Driver?" on
>> http://www.php.net/manual/en/mysqli.overview.php#mysqli.overview.mysqlnd
>>
>> The mysql extension, the mysqli extension and the PDO MySQL driver *can*
>> each be individually configured to use either libmysql or mysqlnd. As
>> mysqlnd is designed specifically to be utilised in the PHP system it has
>> numerous memory and speed enhancements over libmysql. You are strongly
>> encouraged to take advantage of these improvements.
>>
>> The table at the end suggests that PDO is the future when talking about
>> PHP<-->MySQL
> 
> Erm...
> 
> "
> [...]
> 
> Recommended by MySQL for new projects
> mysqli: Yes - preferred option
> PDO: Yes
> 
> [...]
> "
> 
> There's nothing wrong with PDO, but I can't see how this table proves
> your claim.
> 
> Gregor
> 
> 
> 
> 

o, lol, it was not my claim, it was my understanding from looking at
that table....    (acvtive development as of PHP5.3...)

PDO cannot (yet) be the preferred option, because not all options have a
YES... ;)


-- 
Luuk

[toc] | [prev] | [next] | [standalone]

#4343

Am 09.01.2012 11:09, schrieb Gregor Kofler:
> Am 2012-01-09 10:58, Erwin Moller meinte:
---cut
> The manual features a list of "real" extensions:
> 
> http://php.net/manual/en/extensions.php
> 
>> Was PEAR maybe a misnomer?
> 
> IMO: Yes.
> 
> Gregor

I would like to check if of all the extensions listed in your
link are compiled, but do not have the time to install them all.

/Str.

[toc] | [prev] | [next] | [standalone]

#4348

Am 2012-01-09 11:32, M. Strobel meinte:
> Am 09.01.2012 11:09, schrieb Gregor Kofler:
>> Am 2012-01-09 10:58, Erwin Moller meinte:
> ---cut
>> The manual features a list of "real" extensions:
>>
>> http://php.net/manual/en/extensions.php
>>
>>> Was PEAR maybe a misnomer?
>>
>> IMO: Yes.
>>
>> Gregor
> 
> I would like to check if of all the extensions listed in your
> link are compiled, but do not have the time to install them all.

Quite a few of them are already part of the PHP core or added when
compiled with appropriate parameters. Just look up the "Installation"
page for each extension. None of the randomly picked extensions were not
"compiled". They are either part of the PHP core or belong to PECL.

Gregor

[toc] | [prev] | [next] | [standalone]

#4351

Am 09.01.2012 13:30, schrieb Gregor Kofler:
> Am 2012-01-09 11:32, M. Strobel meinte:
>> Am 09.01.2012 11:09, schrieb Gregor Kofler:
>>> Am 2012-01-09 10:58, Erwin Moller meinte:
>> ---cut
>>> The manual features a list of "real" extensions:
>>>
>>> http://php.net/manual/en/extensions.php
>>>
>>>> Was PEAR maybe a misnomer?
>>>
>>> IMO: Yes.
>>>
>>> Gregor
>>
>> I would like to check if of all the extensions listed in your
>> link are compiled, but do not have the time to install them all.
> 
> Quite a few of them are already part of the PHP core or added when
> compiled with appropriate parameters. Just look up the "Installation"
> page for each extension. None of the randomly picked extensions were not
> "compiled". They are either part of the PHP core or belong to PECL.
> 
> Gregor
I checked before posting few hours ago, these here are compiled.
I was wondering about them all.

/Str.

strobel@s114-intel:~> ll /usr/lib64/php5/extensions/
insgesamt 3604
-rw-r--r-- 1 root root   14688  7. Sep 16:31 ctype.so
-rw-r--r-- 1 root root  176272  7. Sep 16:31 dom.so
-rw-r--r-- 1 root root  339944  7. Sep 16:31 gd.so
-rw-r--r-- 1 root root  162720  7. Sep 16:31 hash.so
-rw-r--r-- 1 root root   43848  7. Sep 16:32 iconv.so
-rw-r--r-- 1 root root   35424  7. Sep 16:32 json.so
-rw-r--r-- 1 root root 2164512  7. Sep 16:32 mbstring.so
-rw-r--r-- 1 root root  128664  7. Sep 16:32 mysqli.so
-rw-r--r-- 1 root root   52000  7. Sep 16:32 mysql.so
-rw-r--r-- 1 root root   27608  7. Sep 16:32 pdo_mysql.so
-rw-r--r-- 1 root root  114128  7. Sep 16:32 pdo.so
-rw-r--r-- 1 root root   27896  7. Sep 16:32 pdo_sqlite.so
-rw-r--r-- 1 root root   14920  7. Sep 16:32 readline.so
-rw-r--r-- 1 root root   49704  7. Sep 16:32 sqlite3.so
-rw-r--r-- 1 root root   85672  7. Sep 16:32 sqlite.so
-rw-r--r-- 1 root root   18888  7. Sep 16:32 tokenizer.so
-rw-r--r-- 1 root root   31560  7. Sep 16:32 xmlreader.so
-rw-r--r-- 1 root root   47880  7. Sep 16:32 xmlwriter.so
-rw-r--r-- 1 root root   85944  7. Sep 16:32 zip.so
-rw-r--r-- 1 root root   40176  7. Sep 16:32 zlib.so
strobel@s114-intel:~> zypper search mysqlnd

[toc] | [prev] | [next] | [standalone]

#4314

Gregor Kofler, 2012-01-08 19:28:

> Am 2012-01-08 18:57, M. Strobel meinte:
[...]
>> Before we start discussing benchmarks I would like to know: what
>> especially do you not like about it?
> 
> You stating "the overhead is minimal due to the fact it is a compiled
> extension". Just being a compiled extension doesn't say anything about
> performance penalties (or lack thereof).

Ok, your point. But i also ask: What is the problem with PDO?

See also <http://jnrbsn.com/2010/06/mysqli-vs-pdo-benchmarks>



-- 
Arno Welzel
http://arnowelzel.de
http://de-rec-fahrrad.de

[toc] | [prev] | [next] | [standalone]

#4320

Am 2012-01-08 20:31, Arno Welzel meinte:
> Gregor Kofler, 2012-01-08 19:28:
> 
>> Am 2012-01-08 18:57, M. Strobel meinte:
> [...]
>>> Before we start discussing benchmarks I would like to know: what
>>> especially do you not like about it?
>>
>> You stating "the overhead is minimal due to the fact it is a compiled
>> extension". Just being a compiled extension doesn't say anything about
>> performance penalties (or lack thereof).
> 
> Ok, your point. But i also ask: What is the problem with PDO?

None in particular. I never said that there is "a problem" with PDO.
I said that

"[overhead of PDO is minimal] due to the fact it is a compiled extension"

is nonsense (since all extensions are "compiled extensions").

Gregor

[toc] | [prev] | [next] | [standalone]

#4306

Am 08.01.2012 18:33, schrieb Gregor Kofler:
> Am 2012-01-08 15:00, M. Strobel meinte:
>> 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

in addition to my post at 18:57 MET I would like to elaborate:

You cannot expect PDO to be faster than mysql[i]:

mysql is just a call interface from PHP to the mysql client lib.
Now PDO is a call interface to PDO_mysql which in turn calls the
client lib, that would be one level more.

This layered design is still state of the art. I said still
because it is so for a long time already.

If you find evidence that PDO might even perform better than the
direct mysql interface, this tells me:

- they are not doing something the others do and which is useful

- they are not doing something the others do and which is not needed

- they just did it right

So pick your reason.

/Str.

[toc] | [prev] | [next] | [standalone]

#4334

Gregor Kofler wrote:

> 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 ?
>>>> 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.
>> 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"...)

Please do not feed the troll (have you noticed their From header field 
value?).  Thank you in advance.


Regards,

PointedEars
-- 
> If you get a bunch of authors […] that state the same "best practices"
> in any programming language, then you can bet who is wrong or right...
Not with javascript. Nonsense propagates like wildfire in this field.
  -- Richard Cornford, comp.lang.javascript, 2011-11-14

[toc] | [prev] | [next] | [standalone]

#4303

In article <Bc-dnXZdBI8hH5TSnZ2dnUVZ_gWdnZ2d@cablespeedmi.com>, 
nobody@spamcop.net says...
> 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.
> 

Not much writing involved though. Just a couple of lines of code.

-- 
Pete Ives
Remove All_stRESS before sending me an email

[toc] | [prev] | [next] | [standalone]

#4279

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.

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.

Rgds

Denis McMahon

[toc] | [prev] | [next] | [standalone]

#4281

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

[toc] | [prev] | [next] | [standalone]

#4287

Am 08.01.2012 11:31, schrieb Thomas 'PointedEars' Lahn:
> 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.

Same to you. Pedants do not make a good helper.

> 
> 
> PointedEars

[toc] | [prev] | [next] | [standalone]

#4332

On Sun, 08 Jan 2012 15:02:11 +0100, M. Strobel wrote:

> Same to you. Pedants do not make a good helper.

trollpedant obviously missed the point of my post, which was that I'd 
seen the information OP was looking for in the documentation on the 
website, but couldn't remember exactly where, or exactly what it said, 
and I was suggesting that the OP go and read it himself, because I don't 
see any point in me doing OPs googling for him.

Rgds

Denis McMahon

[toc] | [prev] | [next] | [standalone]

#4333

M. Strobel wrote:

> Am 08.01.2012 11:31, schrieb Thomas 'PointedEars' Lahn:
>> 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.
> 
> Same to you. Pedants do not make a good helper.

I have posted a helpful and correct answer.  And you?


Score adjusted

PointedEars
-- 
Danny Goodman's books are out of date and teach practices that are
positively harmful for cross-browser scripting.
  -- Richard Cornford, cljs, <cife6q$253$1$8300dec7@news.demon.co.uk> (2004)

[toc] | [prev] | [next] | [standalone]

#4336

On 1/8/2012 8:02 PM, Thomas 'PointedEars' Lahn wrote:
> M. Strobel wrote:
>
>> Am 08.01.2012 11:31, schrieb Thomas 'PointedEars' Lahn:
>>> 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.
>>
>> Same to you. Pedants do not make a good helper.
>
> I have posted a helpful and correct answer.  And you?
>

ROFLMAO!

>
> Score adjusted
>
> PointedEars


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

[toc] | [prev] | [next] | [standalone]

Page 2 of 3 — ← Prev page 1 [2] 3  Next page →

Back to top | Article view | comp.lang.php

csiph-web