/PHP/Show user only those products which he hasn't buyed laravel eloquent

Show user only those products which he hasn't buyed laravel eloquent

$user_id = auth()->user()->id;

Product::where('status', 'active')
  ->whereNotIn('id', function($query) use ($user_id) {
    $query->select('product_id')->from((new OrderProduct)->getTable())
      ->where('user_id', $user_id)->where('status', 'delivered')
		->pluck('product_id')->toArray();
  });

Similar codes

5 votes313 views2 answers
Laravel 8 routes namespace
PHP
1 vote263 views1 answer
Php unset multiple values
PHP
4 votes304 views4 answers
How to connect to a database in php
PHP
9 votes335 views6 answers
Php add days to date
PHP
51 votes448 views6 answers
Laravel run all seeders
PHP Laravel
0 vote367 views1 answer
Laravel empty query result
PHP Laravel
2 votes297 views1 answer
Laravel-ckeditor
PHP
33 votes298 views6 answers
Post php
PHP
0 vote496 views1 answer
Schema key issue laravel
PHP Laravel
2 votes377 views1 answer
Check if value is not null in db laravel
PHP Laravel