Convert Laravel query results from array of objects to array of indexed arrays

Question

I have this code

$datas = DB::table('uni_staff')
->join('department', 'uni_staff.department_id', 'department.id')
->join('uni_staff_type', 'uni_staff.type_id', 'uni_staff_type.id')
->select('uni_staff.*', 'department.dep_name as departmentName' , 'uni_staff_type.user_type as 
  typeName')
->where('uni_staff.id', $id)
->select('uni_staff.*')
->get();

I want to put every column value of a row to an indexed array, or print the result by column index like or something else $datas[0] not column names like $datas->id.

Can you elaborate a bit more on what the intended outcome and usage is? — Mhluzi Bhaka
– Mhluzi Bhaka, Commented Nov 23, 2020 at 10:54
@MhluziBhaka this is my result of query : {"id":3,"first_name":"pepe","middle_name":"ahmad","last_name":"ali","full_name":"pep shan kj","pho_number":"ml;k","user_code":"ljl;j","type_id":1,"department_id":2,"internet1":"5654","internet2":"545","printer_code":546,"status":"544","date":"2020-11-18","note":"dsds","add_by":"dsd","departmentName":"Design","typeName":"Employee"} I want to put all column values to an array then use loop to print the array — PESHANG AHMAD
– PESHANG AHMAD, Commented Nov 24, 2020 at 6:03

lagbox · Accepted Answer · 2020-11-23 10:26:21Z

2

Without having to change any configuration you could use the Collection to map those objects to arrays and then call array_values on them:

$datas->map(fn ($row) => array_values((array) $row));

Laravel 8.x Docs - Collections - Available Methods - map

answered Nov 23, 2020 at 10:26

lagbox

50.7k8 gold badges76 silver badges85 bronze badges

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

Comments

Mhluzi Bhaka · Accepted Answer · 2020-11-23 10:53:43Z

1

Have you tried using toArray?

$datas=DB::table('uni_staff')
->join('department','uni_staff.department_id','department.id')
->join('uni_staff_type','uni_staff.type_id','uni_staff_type.id')
->select('uni_staff.*','department.dep_name as departmentName' , 
'uni_staff_type.user_type as typeName')
->where('uni_staff.id',$id)
->select('uni_staff.*')
->get()
->toArray();

answered Nov 23, 2020 at 10:53

Mhluzi Bhaka

1,3923 gold badges22 silver badges45 bronze badges

2 Comments

lagbox Over a year ago

they would end up with an array of stdClass objects

PESHANG AHMAD Over a year ago

Error message : " Cannot use object of type stdClass as array "

Collectives™ on Stack Overflow

Convert Laravel query results from array of objects to array of indexed arrays

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related