Laravel Eloquent Model - Appends with Join Query

Question

I have a Categories table.

It has a foreign key of question_category in the questions table

I am looping through 4 of my Categories like so :

$categories = MockCategories::take(4)->get();

In the MockCategories Model, I'd like to add a "num_questions" property. Which in turn will run a query in the questions table and return a count of number questions based on that category.

Can I do this? Is there maybe a better way of doing it? I'm thinking maybe adding a relationship of hasMany and linking to the questions, Then showing a count of them.

Any help appreciated.

Thanks

madalinivascu · Accepted Answer · 2017-10-25 08:48:39Z

1

You can do something like this in the MockCategories model:

private $num_questions = 4;

public function scopeTakeFour($query) {
   $query->take($this->num_questions )->get();
}

and in your controller you simply do:

MockCategories::takeFour();

answered Oct 25, 2017 at 8:48

madalinivascu

32.4k4 gold badges41 silver badges59 bronze badges

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

Collectives™ on Stack Overflow

Laravel Eloquent Model - Appends with Join Query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related