CodeIgniter Laravel PHP Example Javascript jQuery MORE Videos New

Difference between result() and row() in codeigniter


result() To fetch multiple records from the database table we need to use result().

row()To fetch a single record from the database table we need to use row().

Example:

result():

$query = $this->db->query("YOUR QUERY"); 

$data=$query->result();

foreach ($data as $row) { 

echo $row['title']; 

echo $row['name']; 

echo $row['body']; 

}

row()

result():

$query = $this->db->query("YOUR QUERY"); 

if ($query->num_rows() > 0) { 

$row = $query->row_array();


echo $row['title']; 

echo $row['name']; 

echo $row['body'];


Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /www/wwwroot/studentstutorial.com/includes/get_article.php on line 13