MySQL or MySQLi

[deFiant]

I use MYSQL too.

[ScopeHosts.Sales]

hi,

MySQLi is still new and vulnerable . Its better to say on the mySQL . Till the mySQLi gets improved with security point of view.

[JmZ]

MySQL Lib is old, it shouldn't be chosen over MySQLi in any circumstances really.

MySQL Lib = old & lacks new functionality
MySQLi = new & restricted to MySQL
PDO = new & works on almost any DB

So you should generally use PDO over anything for portability.

Though half of you probably don't even know PDO exists.

I never use the mysql or mysqli libraries in my code now, it'd be an illogical decision to do so when you can have complete portability with PDO. You can code your script to use PDO so if you ever switch DB, you only change the connection, not the queries.

[taxidiver]

MySQL. Thanks for the details.

[Golden Falcon]

I use whatever default the software itself recommends, this way your sure to have the best experience

[duality99]

i use mysql but mysqli is faster.