change array index while query

desatir7316 · November 29, 2014, 6:13pm

hi there

by default after a query like below, the result is a array with index 0,1,…




$query = new Query;

      $query->select('*')->from('item')->where("id IN ($items_id)");

      $result = $query->all();

i want to change array index to be item’s table id field

is it possible?

desatir7316 · November 30, 2014, 11:46am

dniznick · November 30, 2014, 2:19pm

Use indexBy() in your query to have the primary key of the field be its index.

desatir7316 · November 30, 2014, 2:31pm

something like this?




 $query->select('*')->from('item')->where("id IN ($items_id)")->indexBy('id');