How to use a SQL statement in controller laravel using AND clause

Question

This is my piece of code

 $user_id = Auth::id();
        if(Cart::where('product_id', $product->id and 'user_id', $user_id) === null)
        {
            $cart = new Cart;
            $cart->product_id = $product->id;
            $cart->quantity = $request->get('quantity');
            $cart->user()->associate(Auth::user());
            $cart->save();
        }
        else
        {
    
        }

This code I know definitely works

$cart = new Cart;
$cart->product_id = $product->id;
$cart->quantity = $request->get('quantity');
$cart->user()->associate(Auth::user());
$cart->save();

The issue is somewhere in the if statement but I'm not sure what it is. I am trying to check the carts table in the database to see if there is a cart that already exists with the same product id and user ID. If it isn't, it creates a cart in the database. Here is my database table:

aynber · Accepted Answer · 2022-11-28 14:58:25Z

1

You need to break up your syntax into separate clauses.

Cart::where('product_id', $product->id)->where('user_id', $user_id)->first()

You can use ->first() to grab the first record, which is useful if you actually want to assign the value to a variable to use. Or you can use ->count() if you don't need to grab the record, and check to see if the count is equal to 0.

answered Nov 28, 2022 at 14:58

aynber

23.2k9 gold badges57 silver badges69 bronze badges

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

3 Comments

Tim Lewis Over a year ago

There's the ->exists() method too, which returns true or false based on if any record is found by the Query 🙂 (->count() works just fine too though, but I prefer the explicit true/false return of ->exists())

Dan Over a year ago

Thank you @aynber How would I go about updating a record in a database? If the product already exists, I want to increment the quantity by the specified amount in $request. Do i have the right idea with this code:

$cart = Cart::where('product_id', $product->id)->where('user_id', $user_id)->update('quantity', /*Get product quantity and increase by $request amount*/);

aynber Over a year ago

That's probably where assigning that query to a $cart value would come in. If the cart doesn't exist, create it, and if it does, increment it.

Collectives™ on Stack Overflow

How to use a SQL statement in controller laravel using AND clause

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related