JIYIK CN >

MySQLi fetch function is used to access data from the database server. After fetching the data, you can also iterate over it MySQLiwith queries.

In this article, we will see mysqli_fetch_array()the use of functions and methods to iterate over data.

This extension was introduced in PHP version 5.0.0 and is designed to work with MySQL 4.1.13 or higher. We use PHP version 7.4.1 and phpMyAdmin in this tutorial.

You can download XAMPP from its official website. (If you have XAMPP, you don't have to install MySQL and PHP separately).

Iteration mysqli_fetch_array()Function

mysqli_fetch_array()It is used to $resultretrieve the data of the current row from the database using as the first parameter, saving the output as an associative array, a numeric array, or both (depending on the second parameter). Now, we have the following data in our student database.

mysqli_fetch_array()Function usage MYSQLI_NUMmode

Let us write the following program to read data from the student database mysqli_fetch_array()named using function db_students. The following code will connect to the database and display a failure message in case of failure.

After successfully connecting to the database, it will mysqli_queryread the records using the function and save them $resultinto the variable. mysqli_fetch_array()This resulting variable will be used and MYSQLI_NUM(it behaves like the mysqli_fetch_row() function) as an argument to display the current row as an array of numbers with indices ranging from 0to n-1.

Sample code:

<?php
	$host = "localhost";
    $username = "root";
    $password = "";
	$database = "db_students";
	$connection = mysqli_connect($host, $username, $password, $database); 
   
    if (mysqli_connect_errno()) {
        echo "Database connection failed."; 
    }

    $sql = "SELECT * FROM tb_students";
	$result = mysqli_query($connection, $sql);
    $row = mysqli_fetch_array($result,MYSQLI_NUM);
    print_r($row)
?>

Output:

mysqli_fetch_array()Function usage MYSQLI_ASSOCmode

Here, due to the parameters MYSQLI_ASSOC, mysqli_fetch_array()the function behaves similar to mysqli_fetch_assoc()and the column names of the table will be displayed as indices of the array. Practice the following code and observe the output.

Sample code:

<?php
	
    $host = "localhost";
    $username = "root";
    $password = "";
	$database = "db_students";
	$connection = mysqli_connect($host, $username, $password, $database); 
   
    if (mysqli_connect_errno()) {
        echo "Database connection failed."; 
    }

    $sql = "SELECT * FROM tb_students";
	$result = mysqli_query($connection, $sql);
    $row = mysqli_fetch_array($result,MYSQLI_ASSOC);
    print_r($row)
?>

Output:

mysqli_fetch_array()Function usage MYSQLI_BOTHmode

Using the function with parameter MYSQLI_BOTHwill mysqli_fetch_array()store the data into an array which we can access using column name and column index. Practice the following code and see the output.

Sample code:

<?php
    $host = "localhost";
    $username = "root";
    $password = "";
    $database = "db_students";
    $connection = mysqli_connect($host, $username, $password, $database); 

    if (mysqli_connect_errno()) {
        echo "Database connection failed."; 
    }

    $sql = "SELECT * FROM tb_students";
    $result = mysqli_query($connection, $sql);
    $row = mysqli_fetch_array($result,MYSQLI_BOTH);
    print_r($row)
?>

Output:

Loop mysqli_fetch_array()Function

We will use the following code to iterate mysqli_queryand compare the output with the student table records.

Remember that you can loop over all patterns of mysqli_fetch_array(), MYSQLI_ASSOC, , MYSQLI_NUMand . When using , you must pass it as a parameter.MYSQLI_BOTHmysqli_fetch_array()

<?php
    $host = "localhost";
    $username = "root";
    $password = "";
	$database = "db_students";
	$connection = mysqli_connect($host, $username, $password, $database); 
   
    if (mysqli_connect_errno()) {
        echo "Database connection failed."; 
    }

    $sql = "SELECT * FROM tb_students";
	$result = mysqli_query($connection, $sql);
        
    $std_num=0;
    while($row = mysqli_fetch_array($result,MYSQLI_ASSOC)) {
        echo "Student Number ".$std_num."<br>";
        echo "ID: ".$row['ID']."<br>";
        echo "First Name: ".$row['FIRST_NAME']."<br>";
        echo "Last Name: ".$row['LAST_NAME']."<br>";
        echo "Age: ".$row['AGE']."<br>";
        echo "<br><br>";
    	$std_num++;
    }
?>

Output:

You can view ID, FIRST_NAME, LAST_NAME, and compare AGEthem to the following table named .tb_students

in conclusion

The above discussion concludes that mysqli_fetch_array()functions help us to retrieve data from the database.

Depending on our needs and requirements, we can use its output mode, whether to access values ​​by column index or column name, or both. We can then loop through the results to view each record of the table.