Show records using mysqli_fetch_array( ) function

mysqli_fetch_array() return the rows from the number of records available in the database as an associative array or numeric array. At a time it returns only the first row as an associative array or numeric array. if we want to retrieve all the records of the table then we must put this function inside the while loop.

Syntax:

mysqli_fetch_array(query)

PHP MySQLi Select Query using mysqli_fetch_array( ) With Output Example

<?php  
	$host = "localhost";  
	$user = "";  
	$pass = "";  
	$dbname = "users";
	$conn = mysqli_connect($host,$user,$pass,$dbname) or die(mysqli_error($conn)); 
	$sql = "SELECT * FROM users";  
	$result=mysqli_query($conn,$sql);
	print_r(mysqli_fetch_array($result));
	mysqli_close();  
?> 

Output:

Array(
	[0] =>1 
	[id] => 1
	[1] => rakesh
	[name] => rakesh
	[2] => 20000
	[salary] =>20000
) 

Show all records from users table using mysqli_fetch_array( ) function:

<?php  
	$host = "localhost";  
	$user = "";  
	$pass = "";  
	$dbname = "users";  
	  
	$conn = mysqli_connect($host,$user,$pass,$dbname) or die(mysqli_error($conn));  
	$sql = "SELECT * FROM users";  
	$retval=mysqli_query($conn,$sql);  
	  
	if(mysqli_num_rows($retval) > 0){  
		echo "<table border='1'>";
		echo "<tr><th>ID</th><th>Name</th><th>Salary</th></tr>";
		while($row= mysqli_fetch_array($retval))
		{
			echo "<tr>";	
			echo "<td>".$row['id']."</td>";
			echo "<td>".$row['name']."</td>";
			echo "<td>".$row['salary']."</td>";
			echo "</tr>";
		}		
		echo "</table>";
	}else{  
		echo "0 results";  
	}  
	mysqli_close($conn);  
?> 

Output:

Result In Table: Users