How to update shopping cart?

[SaranacLake]

Hello.

I'm trying to figure out the most logical way to update my shopping cart (table).

When my checkout.php script loads, I need to run some checks on all cart items and take appropriate action.

For example, a "Trial Offer" is only available to non-Members, so if a Member somehow has a "Trial Offer" in his/her shopping cart then I'd like my checkout.php script to remove that automatically from the Member's cart.

So when checkout.php loads, one of the first things I do is to read the user's shopping cart items from the database.

But what is the most logical way to update the shopping cart table?

Do I load the shopping cart records into an array, then iterate through them, remove any non-applicable "Trial Offers" and then write things back to the shopping cart table?  (If so, then how do I merge things?  This is what is confusing me...)

Or do I somehow iterate through the shopping cart records for the user and update each record at a time and avoid loading things into memory like using an array?

Again, this seems like a simple enough task, but I'm not sure the smartest way to do things?!

 

[requinix]

I'm sorry but it sounds like you're saying that your application is letting in bad data: invalid items in a non-member's shopping cart. That's the problem, isn't it? So how about fixing that problem?

[SaranacLake]

10 minutes ago, requinix said:

I'm sorry but it sounds like you're saying that your application is letting in bad data: invalid items in a non-member's shopping cart. That's the problem, isn't it? So how about fixing that problem?

Actually, no, I'm just trying to be a good developer and checking twice!

Yes, if a Member lands on the "Trial Offer" page, that script will prevent them from adding the "Trial Offer" to their shopping cart.  But I figured it would be a good idea in my checkout.php script to do an inventory of things and make sure everything is legit before I move forward.  (Bad data has a crazy way of sneaking in place you never expect?!)

 

So back to my OP...

I was looking at some old old code, and it looks like I could just use PHP to iterate through the user's shopping cart records, and then I can update each record that I come across - without necessarily needing an array - right?  

 

 

Edited September 15, 2020 by SaranacLake