phpkohanakohana-3kohana-3.2kohana-db

How can I get an indexed array from query result in Kohana 3.2?

How can I get the INDEXED array result?

$qry1 = DB::select('name')->from('people')->execute();

$assoc_array = $qry1->as_array();
$object      = $qry1->as_object();

// $indexed_array = [...]

Only for learning purposes, thanks.

It's like:

$indexed_result[0]; // Name
// $indexed_result[1];
// $indexed_result[2];
Solution

  • Do you want to get an array of names like array(0 => 'John', 1 => 'Sam')?

    You should call $names = $gry1->as_array(NULL, 'name');