Laravel 5.6: Eloquent + DB::Builder query array indexes

Question

I have two queries that return a collection. But with different ids I get different array indexes.

$worker = Worker::find($worker_id);
$man = $worker->managers->where('id', $manager_id)->first();
$tasks = $man->tasks->where('worker_id', $worker_id);
dd($tasks->toArray());

When I run this query with $worker_id of 1, I get an array with numeric index starting from 0:

[
 {
   "id": 1,
   "task_name": "Cleaning"
 },
 ....
]

But with $worker_id of 2, I get an array with named (string) indexes starting from "9":

[
 "9": {
   "id": 18,
   "task_name": "Staff reorientation"
 },
 "10": {
   "id": 19,
   "task_name": "Schedule"
 }
 ....
]

What may be the cause?

türk olduğunu düşünerek türkçe yazıyorum, sorunun kaynağını bilmiyorum ancak array_values() metodunu kullanarak düzeltebilirsin. ayrıca tek bir sorgu ile yukarıdaki verileri çekebilirsin, ayrı ayrı her biri için istek atma gereksiz, ki muhtemelen bunu foreache sokuyorsan her ilişki için veritabanına istek atacak, sunucuyu çok yorabilir. — Hasan Teoman Tıngır
– Hasan Teoman Tıngır, Commented Aug 17, 2018 at 11:47
Tek sorguya dönüştürülmüş örnek yazabilir misin? Teşekkürler. — moonwalker
– moonwalker, Commented Aug 17, 2018 at 12:18

Jonas Staudenmeir · Accepted Answer · 2018-08-17 15:11:52Z

1

Filtering a collection doesn't change the original keys. You can reset them with values():

$tasks = $man->tasks->where('worker_id', $worker_id)->values();

answered Aug 17, 2018 at 15:11

Jonas Staudenmeir

26k7 gold badges70 silver badges114 bronze badges

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

Collectives™ on Stack Overflow

Laravel 5.6: Eloquent + DB::Builder query array indexes

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related