How to filter products by attributes (color, size, etc.) in Laravel
P粉821274260
2023-08-28 00:17:09
<p>I am new to Laravel and want to filter out specific products. </p>
<p>I have two tables in my database, the first is the table <code>products</code>, and the second is the table <code>attributes</code>. </p>
<p><strong>Product List</strong></p>
<pre class="brush:php;toolbar:false;">Schema::create('products', function (Blueprint $table) {
$table->bigIncrements('id');
$table->BigInteger('category_id')->unsigned()->nullable();
$table->string('name');
$table->string('code');
$table->integer('status')->default(1);
$table->integer('featured')->default(1);
$table->string('image');
$table->longText('short_description');
$table->longText('long_description');
$table->timestamps();
})</pre>
<p><strong>Product attribute table</strong></p>
<pre class="brush:php;toolbar:false;">Schema::create('product_attributes', function (Blueprint $table) {.
$table->bigIncrements('id');
$table->unsignedBigInteger('product_id');
$table->string('sku');
$table->string('size');
$table->string('color');
$table->string('price');
$table->string('stock');
$table->timestamps();
})</pre>
<p><strong>Relationships</strong></p>
<p>Because I have multiple attributes for a single product</p>
<pre class="brush:php;toolbar:false;">class Product extends Model
{
use HasFactory;
public function attributes()
{
return $this->hasmany('App\Models\ProductAttributes', 'product_id');
}
}</pre>
<p><strong>My Blade Files</strong></p>
<pre class="brush:php;toolbar:false;"><form action="{{url('/product/filter')}}" method="post">
@csrf
<input type="hidden"value="{{$slug}}"name="slug">
<div
class="custom-control custom-checkbox d-flex align-items-center justify-content-between mb-3">
<input name="color" onchange="javascript:this.form.submit();" type="radio" class="custom-control-input" id="black" value=" ;black"> <label class="custom-control-label" for="black">Black</label>
</div>
</form></pre>
<p>I have a function in my controller</p>
<pre class="brush:php;toolbar:false;">public function shop()
{
$filter_products = Product::with('attributes')->where(['category_id' => $category->id, 'color' => $request->color]);
return view('frontend.shop', compact('filter_products'));
}</pre>
<p>I don't get any results after applying this function</p>
<p>Please guide me how to filter products based on specific size or color on frontend store page.
and what code will be included in the store functionality. </p>
<p>Please reply to me, I will thank you very much</p>
You need to filter by relationship, please check the documentation
https://laravel.com/docs/9 .x/eloquent-relationships#querying-relationship-existence
for example Use WhereHas
If applied nowhere in with, all properties will be returned
You can prevent this behavior using the same filter applied in whereHas