Re: Prep. Statements only in mysql-i? [message #177675 is a reply to message #177673] |
Thu, 12 April 2012 20:34 |
Jerry Stuckle
Messages: 2598 Registered: September 2010
Karma:
|
Senior Member |
|
|
On 4/12/2012 2:23 PM, M. Strobel wrote:
> Am 12.04.2012 20:08, schrieb Jerry Stuckle:
>> On 4/12/2012 1:28 PM, M. Strobel wrote:
>>> Am 12.04.2012 19:16, schrieb Jerry Stuckle:
>>>> On 4/12/2012 11:22 AM, M. Strobel wrote:
>>>> > Am 12.04.2012 13:51, schrieb Jerry Stuckle:
>>>> >> On 4/12/2012 6:33 AM, M. Strobel wrote:
>>>> >>> Am 12.04.2012 00:42, schrieb Alexandra Herzog:
>>>> >>>
>>>> >>>> but my hoster only offers mysql
>>>> >>>
>>>> >>> It makes me angry to hear this. The mysql drivers were outdated long before the
>>>> >>> makers stopped supporting it in 2006.
>>>> >>>
>>>> >>> /Str.
>>>> >>
>>>> >> MySQL not supported? Who says? It's the most commonly used database on the web.
>>>> >> PostgreSQL and others are way behind in popularity (although I won't get into an
>>>> >> argument as to which is "better").
>>>> >>
>>>> >> Or if you mean the mysql interface vs. mysqli, who says it isn't supported?
>>>> >
>>>> > mysql interface vs. mysqli. I know the first is old and slower, and the support info
>>>> > I just read at http://www.radicore.org/radicore-for-php.php
>>>> >
>>>> > /Str.
>>>> >
>>>>
>>>> And how do you "know" that? Both end up as calls to mysql_xxxx C functions. The
>>>> mysql_xxx calls in PHP are just wrappers to the C functions. The mysqli_xxx calls
>>>> have to do a lot more work before calling the appropriate mysql_xxx C functions.
>>>>
>>>> If the mysqli_xxx calls have to do more work before calling the same functions, how
>>>> can they be faster?
>>>
>>> I admit my arguments are a bit sloppy, one could go more into depth.
>>>
>>> But true is that mysqli is strongly recommended for MySQL versions 4.1.3 or later,
>>> see http://ca3.php.net/manual/en/mysqli.overview.php
>>>
>>> And I can't understand why the mysql interface is still advocated by some. Look at
>>> the old mysql password format, ridiculous.
>>>
>>> /Str.
>>>
>>
>> The mysql interface has nothing to do with the old mysql password format. Two
>> entirely different things.
>
> I still remember something I had to debug in 2006, see
> http://dev.mysql.com/doc/refman/5.1/en/password-hashing.html at
> "what you should do if you upgrade your server but need to maintain backward
> compatibility with pre-4.1 clients"
>
> I won't write an article on this now.
>
> /Str.
Which was only a problem if you used pre-4.1 clients on 4.1 or later
servers and did not use the --old_passwords option.
It had absolutely nothing to do with the mysql_xxx functions.
But if you were trying to do this with mysqli_xxx, those function calls
would fail with the same error.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
|
|
|