How can I replace raw query to laravel format

Question

DB::select("SELECT products.* ,categories.* FROM products 
INNER JOIN category_products ON category_products.product_id = products.id
INNER JOIN categories ON category_products.category_id = categories.id 
WHERE categories.slug='$slug'")

This row query working fine but I can not access their relation like

$product->Categories->first()->name

@foreach($product->Images as $image)

My product Model below :

class Product extends Model
{
    public function Category(){
        return $this->hasMany(CategoryProduct::class);
    }
    public function getCategory($id){
       return Category::find($id)->name;
    }
    public function Images(){
       return $this->hasMany(Image::class);
    }

    public function Categories()
    {
        return $this->belongsToMany(Category::class, 'category_products');
    }
}

so how can convert my code to Laravel eloquent

"so how can convert my code to Laravel eloquent" laravel.com/docs/5.7/queries#joins — Raymond Nijland
– Raymond Nijland, Commented Sep 14, 2018 at 11:11
Please check my answer: stackoverflow.com/a/52330836/5013099 — Muhammad Inaam Munir
– Muhammad Inaam Munir, Commented Sep 14, 2018 at 11:15

Sapna Bhayal · Accepted Answer · 2018-09-14 11:31:23Z

3

Please check this documentation https://laravel.com/docs/5.0/eloquent#querying-relations

According to documentation, you can change your code like this:

$products= Product::whereHas('Categories', function($q) use ($slug)
{
    $q->where('slug', $slug);

})->get();

edited Sep 14, 2018 at 11:31

Sapna Bhayal

8026 silver badges8 bronze badges

answered Sep 14, 2018 at 11:14

Muhammad Inaam Munir

1,26010 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I replace raw query to laravel format

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related