Level 75
You can use view composer as a singleton. Then your query will be fetch only once.
<?php
namespace App\Http\View\Composers;
use App\Category;
use Illuminate\View\View;
class MenuComposer
{
protected $categories;
public function compose(View $view)
{
if (! $this->categories) {
$this->categories = Category::all();
}
$view->with([
'categories' => $this->categories
]);
}
}
<?php
namespace App\Providers;
use App\Http\View\Composers\MenuComposer;
use Illuminate\Support\Facades\View;
use Illuminate\Support\ServiceProvider;
class ViewServiceProvider extends ServiceProvider
{
/**
* Register services.
*
* @return void
*/
public function register()
{
$this->app->singleton(MenuComposer::class);
}
/**
* Bootstrap services.
*
* @return void
*/
public function boot()
{
View::composer([
'view.where.you.use.that.categories',
'another.one'
], MenuComposer::class);
}
}