Answers for "show user only those products which he hasn't buyed laravel eloquent"

PHP
1

show user only those product which he hasn't buyed laravel eloquest

$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();
  });
Posted by: Guest on June-26-2020
0

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();
  });
Posted by: Guest on June-26-2020

Code answers related to "show user only those products which he hasn't buyed laravel eloquent"

Browse Popular Code Answers by Language