在laravel中使用DB facade连接查询

Question

I have write a join query using DB Facade in laravel. but when i'm run it, it don't show any error or any data just show an empty array. Here is my code.

public function memberdetails($id)
{

   $user = DB::table('userinformations')
        ->join('users', 'userinformations.user_id', '=', 'users.id')
        ->select('userinformations.*','users.*')
        ->where('userinformations.user_id','=',$id)
        ->get();
    return $user;
}

Answer 1

Check your both table then try this. use DB facade.

$user = DB::table('userinformations')
    ->join('users', 'userinformations.user_id', '=', 'users.id')
    ->select('userinformations.*','users.*')
    ->where('userinformations.user_id','=',$id)
    ->get();
return $user;