Friday, 3 August 2012

What is the difference between mysql and mysqli?


In relation to PHP programming language, MySQL is the old database driver, and MySQLi is the Improved driver. MySQLi takes advantage of the newer features of MySQL 5. Lifted verbatim from the php.net site:

- Object-oriented interface
- Support for Prepared Statements
- Support for Multiple Statements
- Support for Transactions
- Enhanced debugging capabilities
- Embedded server support

You have the choice of using mysql, mysqli, or PDO essentially.

If you're simply looking for a relational database, you need look no further than MySQL, though there are many options available. You can use DBD, Postgres, MySQL, MSSQL, sqlite, etc etc etc...

HTH

Source(s):

No comments:

Post a Comment

AI Credential Theft and LLMjacking: How UK SMEs Can Protect Their AI Accounts in 2026

Published by GLCTech Sec , the UK monitoring, endpoint security and backup partner for regulated SMEs. AI credential theft is one of th...