MySQL extension added in PHP version 2.0 and deprecated as of PHP5.5.0.MySQLi extension added in PHP 5.5 and will work on MySQL 4.1.3 or above.
Does not support prepared statements.MySQLi supports prepared statements.
MySQL provides the procedural interface.MySQLi provides both procedural and object-oriented interface.
MySQL extension doesn't support stored procedure.MySQLi supports store procedure.
MySQL extension lags in security and other special features comparatively.MySQLi extension is with enhanced security and improved debugging.
Transactions are handled by SQL queries only.MySQLi supports transactions through API.
Extension directory: ext/mysql.Extension directory: ext/mysqli.

Anuj Kumar

This is Anuj Kumar. I’m a professional web developer with 4+ year experience. I write blogs in my free time. I love to learn new technologies and share with others.
I founded PHPGurukul in September 2015. The main aim of this website to provide PHP, Jquery, MySQL, PHP Oops and other web development tutorials.

Recommended Tutorials for you

Add comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Follow us

Don't be shy, get in touch. We love meeting interesting people and making new friends.