Creating indexed array from query in codeigniter

Although this is probably not the best way to achieve your goal, I made an object to array conversion function which I can share with you:

function (throw this into a helper file or something)

function object_to_array_recursive(&$o)
{
    if(is_object($o))
    {
        $o = (array)$o;
    }

    if(is_array($o) && count($o) > 0)
    {
        foreach($o as $k=>&$v)
        {
            object_to_array_recursive($v);
        }
        unset($v);
    }
}

Use of function

$my_db_result = $bd->result();
object_to_array_recursive($my_db_result);

return $my_db_result;

Since it accepts the parameter by reference, you will have to pass it a variable name because object_to_array_recursive($bd->result()); will fail.

You have to extract all the data you need into a new array, and then return it.

You can do this like the following :

$getEnds = function($value){ return $value->end; };

return array_map($getEnds, $bd->result());

The array_map looping the given results, and apply on each value of it the function in first parameter. This function just return the end param from current object.

You can also compress your code :

return array_map(function($value){ return $value->end; }, $bd->result());

Try this code:

$bd = $this->db->select('session, end')
    ->from('session_dates')
    ->where('end >=', $now)
    ->get();
$result_array = array();
foreach ($bd->result() as $row){
    $result_array[$row->session] = $row->end;
}
return $result_array;