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. Link to comment https://forums.phpfreaks.com/topic/200744-mysql-mysqli/ 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? Link to comment https://forums.phpfreaks.com/topic/200744-mysql-mysqli/#findComment-1053378 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? Link to comment https://forums.phpfreaks.com/topic/200744-mysql-mysqli/#findComment-1053491 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... Link to comment https://forums.phpfreaks.com/topic/200744-mysql-mysqli/#findComment-1053500 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.