mysqlasp-classicshopping-cartsession-storage
Persistant storage for 100+ items in a shopping cart
Can I use a MySQL database session storage table to save and restore a shopping cart with over 100 products in it on a site that was built with Classic ASP?
Solution
I recommend: In your database table, create a field to uniquely identify the user. Perhaps a string type for email address? Or if you are going further, "ID_user". This will allow your user to call up their "wishlist" or "saved cart" when they come back to the site. See tables in image below called users, cart, cart_details, wishlist, etc.
Here is a snapshot of a database I designed for a CMS that has a shopping cart and wishlist. Hope it helps!
- Duplicate key error after adding data in a table with seeded entities
- Get count of id for each day and Group by date
- How can I replace a string in a MySQL database for all tables in all fields in all rows?
- Run sql file in database from terminal
- What is the best way to do incremental backups in MySQL?
- How do I set MyISAM as default table handler in MySQL?
- Sequilize query is returning only one row while using include
- MySQL Error: #1142 - SELECT command denied to user
- MySQL Not Equal To Certain Length
- How to disable secure_file_priv in MySQL 8.0 in windows 10 machine?
- Php mysql query update of data gives syntax error
- How to retrieve a lot of data in my asp .NET app efficiently?
- Update an existing sql table based on content from an external csv file?
- Error: select command denied to user '<userid>'@'<ip-address>' for table '<table-name>'
- winMySQL query fails on Ubuntu instance but works with Windows instance
- How to connect from VSCode to a mysql docker container?
- SQL syntax error when trying to create a new table using TypeORM
- How do I convert text entered in form to Title Case Using PHP before submitting to MySQL?
- How to declare a variable in MySQL?
- MySQL Paging and Return Total
- How to drop columns in a table, where column names are "index" and " Unnamed: 0" in mysql
- How to deal with enormous line lengths created by mysqldump
- MySQL union - alias not visible
- Join newest price from price-table for all products
- Mysql ERROR: ASCII '\0' while importing sql file on linux server
- User registration with CodeIgniter
- Paging Results: Handling invalid passed data
- I'm stuck with foreign key constraint fails error. .NET 8, EF Core 8.0.2
- find number of rows in returned mysql result (nodejs)
- Get records that have total count of over X amount