FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » Imported messages » comp.lang.php » Prep. Statements only in mysql-i?
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Prep. Statements only in mysql-i? [message #177675 is a reply to message #177673] Thu, 12 April 2012 20:34 Go to previous messageGo to previous message
Jerry Stuckle is currently offline  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
==================
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Clean PDO-MySQL Statement
Next Topic: Getting date URLs and prev/next links working in Codeigniter
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 07 19:25:26 GMT 2024

Total time taken to generate the page: 0.04666 seconds