PHP - How to auto delete using timestamp ?

mochatiffin

I have TIMESTAMP column named 'timestamp',i try to make auto delete after 1 seconds,but seems do not successful.

	$result_user_id = mysql_query("SELECT user_id,contact_number FROM user WHERE username = '$username'");

if($row = mysql_fetch_array($result_user_id)){
$user_id = $row['user_id'];
$phone = $row['contact_number'];
}

$resultz = mysql_query("SELECT * FROM booking WHERE date = '$date' AND time = '$time' AND courts = '$courts' ");
$cnt = mysql_num_rows($resultz);

if ($cnt>0) {
echo "<table width='100%'><td height='50' align='center' bgcolor='#85A157'><font size='4'><strong>The court are not available</strong></font></td></table>";
echo "<meta http-equiv='refresh' content='1;url=booking.php'>";
}
//if the court is still available store the data in booking table
else
{
	date_default_timezone_set("Asia/Kuala_Lumpur");
	$datetime = date("y-m-d H:i:s", time());
	$prevtime= $datetime-1;// want to try with 1 second first

$sql = "INSERT INTO booking(user_id,username,contact_number,courts,date,time) VALUES      ('$user_id','$username','$phone','$courts','$date','$time')";
$result = mysql_query($sql) or die (mysql_error());

$delBookAfter1hourNoReply ="DELETE FROM booking WHERE timestamp < '$prevtime' ";
$resultTimeStamp=mysql_query($delBookAfter1hourNoReply);

Cetera

Now you are trying to delete your bookings when timestamp is less then prevtime

$datetime = date("y-m-d H:i:s", time());
$prevtime = $datetime-1;// want to try with 1 second first

output 10

You are also trying to delete based on a date compared to timestamp this will ofc not work as expected.

I gather you want to delete the posts that is 1 hour old based on $delBookAfter1hourNoReply so:

$prevtime = time()-(60*60); // Will make a timestamp 1 hour back in time

you can also use http://uk3.php.net/manual/en/function.mktime.php to get the same result. Hope this will help you