Jump to content

What is the Difference Between MYSQLi and MYSQL Extenstion


binumathew

Recommended Posts

MySQLi is the OOP version of MySQL extension. In the end, the accomplish the same thing: extension for interacting with MySQL from PHP. A lot of people still use the original MySQL extension vs the new MySQLi extension because MySQLi requires MySQL 4.1.13+ and PHP 5.0.7+

Link to comment
Share on other sites

In the end, the accomplish the same thing: extension for interacting with MySQL from PHP.

 

That's not entirely accurate. MySQLi supports some things that the old MySQL extension doesn't. Things like prepared statements, multiple statements, and transactions on top of my head.

Link to comment
Share on other sites

Also MySQL native driver (as of PHP 5.3 so not yet) that's said to be much faster than the library used now, proper encoding support, and working persistent connections (again as of PHP 5.3)

 

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.