Re: PDO vs. mysqli

On 02.09.2016 at 15:09, Jacob Kruger wrote: > Up to now have just been working with mysqli, using prepared statements, > passing parameters, etc., but, was looking into PDO now, and seems to, > among other things offer a more dynamic form of parameter passing, etc. > > Either way, was just wondering if there's are any specific reasons > should stick to just working with mysqli directly, or if should switch > over to making use of PDO more often/most of the time? The main advantage of PDO over MySQLi appears to be that it's much easier to support another RDBMS, if the need arises. > AFAIK, most servers should, nowadays handle/support PDO in any case - am > working with XAMPP here on my dev machine, which is windows 10 64 bit, > but anyway. You're probably referring to shared hosting services. I assume that almost all support PDO, and most of them PDO_MYSQL (and supposedly, all that offer MySQLi also support PDO_MYSQL). -- Christoph M. Becker