Re: deleting carts

Although it is probably easiest for you to manage this with php, It makes more sense to me to write a script that is managed by cron (php if you really want) that is executed on a regular basis w/out affecting any users browser latency. If each customer has to wait a little longer, you're going to have less happy customers. The latency should be trivial, but "should" usually means gottcha. For whatever database your using, there should be a simple solution for executing scripts which you could place in a cron job. PHP should be overkill. However, if you insist on PHP, you can compile up the cgi module which doesn't require a browser. Others have suggested executing a php script with lynx via cron. Although... Firing up lynx to talk to apache to execute a php script, to issue a database command sounds like a lot of overkill to me. Especially when this is simpler to create and maintain: $ mysql --execute "delete from carts where timestamp > now() + 36000" -- Have fun, -Joe ""Jorge Santos"" <santos@net-lynx.com> wrote in message news:002e01c09ee4$f1754360$7fe684ce@pseg.com... > Hi Nick, > > Of course it's possible. Anything is possible. Simply generate a simple PHP > script that will be executed from the command line which is called from a > cron. The PHP script would simple delete any records where (current date) - > (your date_added) >= 90 days. > > On the other hand, on the shopping cart that I wrote, I did it another way; > instead of creating a separate script and additional external components > (the cron for example), simple create 1 function that holds the > functionality needed to delete the old records. Then just call the function > each time your cart script is called. There's no reason to create a cron to > delete records because you can have the shopping cart script do it > automatically... > > > Hope this helps, > Jorge > santos@net-lynx.com > ----- Original Message ----- > From: Nicholas W. Miller <nick@webzeit.com> > To: <php-db@lists.php.net> > Sent: Saturday, February 24, 2001 11:31 PM > Subject: [PHP-DB] deleting carts > > > > I am developing a shopping cart style e-commerce web site. I have a > > table called carts that holds users' cart items ... so one user may > > have several entries in this table: > > > > +----------------+--------------+------+-----+---------+-------+ > > | Field | Type | Null | Key | Default | Extra | > > +----------------+--------------+------+-----+---------+-------+ > > | cust_id | int(11) | | | 0 | | > > | item_id | int(11) | YES | | NULL | | > > | qty | tinyint(4) | YES | | NULL | | > > | price | float(10,2) | YES | | NULL | | > > | date_added | timestamp(6) | YES | | NULL | | > > +----------------+--------------+------+-----+---------+-------+ > > > > I would like to write a PHP script that I will cron which will delete > > all items belonging to a user if their most recent item is over 90 > > days old. > > > > Is this possible? > > > > Nick > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >