MySQL and MySQli are APIs to connect a MySQL database server in PHP. Each has it’s advantages and disadvantages.
Note: By now MySQL extension is deprecated and it is not safe to use in future applications. It will be there for sometime for backward compatibility.
MySQL
Original extension designed to allow you to interact PHP applications to MySQL database. The MySQL extension provides a procedural interface, and it should use with only MySQL version older than 4.1.3. This can be used, but not all MySQL features will not be available.
MySQLi
The MySQLi, as the name suggests, it is MySQL improved version, was a next generation version of MySQL to take advantages of new MySQL server versions. This extension is packaged with PHP versions 5 and later.
The main features
- Object-oriented interface also provides a procedural interface.
- Support for Prepared Statements
- Support for Multiple Statements
- Support for Transactions
- Enhanced debugging capabilities
- Embedded server support
Did this post help you?
Tutsplanet brings in-depth and easy tutorials to understand even for beginners. This takes a considerable amount of work. If this post helps you, please consider supporting us as a token of appreciation:
- Just want to thank us? Buy us a Coffee
- May be another day? Shop on Amazon using our links.
Your prices won't change but we get a small commission.
Leave a Reply