CodeIgniter , how to get single element instead of array of size 1? [duplicate]

Question

I'm new to CodeIgniter. I love it, it's great, but one issue cannot resolve for days.

I'm trying to get a single row, by its id, like this :

$query = $this->db->get_where('content', ['id' => $id]);
$the_content = $query->result_array();

However, it results in an array of size 1, like this:

$the_content = [ 0 => ['id' => 1, 'content'=> 'abc']];

so I always have to convert it to its first element like this:

$the_content= $the_content[0];

But you can understand why I don't like this.

I also tried $query->result(); , still the same.

I'm sure I'm missing a simple point here, but what?

How do I get single element from ActiveRecord instead of array?

$query = $this->db->get_where('content', ['id' => $id]); $the_content = $query->row(); — Reena Shirale
– Reena Shirale, Commented Sep 25, 2014 at 8:47

Nil'z · Accepted Answer · 2013-09-25 12:43:58Z

3

The solution would be:

$the_content = $query->row_array();

To return a single dimentional array. To retrieve you would write:

echo $the_content['content'];

answered Sep 25, 2013 at 12:43

Nil'z

7,4831 gold badge20 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Amal · Accepted Answer · 2013-09-25 12:45:25Z

3

$row = $query->first_row();

If you want an array instead:

$row = $query->first_row('array')

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

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

If you want to get the field of the first row:

$field = $query->first_row()->field;
echo $field;

See the documentation here.

answered Sep 25, 2013 at 12:45

Amal

76.8k18 gold badges133 silver badges154 bronze badges

ihsan · Accepted Answer · 2013-09-25 12:42:47Z

1

There is a function to get the first row from query:

$the_content = $query->first_row('array')

answered Sep 25, 2013 at 12:42

ihsan

2,28920 silver badges37 bronze badges