mysqli_fetch_array($result,$result_type);$result is the resultset returned by mysqli_query() or mysqli_store_result() or mysqli_use_result()
MySQLI database connection file
Example : Object Oriented Style<?Php require "config.php";// Database connection file. $q="SELECT * FROM student WHERE id=3"; // Generate resultset $result_set = $connection->query($q); $row=$result_set->fetch_array(MYSQLI_NUM); echo $row[0],$row[1],$row[2],$row[3]; $result->free; ?>To get associative array
<?Php require "config.php";// Database connection file. $q="SELECT * FROM student WHERE id=3"; // Generate resultset $result_set = $connection->query($q); $row=$result_set->fetch_array(MYSQLI_ASSOC); echo $row['id'],$row['name'],$row['class'],$row['mark']; $result_set->free; ?>To get Both ( column name and index )
<?Php require "config.php";// Database connection file. $q="SELECT * FROM student WHERE id=3"; // Generate resultset $result_set = $connection->query($q); $row=$result_set->fetch_array(MYSQLI_BOTH); echo $row['id'],$row[1],$row['class'],$row[3]; $result_set->free; ?>Procedural style
<?Php require "config.php";// Database connection file. // Generate resultset $q="SELECT * FROM student WHERE id=3"; $result_set = mysqli_query($connection,$q); $row = mysqli_fetch_array($result_set, MYSQLI_NUM); echo $row[0],$row[1],$row[2],$row[3]; ?>We used index numbers to get the field data, now we will use field name to collect data
<?Php require "config.php";// Database connection file. $q="SELECT * FROM student WHERE id=3"; // Generate resultset $result_set = mysqli_query($connection,$q"); $row = mysqli_fetch_array($result_set, MYSQLI_ASSOC); echo $row['id'],$row['name'],$row['class'],$row['mark']; ?>Using Both
<?Php require "config.php";// Database connection file. $q="SELECT * FROM student WHERE id=3"; // Generate resultset $result_set = mysqli_query($connection,$q"); $row = mysqli_fetch_array($result_set, MYSQLI_BOTH); echo $row[0],$row['name'],$row[1],$row['mark']; ?>
<?Php require "config.php";// Database connection file. // Generate resultset $result_set = mysqli_query($connection,"SELECT * FROM student "); while($row = mysqli_fetch_array($result_set,MYSQLI_NUM)){ echo $row[0],$row[1],$row[2],$row[3]."<br>"; } ?>Using object oriented style
<?Php require "config.php";// Database connection file. // Generate resultset $result_set = $connection->query("SELECT * FROM student "); while($row = $result_set->fetch_array(MYSQLI_ASSOC)){ echo $row['id'],$row['name'],$row['class'],$row['mark']."<br>"; } ?>
$data=array("id"=>$row['id'],"name"=>$row['name']);
Note that each student record is an array and it is added to our main array my_array. While adding to an array we can add one more element ( as percentage here ) for each record.
<?Php
require "config.php";// Database connection file.
$result_set = $connection->query("SELECT * FROM student ");// Generate resultset
$my_array=array();
while($row = $result_set->fetch_array(MYSQLI_ASSOC)){
$percentage=($row['mark']/200)*100; // new element to be stored in our array
$my_array[]=array("id"=>$row['id'],"name"=>$row['name'],"class"=>$row['class'],"mark"=>$row['mark'],"percentage"=>$percentage);
}
$max=sizeof($my_array);
for($i=0; $i<$max; $i++) {
// displaying all the elements
while (list ($key, $val) = each ($my_array[$i])) {
echo "$key -> $val <br>";
} // inner array while loop
} // outer array for loop
?>
echo $my_array[5]['name']; // displaying single record
MYSQLI Functionsmysql_query() : Apply query to database