Laravel eloquent issue getting db datas

Question

I'm having a problem getting some datas from my database via eloquent:

at first I do this to get 'id' and 'capMax' from clase_schedule table:

$plazas = DB::table('clase_schedule')->select(['schedule_id', DB::raw('SUM(capMax) as capMax')])->groupBy('schedule_id')->get();

and then i want to get the the name of table schedule where the id i got before coincides with the one on this table, like this:

$nom_horarios = DB::table('schedule')->select('name')->where('id', 'in', $plazas->schedule_id)->get();

I get this error:

"Trying to get property of non-object"

I get an array with two values, schedule_id and capMax that is the result of sum(capMax) for each group of values: array:2 [▼ 0 => {#483 ▼ +"schedule_id": "2" +"capMax": "221" } 1 => {#482 ▼ +"schedule_id": "3" +"capMax": "12" } ] — user3557451
– user3557451, Commented Mar 16, 2016 at 11:20
if you are getting array then you should use loop to query again with the value in array . — Drudge Rajen
– Drudge Rajen, Commented Mar 16, 2016 at 11:29
doing the foreach i dont know why i just get the first one with this: foreach ($plazas as $plaza) { $nom_horarios = DB::table('schedule')->select('name')->where('id', 'in', $plaza->schedule_id)->get(); } — user3557451
– user3557451, Commented Mar 16, 2016 at 11:30

Drudge Rajen · Accepted Answer · 2016-03-16 11:32:57Z

2

Since, $plazas is an array so you should loop the $plazas to get the value in next query as below :

  foreach ($plazas as $plaza) 
    {
     $nom_horarios[] = DB::table('schedule')->select('name')->where('id', 'in',$plaza->schedule_id)->get(); 
    } 
    print_r($nom_horarios);

answered Mar 16, 2016 at 11:32

Drudge Rajen

8,0414 gold badges25 silver badges43 bronze badges

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

2 Comments

user3557451 Over a year ago

This one got the solution, i was missing the array sign in $nom_horarios thnks

Drudge Rajen Over a year ago

Great !! If you find this answer helpful then please tick it so that it can be useful to others in future ::) .

Vilius · Accepted Answer · 2016-03-16 11:17:01Z

0

$plazas returns an array of items, instead of get(), use first(). This will return single item.

$plazas = DB::table('clase_schedule')->select(['schedule_id', DB::raw('SUM(capMax) as capMax')])->groupBy('schedule_id')->first();

Or loop plazas in foreach

answered Mar 16, 2016 at 11:17

Vilius

1,0362 gold badges15 silver badges25 bronze badges

4 Comments

user3557451 Over a year ago

the thing is that what i want to get is the name of each of the items in the array

user3557451 Over a year ago

doing the foreach i dont know why i just get the first one with this: foreach ($plazas as $plaza) { $nom_horarios = DB::table('schedule')->select('name')->where('id', 'in', $plaza->schedule_id)->get(); }

Vilius Over a year ago

do var_dump($plazas->count()); ans see how many plazas you're returning

user3557451 Over a year ago

im getting two items on the array

Rômulo M. Farias · Accepted Answer · 2016-03-16 11:17:49Z

0

What is returning in the $plazas variable?

I think the problem is you are getting a collection and not a item... If you want to get just one plaza you should ->first() instead of ->get();

answered Mar 16, 2016 at 11:17

Rômulo M. Farias

1,5231 gold badge17 silver badges29 bronze badges

3 Comments

user3557451 Over a year ago

I get an array with two values, schedule_id and capMax that is the result of sum(capMax) for each group of values: array:2 [▼ 0 => {#483 ▼ +"schedule_id": "2" +"capMax": "221" } 1 => {#482 ▼ +"schedule_id": "3" +"capMax": "12" } ] What i want to get is the name of each id in table schedule

Rômulo M. Farias Over a year ago

You can do $plazas->only('schedule_id'), that way you'll get just the ids, then call the in operator. Like this $nom_horarios = DB::table('schedule')->select('name')->where('id', 'in', $plazas->only('schedule_id'))->get();

Rômulo M. Farias Over a year ago

Sorry, the only will get in separetad arrays still.. The map function can fix $this $plazas->map(function($obj){return $obj->schedule_id;});

Collectives™ on Stack Overflow

Laravel eloquent issue getting db datas

3 Answers 3

2 Comments

4 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

4 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related