Query Results¶

class CI_DB_result¶

CI_DB_result::result([$type = 'object'])¶

This function returns the query result as an array of objects, or an empty array on failure. Typically you’ll use this in a foreach loop, like this:

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

foreach ($query->result() as $row)
{
        echo $row->title;
        echo $row->name;
        echo $row->body;
}

If you run queries that might not produce a result, you are encouraged to test the result first:

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

if ($query->num_rows() > 0)
{
        foreach ($query->result() as $row)
        {
                echo $row->title;
                echo $row->name;
                echo $row->body;
        }
}

You can also pass a string to result() which represents a class to instantiate for each result object (note: this class must be loaded):

$query = $this->db->query("SELECT * FROM users;");

foreach ($query->result('User') as $user)
{
   echo $user->name; // call attributes
   echo $user->reverse_name(); // or methods defined on the 'User' class
}

Parameters:	$type (string) – The type of result to pull, either 'object' or 'array'
Returns:	An array of Objects representing database rows or a multidimensional array of database rows
Return type:	array of Objects/multidimensional array

CI_DB_result::result_array()¶

This function returns the query result as a pure array, or an empty array when no result is produced. Typically you’ll use this in a foreach loop, like this:

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

foreach ($query->result_array() as $row)
{
        echo $row['title'];
        echo $row['name'];
        echo $row['body'];
}

Returns:	An multidimensional array of database rows
Return type:	multidimensional array

CI_DB_result::row([$n = 0[, $type = 'object']])¶

This function returns a single result row. If your query has more than one row, it returns only the first row. The result is returned as an object. Here’s a usage example:

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

if ($query->num_rows() > 0)
{
        $row = $query->row();

        echo $row->title;
        echo $row->name;
        echo $row->body;
}

If you want a specific row returned you can submit the row number as a digit in the first parameter:

$row = $query->row(5);

In addition, you can walk forward/backwards/first/last through your results using these variations:

$row = $query->first_row();
$row = $query->last_row();
$row = $query->next_row();
$row = $query->previous_row();

Parameters:	$n (int) – The specific row to return $type (string) – The type of result to pull, either 'object' or 'array'
Returns:	An object or array representing the row
Return type:	Object/array

CI_DB_result::row_array([$n = 0])¶

Identical to the above row() function, except it returns an array:

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

if ($query->num_rows() > 0)
{
        $row = $query->row_array();

        echo $row['title'];
        echo $row['name'];
        echo $row['body'];
}

If you want a specific row returned you can submit the row number as a digit in the first parameter:

$row = $query->row_array(5);

Just like row(), you can walk through your results using these variations:

$row = $query->first_row('array');
$row = $query->last_row('array');
$row = $query->next_row('array');
$row = $query->previous_row('array');

Parameters:	$n (int) – The specific row to return
Returns:	An array representing the row
Return type:	array