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

Question

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);
    }

You will also need to add use($id) here: function ($query) use ($id) — DevK
– DevK, Commented Apr 23, 2018 at 5:46

Kuldeep Mishra · Accepted Answer · 2018-04-23 05:52:57Z

2

just change

public static function userDetail($id){


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


return $result ;

}

edited Apr 23, 2018 at 5:52

answered Apr 23, 2018 at 5:47

Kuldeep Mishra

4,0601 gold badge24 silver badges26 bronze badges

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

3 Comments

Javed Over a year ago

` "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'userDetails.user_id' in 'where clause' (SQL: select * from users where exists (select * from user_details where users.id = user_details.user_id and userDetails.user_id = 2) limit 1)",`

Ashutosh Sharma Over a year ago

This means user_id column in your userDetails table didn't exist.

Kuldeep Mishra Over a year ago

if it works please accept the answer and upvote. @Javed

sagecoder · Accepted Answer · 2018-04-23 05:40:22Z

1

If you dont need to use static, you can use this $result value on userDetails

public function userDetail($id){

        $result = userDetails::where('user_id', '=', $id)->first();

        return $result ;
}

Then the result can get access to the user from the vale by using $value->user->{user property}

answered Apr 23, 2018 at 5:40

sagecoder

1015 bronze badges

Collectives™ on Stack Overflow

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

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related