undefined variable uprofile laravel 5.4

Question

I am using laravel framework 5.4 and write following controller class:

class ProfileController extends Controller
{
 public function index(){
      $uprofile = DB::table('user_profile')->find(Auth::id()); 
   return view('folder.profile')->with('uprofile',$uprofile);
 }

route is:

Route::get('/','ProfileController@index');

At view I'm using

@foreach($uprofile as $profile)             
    $profile->id
    @endforeach

What seems wrong here?

Answer 1

in your index method , just remove $uprofile

return view('folder.profile')->with('uprofile');

Answer 2

Change your index() method to :

public function index(){ 
    $uprofile = DB::table('user_profile')->where('userid','=',Auth::id())->first(); 
    return view('CityOfWorks.profile')->with('uprofile',$uprofile); 
}

Also in view

@foreach($uprofile as $profile)             
    {{ $profile->id }}    // Blade views in curly braces
@endforeach