MySQL vs MySQLi when using PHP [closed]

by

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.

More Related Contents:

  1. Can I mix MySQL APIs in PHP?
  2. How to change mysql to mysqli?
  3. How to prevent duplicate usernames when people register?
  4. mysqli_stmt::bind_result(): Number of bind variables doesn’t match number of fields in prepared statement
  5. SELECT COUNT(*) AS count – How to use this count
  6. How to use mysqli prepared statements?
  7. mysqli::mysqli(): (HY000/2002): Can’t connect to local MySQL server through socket ‘MySQL’ (2)
  8. mysqli last insert id
  9. mysqli: can it prepare multiple queries in one statement?
  10. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  11. How to call a MySQL stored procedure from within PHP code?
  12. What is the difference between MySQL, MySQLi and PDO? [closed]
  13. Do I have to guard against SQL injection if I used a dropdown?
  14. Using MySQLi from another class in PHP
  15. How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]
  16. Call to a member function execute() on boolean in [duplicate]
  17. Mysql No connection could be made because the target machine actively refused it
  18. How to connect to MySQL database in PHP using mysqli extension?
  19. Unknown database error in PHP but it exists in PHPMyAdmin
  20. Can I blindly replace all mysql_ functions with mysqli_?
  21. Fatal error: Call to undefined function mysqli_result()
  22. Using PHP to execute multiple MYSQL Queries
  23. Fatal error: Call to undefined method mysqli_stmt::fetch_array() [duplicate]
  24. How to run multiple insert query in SQL using PHP in one go?
  25. mysqli prepared statement num_rows returns 0 while query returns greater than 0 [duplicate]
  26. Using Prepared Statement, how I return the id of the inserted row?
  27. Which is fastest in PHP- MySQL or MySQLi?
  28. When should I close a database connection in PHP?
  29. MySqli Commands out of sync; you can’t run this command now [duplicate]
  30. How to make mysqli connect function?

Leave a Comment