PHP Basic Tutorial

PHP Advanced Tutorial

PHP & MySQL

PHP Reference Manual

PHP CURL Functions PHP OpenSSL Functions

PHP mysqli_fetch_row() Function Usage and Example

The mysqli_fetch_row() function retrieves the result rows in the form of an enumerated array.

Definition and Usage

A PHP result object (mysqli_result class) represents the MySQL result returned by a SELECT or DESCRIBE or EXPLAIN query.

mysqli_fetch_row()The function accepts a result object as a parameter and retrieves its current row content in the form of a string array.

Syntax

mysqli_fetch_row($result);

Parameter

Serial Number	Parameters and Description
1	result (required) This is the identifier for the result object.

Return Value

The PHP mysqli_fetch_row() function returns an array (string) that contains the values of the current row pointed to by the data search.

PHP Version

This function was originally introduced in PHP version5introduced and can be used in all higher versions.

Online example

The following example demonstratesmysqli_fetch_row()Usage of the function (procedural style), fetching rows from the result set:

Example

<?php
　　　$con = mysqli_connect("localhost", "root", "password", "mydb");
　　　mysqli_query($con, "CREATE TABLE myplayers(ID INT, First_Name VARCHAR(255), Last_Name VARCHAR(255), Place_Of_Birth VARCHAR(255), Country VARCHAR(255))");
　　　print("Create table.....\n");
　　　mysqli_query($con, "INSERT INTO myplayers values(1, 'Sikhar', 'Dhawan', 'Delhi', 'India')");
　　　mysqli_query($con, "INSERT INTO myplayers values(2, 'Jonathan', 'Trott', 'CapeTown', 'SouthAfrica')");
　　　mysqli_query($con, "INSERT INTO myplayers values(3, 'Kumara', 'Sangakkara', 'Matale', 'Srilanka')");
　　　print("Insert record.....\n");
　　　//Retrieve the content of the table
　　　$res = mysqli_query($con, "SELECT　*　FROM myplayers);
　　　while ($row = mysqli_fetch_row($res)) {
　　　　　　print("ID:　".$row[0]."\n");
　　　　　　print("First_Name:　".$row[1]."\n");
　　　　　　print("Last_Name:　".$row[2]."\n");
　　　　　　print("Place_Of_Birth:　".$row[3]."\n");
　　　　　　print("Country:　".$row[4]."\n");
　　　}
　　　//End statement
　　　mysqli_free_result($res);
　　　//Close connection
　　　mysqli_close($con);
?>

Output result

Create table.....
Insert record.....
ID:　1
First_Name:　Sikhar
Last_Name:　Dhawan
Place_Of_Birth:　Delhi
Country:　India
ID:　2
First_Name:　Jonathan
Last_Name:　Trott
Place_Of_Birth:　CapeTown
Country:　SouthAfrica
ID:　3
First_Name:  Kumara
Last_Name:  Sangakkara
Place_Of_Birth:  Matale
Country:  Srilanka

Online example

In the object-oriented style, the syntax of this function is$result-> fetch_row();.The following is an example of this function in an object-oriented style;

Example

<?php
　　　//Establish connection
　　　$con = new mysqli("localhost", "root", "password", "mydb");
　　　$con　->  query("CREATE TABLE Test(Name VARCHAR(255),  AGE INT)");
　　　$con　->  query("insert into Test values('Raju',　25),('Rahman',　30),('Sarmista',　27)");
　　　$con　->  query("insert into Test values('Mohan',　28),('Raghav',　35),('Devika',　30)");
　　　print("Create table.....\n");
　　　$stmt = $con　->  prepare("SELECT　*　FROM Test WHERE Name in(?, ?, ?, ?)");
　　　$stmt　->  bind_param("ssss",  $name1,  $name2,  $name3,  $name4);
　　　$name1　= 'Raju';
　　　$name2　= 'Rahman';
　　　$name3　= 'Raghav';
　　　$name4　= 'Devika';
　　　//Execute statement
　　　$stmt->execute();
　　　//Search results
　　　$res = $stmt->get_result();
　　　//Get all rows content
　　　while ($row = $res->fetch_row()) {
　　　　　　print("Name:  ".$row[0]."\n");
　　　　　　print("Age:  ".$row[1]."\n");
　　　　　　print("\n");
　　　}
　　　//End statement
　　　$stmt->close();
　　　//Close connection
　　　$con->close();
?>

Output result

Create table.....
Name:  Raju
Age:　25
Name:  Rahman
Age:　30
Name:  Raghav
Age:　35
Name:  Devika
Age:　30

PHP MySQLi Reference Manual

PHP CURL Functions PHP OpenSSL Functions