Deleting from MYSQL Database after 7 days?

Ben · 14th June 2005, 02:53 PM

Hey there,

I have created a shopping cart. When someone adds items to the cart it logs their order id and the time(using the time() function) they added the items.

The problem is when someone adds items to their cart and does not check out, the order is left sitting in the database... Over time this will be a lot of orders cloggin the database with out of date data...

How do I check the MYSQL database for entries over 7 days old and then delete them?

Thanks

Ben

**Mr. Tech** · 15th June 2005, 09:42 AM

Here is some code that will do the trick:

PHP Code:


		
			
$days = 7*24*60*60; // Replace the 7 with the amount of days.

$now = time(); 

$expired = $now - $days; 

 

$query = mysql_query("SELECT orderid,time,bought FROM {$tbl_name}products_orders WHERE bought='no' AND time <= $expired") or die(mysql_error());

while($row = mysql_fetch_array($query)) {

mysql_query("delete from {$tbl_name}products_orders where orderid='$row[orderid]'");

}