Level 39
Put it int the construct function of your controller
public function __construct() {
$this->companies=...
}
Jan 6, 2021
4
Level 4
Repetitive eloquent query across 1 controller.
Let's assume that I have a controller which is dedicated to control the views, so i have different types of views and i send to them different variables, but - i have one query which repeats itself across all the functions, in this case its
$companies = Company::where('enabled',1)->get()->sortByDesc('score');
What would be the right approach to keep it DRY? Is it safe to put this variable in the external scope of the controller and not in every function?
Level 75
Use a view composer for that and sort your query in the database
$companies = Company::where('enabled',1)->orderByDesc('score')->get();
1 like
Level 4
So what's the best approach? The view composer or simply putting this query inside my controller's construct?
Level 75
If you need it only in views than it's a view composer.
1 like
Please or to participate in this conversation.