When should I use MySQLi instead of MySQL?

by

Reasons why you should use MySQLi extension instead of the MySQL extension are many:

  1. MySQLi gives you prepared statements – a safer way of sending data to MySQL and protecting you from SQL injection. This alone should be enough for always choosing MySQLi over MySQL.
  2. MySQLi enables most of the MySQL features.
  3. MySQLi is object orientated.
  4. MySQLi supports prepared statements, transactions and multiple statements.
  5. The old MySQL extension is deprecated as of PHP 5.5.0

And there are other benefits. But mainly, you should focus on security and stabiltity – and MySQLi gives you just that.

More Related Contents:

  1. Save the data into a database and return another value from database using PHP
  2. inserting information and image in php and mysql
  3. Can I mix MySQL APIs in PHP?
  4. mysqli or die, does it have to die?
  5. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  6. How to change mysql to mysqli?
  7. MySQL vs MySQLi when using PHP [closed]
  8. Best way to INSERT many values in mysqli?
  9. MySQLi prepared statements error reporting [duplicate]
  10. Why is mysqli giving a “Commands out of sync” error?
  11. mysqli: can it prepare multiple queries in one statement?
  12. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  13. How to call a MySQL stored procedure from within PHP code?
  14. MySQLi count(*) always returns 1
  15. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  16. Using Mysqli bind_param with date and time columns?
  17. Using MySQLi from another class in PHP
  18. How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]
  19. PHP PDO and MySQLi [duplicate]
  20. PHP + MySql + Stored Procedures, how do I get access an “out” value?
  21. Can I blindly replace all mysql_ functions with mysqli_?
  22. php password_verify() hash and pass won’t match
  23. Get number of rows matched by UPDATE query with PHP mysqli
  24. How to use mysqli_query() in PHP?
  25. PHP to MySQL SSL Connections
  26. Which is fastest in PHP- MySQL or MySQLi?
  27. mysqli persistent connection
  28. Create mysql trigger via PHP?
  29. How to get a list of databases?
  30. How to make mysqli connect function?

Leave a Comment