how to convert mysql array into php array

Question

i have a array like below:

Array ( [0] => stdClass Object ( [city_name] => Hyderabad ) 
        [1] => stdClass Object ( [city_name] => Visakhapatnam )
        [and so on..] => and so on...
      )

this array is return by this block of code:::

 $query = "select city_name from city";
 $result = $CI->Dbmodel->customQueryResult($query);
 print_r(array_values($result));

and i would like to convert the above array to:

array('Hyderabad','Visakhapatnam','and so on..')

do php provide any built-in-function?

how can i do this?.. any help or suggestion would be a great help..thanks in advance

Are you using a framework? The sign will be to map the array to convert objects into arrays... — Allan Stepps
– Allan Stepps, Commented Mar 23, 2014 at 13:34
A simple foreach ? $city = array(); foreach($yourobj as $obj) { $city[]=$obj->city_name; } — Shankar Narayana Damodaran
– Shankar Narayana Damodaran, Commented Mar 23, 2014 at 13:35
@ShankarDamodaran thanks sir..your comment does this...works like charms.. thank you very much sir.. — Mohammed Sufian
– Mohammed Sufian, Commented Mar 23, 2014 at 13:50

Allan Stepps · Accepted Answer · 2014-03-23 13:37:18Z

2

This should work:

$query = "select city_name from city";
$result = $CI->Dbmodel->customQueryResult($query)->result_array();
print_r($result);

answered Mar 23, 2014 at 13:37

Allan Stepps

1,0671 gold badge10 silver badges24 bronze badges

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

Comments

Sanoob · Accepted Answer · 2014-03-23 13:38:19Z

2

If you can't modify your model use this code

$reslt = array();
    foreach($result_array as $value){
        $reslt[] = $value->city_name;
    }

or use result_array() function.

answered Mar 23, 2014 at 13:38

Sanoob

2,4724 gold badges32 silver badges38 bronze badges

Collectives™ on Stack Overflow

how to convert mysql array into php array

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related