Friday 27 July 2018

MySQL vs MySQLi when using PHP




Which is better, MySQL or MySQLi? And why? Which should I use?




I mean better not just in terms of performance, but any other relevant feature.


Answer



If you have a look at MySQL Improved Extension Overview, it should tell you everything you need to know about the differences between the two.



The main useful features are:




  • an Object-oriented interface

  • support for prepared statements


  • support for multiple statements

  • support for transactions

  • enhanced debugging capabilities

  • embedded server support.


No comments:

Post a Comment

php - file_get_contents shows unexpected output while reading a file

I want to output an inline jpg image as a base64 encoded string, however when I do this : $contents = file_get_contents($filename); print &q...