what is the difference between mysql and mysqli?
Posted on 14 April 2010 by Abidoon
I tried searching but all they say is which is faster and that sort of things. What’s the difference?
Tags | between, difference, MySQL, mysqli
- Yellow Dog Linux 6.1- PS3: how to download, burn and install part2
- Exploring MythTV and mediaMVP
- PHP Tutorials: Create a Search Engine (Part 1)
- Fedora 11 Installation
- PHP Tutorial: Installation and The Basics
- Brian Boatright: Please tell me there will be a version of 2.0 t...
- Stewart Smith: While we’re not planning it for our 2.0.0...
- Brian Boatright: I only have one MySQL server and have been cons...
- Drizzle Day 2012 | Ramblings: [...] Day 2012 Henrik has already posted it ov...
- Dave Juntgen: Baron – This “feature” has be...
Categories
Archives
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- October 2008
- September 2008
- March 2006
http://en.wikipedia.org/wiki/MySQLi
It’s a [better] way to interact with a MySQL database. Apples and oranges, see?
Just Wiki’d it, the meaning is down-to-earth simple: improvement in middleware, the backend side, for PHP anyway.
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