Laravel eloquent pagination call in relational database

Question

I have an user. User create many ads.I want to see users details with ads where ads shown by paginate. For this, i make two model(User & Ads)

public function user(){

     return $this->hasOne(User::class, 'id', 'user_id');
}

public function ads(){

    return $this->hasMany(Ads::class, 'user_id', 'id');
}

In controller i call like this:

$users = Ads::with(['user'=> function ($q) use ($id){
        $q->where('id',$id);
    }])->paginate(2);

But here user's details are shown when forelse loop are called. But i don't want this. So, How can i get user's details with ads's pagination?

If its the same relation, why you were passing 2 differentes foreign keys to the relations? — Piazzi, Apr 13 '19 at 12:52

score 1 · Accepted Answer · edited Apr 13 '19 at 14:45

I think you're overcomplicating. You has two models. In User, you can put this relationship:

public function ads(){
    return $this->hasMany(App\Ad, 'user_id', 'id');
}

In Ads model, you put this relationship:

public function user(){
     return $this->belongsTo(App\User, 'id', 'user_id');
}

In your controller, you simple call like this:

//If you want a list of User's Ads
$user = User::find(1);
$userAds = $user->ads()->paginate(2); //you paginate because can be many

//If you want the details from a user who made the Ad #1
$ad = Ad::find(1);
$user = $ad->user; //Don't need paginate because is only one.

Laravel eloquent pagination call in relational database

1 Answers1