PHP Query Array Without Header (CI using MySQL DB)

Question

Hello everyone i have some question about query on PHP using MySQL database.

I have table name test2 like this

testid  asd
1       A
2       B
3       C
4       D

and then i have query like this

public function m_get_wer() {
    $sql = "SELECT `asd` FROM test2";
    $data = $this->db->query($sql)->result_array();
    return $data;
}

when i used print_r on that query, the result like this

Array ( [0] => Array ( [asd] => A ) [1] => Array ( [asd] => B ) [2] => Array ( [asd] => C ) [3] => Array ( [asd] => D ) )

but the result that i need is like this

Array ( [0] => A [1] => B [2] => C [3] => D )

How i can get result like that. thanks.

Possible duplicate of Codeigniter when does result_array() return a single or multi dimensional array? — hisener
– hisener, Commented Apr 24, 2018 at 18:25
@Maykonn so whats the solution? is it possible i get result like i want? Array ( [0] => A [1] => B [2] => C [3] => D ) — Elroy Hardanto
– Elroy Hardanto, Commented Apr 24, 2018 at 18:40
Is not possible with codeigniter functions, I guess. You need a loop like @pradeep answered. Codeigniter provide to you an array like it because is expected that you will use the array values in this way for example: echo $result[0]["asd"]. I recommend you to write a new layer between your data access layer and your business code to translate the responses of queries in a way that make sense for your business code. — Maykonn
– Maykonn, Commented Apr 25, 2018 at 20:51

Pradeep · Accepted Answer · 2018-05-10 06:19:56Z

0

Hope this will help you :

public function m_get_wer()
    {   
        $sql = "SELECT asd FROM test2";
        $data = $this->db->query($sql)->result_array();

        if ($data)
        {
            foreach ($data as $key => $item) 
            {
                $result[$key] = $item['asd'];
            }
        }
        //print_r($result);die;
        return $result;
    }

Output will be :

Array
(
    [0] => A
    [1] => B
    [2] => C
    [3] => D
)

edited May 10, 2018 at 6:19

answered Apr 24, 2018 at 18:36

Pradeep

9,70713 gold badges29 silver badges34 bronze badges

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

8 Comments

Elroy Hardanto Over a year ago

wow thank you so much. its work. but can you tell me how thats work? i just want to know. Thanks

Pradeep Over a year ago

$data is the array of array to get the item of inner array a foreach loop is needed to loop through

Elroy Hardanto Over a year ago

what if i want to select 2 column like testid and asd. the result like this Array ( [0] => Array ( [0] => 1 [1] => A ) [1] => Array ( [0] => 2 [1] => B ) [2] => Array ( [0] => 3 [1] => C ) [3] => Array ( [0] => 4 [1] => D ) )

Elroy Hardanto Over a year ago

Like this? if ($data) { foreach ($data as $key => $item) { $result[$key] = $item['testid']; $result[$key] = $item['asd']; } } i already try that, but result just same like before, return Array ( [0] => A [1] => B [2] => C [3] => D ) sorry im not expert at coding

Pradeep Over a year ago

if u want both testid and asd then change sql as select * from test2 or select testid, asd from test2 and u will get the desired result

|

Collectives™ on Stack Overflow

PHP Query Array Without Header (CI using MySQL DB)

1 Answer 1

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related