Am trying to make a eCommorece project and I want to add filter dropmenues on the products table, to search from more than one database, but everytime I select an option I get this error below...
https://flareapp.io/share/v5pzQz2P
And here is the conde on the controller
$products = Product::orderBy('id', 'desc')
->where( function($query) use($request){
return $request->status_id ?
$query->from('products')->where('status',$request->status_id) : '';})
->where( function($query) use($request){
return $request->category_id ?
$query->from('product_categories')->where('category_id',$request->category_id) : '';})
->paginate(30);
$selected_id = [];
$selected_id['status_id'] = $request->status_id;
$selected_id['category_id'] = $request->category_id;
return view('dashboard.products.index', compact('products', 'selected_id'), $data);
My blade view
form class="col-sm-5 px-2" action="" method="GET">
@csrf
<select class="form-select form-select-sm" name="status_id" aria-label="Bulk actions" onchange="this.form.submit()">
<option value="0" >All Products</option>
<option value="00" >Disabled Products</option>
<option value="1" >Enabled Products</option>
</select>
</form>
<form class="col-sm-5" action="" method="GET">
@csrf
<select class="form-select form-select-sm" name="category_id" aria-label="Bulk actions" onchange="this.form.submit()">
<option value="0" >All Products</option>
<option value="1" >11223123</option>
</select>
</form>
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire