p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 (http://p2p.wrox.com/forumdisplay.php?f=160)
-   -   shopping cart (http://p2p.wrox.com/showthread.php?t=28462)

xipnl April 22nd, 2005 10:34 AM

shopping cart

I'm a little confused about cart-abandonment. I made the cba shop with help of this book. It stores the shopping cart in a table in a database.
However in the exercises there is nothing said about the spam left in the temp database, the database fills up and if you have many visitors it fills up fast. What is the best way to deal with this problem, is there a script which knows when a user closes its browser and then deletes it's cart. The book says that it wants to save it for analysis, but if I keep it I must delete the entries weekly and I’m not really happy with that.


ElizabethN June 10th, 2005 07:00 PM

Sorry for the delay in responding to you- to delete the temp database on a regular basis, you could write a simple PHP program with a SQL statement that empties the table, then set up a cronjob to execute the program at determined intervals.

hope that helps!
Elizabeth Naramore

All times are GMT -4. The time now is 09:05 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.