how to return query result as one array in codeigniter [duplicate]

Question

i have table (tag).. i want to select all tags in this table and return it as single array where tag_id = index and tag_name = value like this array

array(
            3 => 'Hazel Grouse',
            4 => 'Common Quail',
            5 => 'Common Pheasant',
            6 => 'Northern Shoveler',
            7 => 'Greylag Goose',
            8 => 'Barnacle Goose',
            9 => 'Lesser Spotted Woodpecker',
            10 => 'Eurasian Pygmy-Owl',
            11 => 'Dunlin',
            13 => 'Black Scoter',
)

tags return like this multi D array

Array
(
    [0] => Array
        (
            [tag_id] => 3
            [tag_name] => Hazel Grouse
        )

    [1] => Array
        (
            [tag_id] => 4
            [tag_name] => Common Quail
        )

this is query code

 function get_alltags() {
        $this->db->select('tag_id');
        $this->db->select('tag_name');
        $result = $this->db->get('d_tag');
     return $result->result_array();
    }
    $alltags = $this->tag->get_alltags();
        echo "<pre>";
        print_r($alltags);
        echo "</pre>";
        exit;

Karan Thakkar · Accepted Answer · 2014-07-05 17:01:46Z

2

you can do something like this

$result=array();
$alltags = $this->tag->get_alltags();
foreach($alltags as $k => $v){
$result[$v['tag_id']]=$v['tag_name'];}
echo "<pre>";
print_r($result);

edited Jul 5, 2014 at 17:01

answered Jul 5, 2014 at 16:53

Karan Thakkar

1,4772 gold badges17 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

how to return query result as one array in codeigniter [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related