CodeIgniter - return only one row?

At the moment if I am doing a query on the database that should only return one row, using:

...query stuff...
$query = $this->db->get();
$ret = $query->result();
return $ret[0]->campaign_id;


Is there a CodeIgniter function to return the first row?
something like $query->row();

$query->row();

Or even better would be the ability to, if there was only one row,
to just use the query object directly.

e.g. $query->campaign_id;

$query->campaign_id;

8 Answers
8

You've just answered your own question :)
You can do something like this:

$query = $this->db->get();
$ret = $query->row();
return $ret->campaign_id;


You can read more about it here: http://www.codeigniter.com/user_guide/database/results.html

$row = json_decode($query->row(), true);

$row = $query->result_array()[0];

This is better way as it gives you result in a single line:

$this->db->query("Your query")->row()->campaign_id;


To add on to what Alisson said you could check to see if a row is returned.

// Query stuff ...
$query = $this->db->get();

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

$row = $query->row();
return $row->campaign_id;


return null; // or whatever value you want to return for no rows found


To make the code clear that you are intending to get the first row, CodeIgniter now allows you to use:

if ($query->num_rows() > 0)
return $query->first_row();



To retrieve the first row.

$this->db->get()->row()->campaign_id;


Change only in two line and you are getting actually what you want.

$query = $this->db->get();
$ret = $query->row();
return $ret->campaign_id;


try it.

We can get a single using limit in query

$query = $this->db->get_where('mytable', array('id' => $id), $limit, $offset);

$query = $this->db->get_where('mytable', array('id' => $id), $limit, $offset);


class receipt_model extends CI_Model

public function index()

$this->db->select('*');

$this->db->from('donor_details');

$this->db->order_by('donor_id','desc');

$query=$this->db->get();

$row=$query->row();

return $row;



Thanks for contributing an answer to Stack Overflow!

But avoid …

To learn more, see our tips on writing great answers.

Required, but never shown

Required, but never shown

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.