i can't search when it comes to searching NUMBERS on row int (price)
, but when searching like String number on row string (name)
it's working fine
like this in my table row here is my Product table
category_id
"56"
user_id
"1"
name
"555"
description
"fruit"
price
555
when i am searching the name
row "555" it's working fine beacuse its a string
. but when it comes to price i can't search it because it's int
here is my code for controller searching
public function index(Request $request){
$user = Auth::user()->id;
if($request->search){
$search = $request->search;
$products = Products::with('category')
->where('name','like',"%$search%")
->orWhere('price','like',"%$search%")
->where('user_id',$user)->paginate(10);
}else{
$products = Products::with('category')->where('user_id',$user)->paginate(10);
}
return view('client.product.index',['products'=>$products]);
}
here is my blade
<form class="w-full" action="">
<i class="fa fa-search"></i>
<input placeholder="Search" type="search" name="search">
<button type="submit">Search</button>
</form>
@foreach ($products as $product)
<p></p>
<p></p>
@endforeach
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire