TeddyKiller Posted May 5, 2010 Share Posted May 5, 2010 This may seem a daft question.. but what is the difference between MySQL and MySQLI. I've seen both used, but only familiar with MySQL... What are the pros and cons for them both too. Thanks. Quote Link to comment Share on other sites More sharing options...
fenway Posted May 5, 2010 Share Posted May 5, 2010 And I assume the refman wasn't helpful? Quote Link to comment Share on other sites More sharing options...
TeddyKiller Posted May 5, 2010 Author Share Posted May 5, 2010 I've never used Refman.. o.O I just want to know the pros and cons... this also gives a chance for other users to say what they think too? Quote Link to comment Share on other sites More sharing options...
Mchl Posted May 5, 2010 Share Posted May 5, 2010 mysqli as of php 5.3 uses native driver which is said to have better performance. Never seen actual benchmark though. mysqli can be used in object oriented way, which is pretty useful mysqli supports prepared statements, though in a pretty primitive way mysqli has support for features like transactions (mysqli_autocommit) or connection encoding. In general I find it more convienient to use mysqli over mysql [added] Oh, and never again confess to never had benn using reference manual... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.