Can I blindly replace all mysql_ functions with mysqli_?

by

The short answer is no, the functions are not equivalent.

The good news is there is a converter tool that will help you if you’ve got a lot of calls/projects to change. This will allow your scripts to work right away.

https://github.com/philip/MySQLConverterTool

It’s a forked version of the Oracle original version, and it’s kosher.

That said, it’s not too difficult to update your code, and you might want to migrate to an object orientated methodology anyway …

1) The Connection

For all intents and purposes, you need a new connection function that saves the connection as a PHP variable, for example;

$mysqli = new mysqli($host, $username, $password, $database);

Notice I’ve saved the connection to $mysqli. You can save to $db or whatever you like, but you should use this throughout your code to reference the connection.

Remember to enable error reporting for mysqli before opening the connection;

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

2) The Query

Note: You should protect against SQL injection with prepared statements, which are available in MySQLi. Take a look at How can I prevent SQL injection in PHP?, but I’m just going to cover the basics here.

You now have to include the connection as an argument in your query, and other mysqli_ functions. In procedural code it’s the first argument, in OO you write it like a class method.

Procedural:

$result = mysqli_query($mysqli, $sql);

OO:

$result = $mysqli->query($sql);

3) Fetch Result

The fetching of the result is similar to the old mysql_ function in procedural;

while ($row = mysqli_fetch_assoc($result))

but as $result is now an object in mysqli, you can use the object function call;

while ($row = $result->fetch_assoc())

4) Close Connection

So as before, you need to include the connection in the close function; as an argument in procedural;

mysqli_close($mysqli);

and as the object that you run the function on in OO;

$mysqli->close();

I would be here forever if I went through them all, but you get the idea. Take a look at the documentation for more information. Don’t forget to convert any connection close, result release, or error and row counting functions you have.

The basic rule of thumb is for functions that use the database connection, you need to include it in the function now (either as the first argument in procedural, or the object you use to call the function in OO), or for a result set you can just change the function to mysqli_ or use the result set as the object.

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. MySQL vs MySQLi when using PHP [closed]
  7. How to get count of rows in MySQL table using PHP?
  8. MySQLi prepared statements error reporting [duplicate]
  9. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  10. Why is mysqli giving a “Commands out of sync” error?
  11. MySQLi count(*) always returns 1
  12. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  13. How can I enable the MySQLi extension in PHP 7?
  14. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  15. Using Mysqli bind_param with date and time columns?
  16. Advantages Of MySQLi over MySQL [closed]
  17. check if the query results empty row mysqli [duplicate]
  18. PHP PDO and MySQLi [duplicate]
  19. Is mysql_real_escape_string() necessary when using prepared statements?
  20. Updating from MYSQL to MYSQLI [duplicate]
  21. PHP + MySql + Stored Procedures, how do I get access an “out” value?
  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. mysqli prepared statement num_rows returns 0 while query returns greater than 0 [duplicate]
  27. Using Prepared Statement, how I return the id of the inserted row?
  28. Which is fastest in PHP- MySQL or MySQLi?
  29. When should I close a database connection in PHP?
  30. MySqli Commands out of sync; you can’t run this command now [duplicate]

Leave a Comment