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:
- Embedded server support
- Object-oriented interface
- Support for Prepared Statements
- Support for Multiple Statements
- Support for Transactions
- Enhanced debugging capabilities
You have the choice of using mysql or mysqli.
Reference: http://www.php.net/manual/en/mysqli.overview.php
Tags: database, DBMS, MySQL, mysqli
Related posts:
- Online Schema Change for mySQL It is great to be able to build small utilities...
- MySQL – How to create a database diagram basing on the image available Often we make some sketches of the database we plan...
- SQL Injection: How To Prevent Security Flaws In PHP / MySQL What is SQL Injection Most new web developers have heard...
- SQL Server : Take offline database EXEC sp_dboption N’mydb’, N’offline’, N’true’ OR ALTER DATABASE [mydb] SET OFFLINE WITH ROLLBACK AFTER 30 SECONDS OR ALTER DATABASE [mydb] SET OFFLINE WITH...
- Worm or Virus – What is the Difference? Everyone has been infected with a virus at one time...
Reader Feedback
One Response to “What is the difference between mysql and mysqli?”