Forum Getting error when returning query to view (Trying to get property of non-object)

posted 7 years ago

Last updated 2 years ago.

replied 7 years ago

it should be

$userUpdate = DB::select('SELECT * FROM users WHERE id = ?', [$id])->get();

$userUpdate will return the results as a collection. You need to loop that. to get just the first result you can use first() method

$userUpdate->first()->name;

if the collection is empty, you will again get the same error, to fix that use:

$userUpdate->first() ?: $userUpdate->first()->name;

Last updated 7 years ago.

replied 7 years ago

Solution

Thank you for your response I just fixed it using the query builder

$userInfo = DB::table('users')->where('id', $id)->first();
return view('users.update', ['userInfo' => $userInfo]);

Bram Raaijmakers bramr94 Joined 5 Jan 2017

We'd like to thank these amazing companies for supporting us

The Laravel portal for problem solving, knowledge sharing and community building.

Laravel.io

Socials

The community