In this article, we will focus on the mysqli_fetch_row() function in PHP, which is used to fetch the next row of a MySQLi result set as an enumerated array. We will provide you with an overview of the function, how it works, and examples of its use.

Introduction to the mysqli_fetch_row() function

The mysqli_fetch_row() function is a built-in function in PHP that is used to fetch the next row of a MySQLi result set as an enumerated array. This function is useful when you need to access the columns of a row in a result set by their numerical index.

How to use the mysqli_fetch_row() function

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

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

$query = "SELECT * FROM my_table";
$result = mysqli_query($mysqli, $query);

if ($result) {
    while ($row = mysqli_fetch_row($result)) {
        printf("%s (%s)\n", $row[0], $row[1]);
    }
}

mysqli_close($mysqli);
?>

In this example, we call the mysqli_connect() function to connect to a MySQL database with a username and password. We then execute a query using the mysqli_query() function to select all columns from a table. We store the result in a variable and check if there was a result using the $result variable. If there was a result, we use a while loop to iterate over each row in the result set. For each row, we call the mysqli_fetch_row() function to fetch the row as an enumerated array. We then access the columns of the row using their numerical index and output them.

Conclusion

In conclusion, the mysqli_fetch_row() function is a useful tool for fetching the next row of a MySQLi result set as an enumerated array. 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 are true about the PHP function mysqli_fetch_row()?

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?