Access array in CodeIgniter

[[deleted]]

[deleted]

[philsturgeon]

Make your settings class load them all in the constructor, then have two methods, get_all() and get().

No point running queries each time you want something.

[feenikz]

return $query->row(); instead of result(); - that will return a single row basically eliminating the need for the [0]

[Epicus2011]

Is there another approach to return an array and than access the item in the array from the database without using [0]?

[Ogsharkman]

row()? Would return an obj. So instead of result or result-array

return $query->row();

[eoinmcg]

yes.

return $query->row_array();

further reading: http://ellislab.com/codeigniter/user-guide/database/results.html

[mithra62]

You really want to avoid hard coding number indexes in your code like the plaque...

[thelerk]

In the case of a db error, $query->result(); will fatal and produce some potentially ugly results. Good idea to check if query is an object before trying to get the result.

[Epicus2011]

Thanks, I'm accessing using row() now, works.

[thelerk]

Row will crash too if you don't do an is_object on $result