Search code examples
laravellaravel-5.5

Laravel : Call to undefined method Illuminate\\Database\\Query\\Builder


On query get the error with undefine method. Simply i want to get data from two tables query look linke

  public static function userDetail($id){


    $result = User::whereHas('user_details', function ($query) {
        $query->where('user_details.user_id',$id);
    })->first();


    return $result ;
}

Relationship

On Model User define relationship

public function userDetails()
{
   return $this->hasOne(UserDetails::class);
}

and in userDetails model

public function user()
    {
        return $this->belongsTo(User::class);
    }

Solution

  • just change

    public static function userDetail($id){
    
    
    $result = User::whereHas('user_details', function ($query) use($id) {
        $query->where('user_id',$id);
    })->first();
    
    
    return $result ;
    

    }