mysql vs mysqli vs pdo (php) Q

[E.S. Rosenberg]

Personally I like PDO a lot.
mysql_ should definitely be avoided, but as far as I always understood
mysqli_ is the alternative to PDO for those people who don't like
Object oriented stuff...
PDO is afaik an official part of php and the "recommended" way to
interact with a db so I have a hard time believing that they'd be
breaking that anytime soon.... (considering lots of projects are now
based in PDO or working on making the switch, also even if they do
decide to replace PDO since it's just a class the only thing needed to
replace it is a class that exposes the same set of
interfaces/functions).

 HTH,
Eliyahu - אליהו

2012/12/2 Lior Kaplan <kaplanlior at gmail.com>:
> Hi Erez,
>
> From PHP 5.4 the default for all the mysql extensions family is mysqlnd (PHP
> native mysql driver), and it seems that for the next PHP release (5.5)
> ext/mysql will be deprecated https://wiki.php.net/rfc/mysql_deprecation
>
> So PDO is probably the right answer.
>
> Kaplan
>
>
> On Sun, Dec 2, 2012 at 11:22 AM, Erez D <erez0001 at gmail.com> wrote:
>>
>> Hello,
>>
>> We are starting a new project, one that will be used for production and
>> should be supported for years.
>>
>> We need to access mysql via php
>> currently i seem to preffer PDO as it supports not only mysql but many
>> other DBs.
>>
>> searching the net, i see many comparisons of mysql vs mysqli vs pdo.
>> they compare functionality
>>
>> however, i am trying to asses, which api will be still up to date in 5
>> years, and which will not
>>
>> anyone ?
>>
>>
>> thanks,
>> erez.
>>
>> _______________________________________________
>> Linux-il mailing list
>> Linux-il at cs.huji.ac.il
>> http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
>>
>
>
> _______________________________________________
> Linux-il mailing list
> Linux-il at cs.huji.ac.il
> http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
>