Post by hotwebideas » Thu Sep 15, 2011 2:06 am

Loving OpenCart's Admin and shopping cart, it looks like I will need to totally redesign the checkout page as our customers will simply need to a quick checkout, but I would like to save the order as usual. I do not need a lot of other features. I also do not need to worry about zoning, shipping, or payment, anything like that.

I would just like the customer to check out and get a conformation order.

What I would like to know is where exactly the items are saved when someone adds a product to their shopping cart? Is it a database table, a cookie, a session?

Please help.

New member

Posts

Joined
Wed Jun 29, 2011 11:44 pm

Post by Xsecrets » Thu Sep 15, 2011 2:11 am

It saves it to a session. If you are a logged in customer it also saves it to the db.

OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter


Guru Member

Posts

Joined
Sun Oct 25, 2009 3:51 am
Location - FL US

Post by hotwebideas » Thu Sep 15, 2011 2:14 am

Thanks, xsecrets. What DB table is it saved to before the customer checks out?

New member

Posts

Joined
Wed Jun 29, 2011 11:44 pm

Post by uksitebuilder » Thu Sep 15, 2011 6:49 pm

customer table, cart column

User avatar
Guru Member

Posts

Joined
Thu Jun 09, 2011 11:37 pm
Location - United Kindgom

Post by hotwebideas » Thu Sep 15, 2011 10:07 pm

Thanks, Simon, but I looked at the cart column in the customer table and what I see is this for the data:

a:3:{i:76;i:10;s:47:"83:YToxOntpOjI1MDthOjE6e2k6MDtzOjM6IjExMiI7fX0=";i:10;i:73;i:10;}

How can I decipher that to see all the cart details? Is there some PHP function or do I need to explode some array?

New member

Posts

Joined
Wed Jun 29, 2011 11:44 pm

Post by Qphoria » Thu Sep 15, 2011 10:26 pm

hotwebideas wrote:Thanks, Simon, but I looked at the cart column in the customer table and what I see is this for the data:

a:3:{i:76;i:10;s:47:"83:YToxOntpOjI1MDthOjE6e2k6MDtzOjM6IjExMiI7fX0=";i:10;i:73;i:10;}

How can I decipher that to see all the cart details? Is there some PHP function or do I need to explode some array?
You have to use php's unserialize() function

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by hotwebideas » Thu Sep 15, 2011 10:30 pm

Qphoria wrote:
hotwebideas wrote:Thanks, Simon, but I looked at the cart column in the customer table and what I see is this for the data:

a:3:{i:76;i:10;s:47:"83:YToxOntpOjI1MDthOjE6e2k6MDtzOjM6IjExMiI7fX0=";i:10;i:73;i:10;}

How can I decipher that to see all the cart details? Is there some PHP function or do I need to explode some array?
You have to use php's unserialize() function
Thanks Q!

New member

Posts

Joined
Wed Jun 29, 2011 11:44 pm

Post by sarahadam » Sun Mar 11, 2018 9:48 pm

Sorry for the english,
opencart use session to add in shopping cart but in customer table I found cart column inside it the data about shopping cart
I want to insert data direct to this column and read data from this column how i do this?
I know about serialize and base64 to insert data but I can't insert data in this column in same format??

Newbie

Posts

Joined
Mon Feb 12, 2018 4:04 am
Who is online

Users browsing this forum: No registered users and 14 guests