Laravel 7.6调用未定义的方法Illumb\Database\Eloquent\Builder:：appends（）

Question

我无法将结果附加到查询中。我正在使用页面上的类别筛选结果，并尝试添加分页。当用户单击类别时，只应显示与类别相关的产品，在分页时，我希望保留所选类别。我得到了这个错误：

Facade\Ignition\Exceptions\ViewException调用未定义的方法Illumb\Database\Eloquent\Builder:：appends（）（视图：D:\Xampp\htdocs\ProjectName\resources\views\products\index.blade.php）

我从laravel docs那里试过这个

{{ $users->appends(['category' => 'query'])->links() }}

这是我的控制器：

 public function index(Request $request)
{

    // If the category is selected
    if(request()->category) {

        $products = Product::with('categories')->whereHas('categories', function ($query){
            $query->where('slug', request()->category);
        });

        $categories = Category::all();
        $categoryName =  optional($categories->where('slug', request()->category)->first())->name;

    }else {

        $products = Product::paginate(9);
        $categories = Category::all();
        $categoryName = 'All Products';

    }

    return view('products.index')->with([
        'products' => $products, 
        'categories' => $categories,
        'categoryName' => $categoryName,
        ]);
}

这是我的刀片文件：

<h4>{{ $categoryName }}</h4>

                            @forelse ($products as $product)

                                <div class="card mb-3 shadow" style="">
                                    <div class="row no-gutters">

                                        <div class="col-md-4 d-flex justify-content-around p-2 border">
                                            <img src="/storage/products/{{ $product->image }}" class="card-img">
                                        </div>

                                        <div class="col-md-8 p-2">

                                            <div class="card-body">
                                                <h5 class="card-title">{{ $product->title}}</h5>
                                                <p class="card-text"> {!! \Illuminate\Support\Str::limit($product->text, $limit = 100) !!} </p>
                                                <div class=""><a href="/products/{{ $product->slug }}"><button class="btn btn-outline-warning float-left">View Cataloge</button></a>
                                                </div>
                                            </div>

                                        </div>
                                    </div>
                                </div>

                            @empty

                                <div class="card">
                                    <div class="card-title p-5 shadow bg-light">
                                        <h5>No products found</h5>
                                    </div>
                                </div>

                            @endforelse

                                <div class=" d-flex justify-content-around">
                                    {{ $products->appends(request()->input())->links() }}
                                </div>

Answer 1

这里你缺少分页（9）也传递（$ask）在闭包函数

public function index(Request $request)
{

    // If the category is selected
    if (!empty($request)) {
        $products = Product::whereHas('categories', function ($query) use ($request) {
            $query->where('slug', $request->category);
        })->paginate(9);

        $categories = Category::all();
        $categoryName =  optional($categories->where('slug', request()->category)->first())->name;

        return view('products.index')->with([
            'products' => $products, 
            'categories' => $categories,
            'categoryName' => $categoryName,
            ]);
    }
    else {

        $products = Product::paginate(9);
        $categories = Category::all();
        $categoryName = 'All Products';

        return view('products.index')->with([
            'products' => $products, 
            'categories' => $categories,
            'categoryName' => $categoryName,
            ]);

    }

}