How to create a flat array from a single record returned from CodeIgniter query builder [duplicate]

Question

I just don't understand, I have code like this:

$this->ci->db->select('liked_posts, liked_comments');       
$q = $this->ci->db->get_where('users_fav', array('usr_id' => $this->_usrId));
$result = $q->result_array();

And when I, as always, tried to put it into foreach loop.. it's just didn't work.. Because in $result I've got and array where 2 more arrays where stored (table fields) so to work in foreach loop it would look like this:

foreach ($result[0] as $value)

not:

foreach ($result as $value)

And I was looking for my mistake very long.. Maybe I really did something wrong... Or is it a bug?

edit: print_r($result);

Array
(
    [0] => Array
        (
            [liked_posts] => a:0:{}
            [liked_comments] => a:0:{}
        )

)

edit2:

But shouldn't it be like this:

Array
            (
                [liked_posts] => a:0:{}
                [liked_comments] => a:0:{}
            )

define 'does not work', is there an error? The printed $result looks like what is to be expected... — NDM
– NDM, Commented Sep 19, 2013 at 14:14

ABorty · Accepted Answer · 2013-09-19 14:13:02Z

2

so you can do this

foreach($result as $value)
{
    echo $value['fav_posts'];
}

no problem with that.

answered Sep 19, 2013 at 14:13

ABorty

2,5121 gold badge15 silver badges16 bronze badges

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

Comments

Nil'z · Accepted Answer · 2013-09-19 14:18:07Z

0

When using $result = $q->result_array(); you will get a multidimentional array as you have now.:

foreach( $resuls as $key => $each ){
    echo "result : ".$each['column_name'];
}

but if you have just a single row fetched you would likely use $result = $q->row_array(); which will return a single dimentional array. And you can directly use like this:

echo $results['column_name'];

answered Sep 19, 2013 at 14:18

Nil'z

7,4831 gold badge20 silver badges28 bronze badges

Collectives™ on Stack Overflow

How to create a flat array from a single record returned from CodeIgniter query builder [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related