Initially, from reading other threads, I thought that items, qty cart data was being saved in a cookie. Is this correct or is it being stored in the database somewhere? Just today I logged into a computer that I hadn't used before and logged in and there were already items in my cart - items that I had added when using another workstation.
Is the cart info located in the database somewhere and if so, what table?
Thanks in advance.
Is the cart info located in the database somewhere and if so, what table?
Thanks in advance.
OK, I see where it's stored in the db - duh. Can someone decode the syntax of how the data is stored in the field? Here are a couple examples of cart records:
the a I have no idea. The 1 and 3 at the beginning looks to be the number of cart items. It looks like in the top cart there's qty 20 of item #69. The second cart looks to have 100xitem#49, 10xitem#55 and 10xitem#59.
None of those use options but they all use discount pricing. Is that info stored in there or somewhere else or is the db being queried every time to display the correct pricing information?
What are the i's for?
Code: Select all
a:1:{i:69;i:20;}
Code: Select all
a:3:{i:49;i:100;i:55;i:10;i:59;i:10;}
None of those use options but they all use discount pricing. Is that info stored in there or somewhere else or is the db being queried every time to display the correct pricing information?
What are the i's for?
Qphoria, thanks for the reply. It could make sense to me. I figured out the qty and product id, didn't I?Qphoria wrote:php has a function called "serialize"
It basically takes an array and combines it into 1 line... kinda like a zip file
Similarly, you can unzip or "unserialize" that
But still even when unserialized it probably won't make much sense to you.
It is basically the product id, the options, and the qty
Is discount in there anywhere? In my setup, all prices are using a discount of some sort. Or is the DB queried every time to check to a discount whenever the cart prices are displayed?
I'm really looking to display the cart contents on a page outside of the OC system. I've gotten as far as getting the customer and their cart contents and qty but not prices. I could always just query the db to get the info but I was hoping the prices were stored elsewhere, possibly in the cart record. But it doesn't look like that's the case. Is that correct?
no prices are not stored anywhere for the cart. only the product id the qty and the options. everything else is queried each time.RJonesUSC wrote:Qphoria, thanks for the reply. It could make sense to me. I figured out the qty and product id, didn't I?Qphoria wrote:php has a function called "serialize"
It basically takes an array and combines it into 1 line... kinda like a zip file
Similarly, you can unzip or "unserialize" that
But still even when unserialized it probably won't make much sense to you.
It is basically the product id, the options, and the qty
Is discount in there anywhere? In my setup, all prices are using a discount of some sort. Or is the DB queried every time to check to a discount whenever the cart prices are displayed?
I'm really looking to display the cart contents on a page outside of the OC system. I've gotten as far as getting the customer and their cart contents and qty but not prices. I could always just query the db to get the info but I was hoping the prices were stored elsewhere, possibly in the cart record. But it doesn't look like that's the case. Is that correct?
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
Who is online
Users browsing this forum: No registered users and 209 guests