In this article, we will focus on the mysqli_info() function in PHP, which is used to return information about the most recently executed query. We will provide you with an overview of the function, how it works, and examples of its use.

Introduction to the mysqli_info() function

The mysqli_info() function is a built-in function in PHP that is used to return information about the most recently executed query. This function is useful when you need to know specific details about the query, such as the number of affected rows.

How to use the mysqli_info() function

Using the mysqli_info() function is very simple. You just need to call the function on a valid MySQLi connection. Here is an example:

$mysqli = mysqli_connect("localhost", "username", "password", "database");

mysqli_query($mysqli, "INSERT INTO table_name (column1, column2, column3) VALUES ('value1', 'value2', 'value3')");

$info = mysqli_info($mysqli);

echo "Query information: " . $info;


In this example, we call the mysqli_connect() function to connect to a MySQL database with a username and password. We then execute an INSERT query using the mysqli_query() function. We then call the mysqli_info() function on the MySQLi connection to get the query information for the connection. We then output the query information using the echo statement.


In conclusion, the mysqli_info() function is a useful tool for returning information about the most recently executed query. By understanding how to use the function, you can take advantage of this feature to create powerful and flexible MySQLi queries.

Practice Your Knowledge

Which of the following statements about PHP are correct according to the information provided on the webpage?

Quiz Time: Test Your Skills!

Ready to challenge what you've learned? Dive into our interactive quizzes for a deeper understanding and a fun way to reinforce your knowledge.

Do you find this helpful?