Laravel Model Query with "with" and "where condition" not working

Question

This Query Of get bookmarks is working with condition without relation with user_topics

$bookmarkedposts = BookmarkedPost::where('leader_id',$user_id)->get();

But When I add add relation to other model it didn't work

$bookmarkedposts = BookmarkedPost::where('leader_id',$user_id)->with('user_topics.first_media')->get();

Here is Bookmarked.php

namespace App\Models; use Illuminate\Database\Eloquent\Model; class BookmarkedPost extends Model { public function user_topics() { return $this->hasOne('App\UserTopic','id')->where('isdelete',0)->where('isactive',1); } }

bookmarked_posts_table_sturucture user_topics_table_stucture

"it didn't work" - What do you mean by that? Using ->with() doesn't exactly do anything on its own... What is your expected result, and what is actually happening? — Tim Lewis
– Tim Lewis, Commented Nov 14, 2019 at 17:13

Alberto · Accepted Answer · 2019-11-14 18:20:56Z

1

BookmarkedPost Model:

class BookmarkedPost extends Model { public function user_topic() { return $this->belongsTo('App\UserTopic','user_topic_id', 'id'); } }

UserTopic Model:

class UserTopic extends Model { public function bookmarder_posts() { return $this->hasMany('App\BookmarkedPost','user_topic_id', 'id'); } }

Inside the function now you can use:

$bookmarkedposts = BookmarkedPost::where('leader_id',$user_id)->with('user_topic')->get();

edited Nov 14, 2019 at 18:20

answered Nov 14, 2019 at 16:55

Alberto

13.1k3 gold badges31 silver badges72 bronze badges

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

17 Comments

Prem Thakkar Over a year ago

Hello @AlbertoSinigaglia ,thank you so much for answer, I changed my Bookmarked.php exact as you wrote,but issue is still the same. :(

Alberto Over a year ago

what relations have BookmarkedPost with UserTopics?

Prem Thakkar Over a year ago

belongsTo here is method code return $this->belongsTo('App\Models\BookmarkedPost');

Alberto Over a year ago

i mean, the relation in the database

Prem Thakkar Over a year ago

In Database Bookmarked_posts table has column user_topic_id reference key of user_topic table.

|

Jrb · Accepted Answer · 2019-11-14 17:07:29Z

0

Try this

 BookmarkedPost::where('leade_id', $user_id)->with('user_topics');

answered Nov 14, 2019 at 17:07

Jrb

4617 silver badges15 bronze badges

5 Comments

Prem Thakkar Over a year ago

Thank You so much for help but,I tried this This is also Not Working @YJRB

Prem Thakkar Over a year ago

@Y JRB Getting no error but condition is not working.

Jrb Over a year ago

Try to change your user_topics() relation like this : return $this->hasOne('App\UserTopic', 'user_topic_id')->where('isdelete',0)->where('isactive',1);

Prem Thakkar Over a year ago

Already Tried That also But Still Condition is not working. :(

Jrb Over a year ago

Does your code exists on Github and is open source?

Collectives™ on Stack Overflow

Laravel Model Query with "with" and "where condition" not working

2 Answers 2

17 Comments

5 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

17 Comments

5 Comments

Related