[mcrob]

Ok I learned that if you want to make a shopping cart, you should generate a session ID for that user that comes to your shopping cart. When he/she adds a product to the shopping cart, then store that session ID in a cookie then store that cookie on there computer, while the added products will be stored in the database with there session ID stored as well so when the user even turns off there computer, come back and there products are still stored in there shopping cart which is awesome. My question is how can I make it so if the user decides not to come back in like a month time, then delete there products off the database?

[php~pro]

Set up a crontab to purge all records that have been inactive for over 1 month or make a web based admin form to do this for you. Just create a recursive loop that runs until all files older than 1 month are deleted.

Search google for tutorials on Crontab or cron job. You may find 1 on phpfreaks.com

[mcrob]

Is there a way that I can use the date function where if it is pass 31 days then I can excute whatever command I want.

PHP Code:

<?php

$currentdate = date("y d m");

$olddate = "05 06 12";



$total = $currentdate - $olddate;

?>

the answer is 100 therefore the answer is wrong, the answer is suppose to be 1.
Can anyone guide me with some helpful suggestions. I dont really want to get into cron jobs.

[ben.periton]

What I have done in the past, is as part of the function to check if they already have a shopping cart or not, is to delete any shopping carts that are over 2 days old.

Using the time() function and a bit of maths, you can easily do it. Just make sure you store the times as the unixtimestamp.

PHP Code:

$delTime = '172800'; // 2 days ((60*60*24)*2)

$query = "DELETE * FROM shoppingCarts WHERE CreatedTime <".(time()-$delTime); 

[mcrob]

Originally Posted by XTech

PHP Code:

$delTime = '172800'; // 2 days ((60*60*24)*2) 

Hey thats cool. How did you get ((60*60*24)*2) ? What does each represent (eg: 60 = seconds, 60 = mins, 24 = hours, 2 = days) ?

please reply back

[ben.periton]

Checkout http://uk.php.net/time theres a lot of useful stuff there.
Yup, 60 seconds * 60 minutes * 24 hours gives you the number of seconds in day, which is what time() is based on.