Laravel Eloquent : get data and use condition for related table column

Question

I use Laravel and Eloquent and I want get data from two table via relation.

For example i want select all book in categories that category status is active.

class Book extends Model
{
    public $belongsTo  = [
        'category' => '..\Models\Categories',
    ];

    public function categories() {
        return $this->belongsTo('..\Models\Categories');
    }

}

In controller i can use next code for select all books.

Book::with('categories');

Is there way to select all book in categories that category status is active?

Can you make it clear, if book can belong to multiple categories or single category? — Prafulla Kumar Sahu
– Prafulla Kumar Sahu, Commented Sep 2, 2019 at 5:56
then definitely, you have a many-to-many relationship and not one-to-many . — Prafulla Kumar Sahu
– Prafulla Kumar Sahu, Commented Sep 2, 2019 at 6:00

Suraj Singh · Accepted Answer · 2019-09-02 06:45:17Z

1

You can use eager loading for this.

Book::with(['categories' => function($query){
    $query->where('status','active');
}]);

answered Sep 2, 2019 at 6:45

Suraj Singh

1424 bronze badges

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

Comments

Prafulla Kumar Sahu · Accepted Answer · 2019-09-02 16:50:55Z

0

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Book extends Model
{
    /**
     * The categories that associated with the book.
     */
    public function categories()
    {
        return $this->belongsToMany('App\Category');
    }
}

In category model you can define scope

like public function scopeStatus($query, $status='active') { $query->where('staatus', $status); }

and you can retrieve as $book->categories and reverse is $category->books and categories with books Category::with('books')->status('active')->get() .

Note: you need pivot table in this situation

edited Sep 2, 2019 at 16:50

answered Sep 2, 2019 at 6:03

Prafulla Kumar Sahu

9,75911 gold badges78 silver badges116 bronze badges

1 Comment

Prafulla Kumar Sahu Over a year ago

@aya I have edited my answer, you can try this and let me know, if you are facing any issue with it?

Collectives™ on Stack Overflow

Laravel Eloquent : get data and use condition for related table column

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related