Laravel accesing data from db inside controller

Question

I am trying to get data from one form and save it to another db table with modifications. But, I am getting error:

trying to get property of non-object

on the last line from the given block of codes.

$ply->team_name = $request->get('team_name');

    $team_name=$ply->team_name;
    $team=Team::find($team_name);
    $team->balance=$team->balance-$ply->sold_amount;

Most probably $team is null because it was not found in the previous line. — Matey
– Matey, Commented Sep 25, 2017 at 7:54
the problem is here $team=Team::find($team_name); find is equivalent to where id = $var so it will return null to fix it try this $team=Team::where('name', $team_name)->get(); — Maraboc
– Maraboc, Commented Sep 25, 2017 at 7:54

Rafik Tighilt · Accepted Answer · 2017-09-25 08:02:34Z

1

The find method expects an id as parameter, when you are giving it a string.

Model::find($id);

You can use the where clause :

Model::where('name', $name)->first();
/*
 * Or
*/
Model::where('name', $name)->get();

Aftet that, you should check if your $team is not null before trying to access its properties.

Finally, I strongly recommend to use the dd($var) for debugging purpose, it is very helpful.

edited Sep 25, 2017 at 8:02

answered Sep 25, 2017 at 7:59

Rafik Tighilt

2,1011 gold badge17 silver badges27 bronze badges

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

6 Comments

Maraboc Over a year ago

there is no problem here $team->balance=$team->balance-$ply->sold_amount; this is equivalent to $team->balance -= $ply->sold_amount; ;)

Ken Graham Over a year ago

It is okay. I also forgot to change the primary key.

Ken Graham Over a year ago

Still getting property balance not found. With dd($team) getting 0 inside array as output.

Ken Graham Over a year ago

Collection {#188 ▼ #items: array:1 [▼ 0 => Team {#187 ▶} ] }

Rafik Tighilt Over a year ago

You have your team inside the array, check its property names. Dumb question : The balance field exists on the database right ?

|

Collectives™ on Stack Overflow

Laravel accesing data from db inside controller

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related