Delete item from the table if it's date is passed

Question

Hey I have a table that every row contains several data and one of them is the date , I am trying to write a code in php that will run on the table and delete every row that its date have been expired for example if the date today is 06/01/2017 than every item that its date is smaller than today should be deleted, the thing is I don't really have an idea on how to write this function so if someone can send me a tutorial or example of how should I do it that will be great.

You have to tell use at least the table names, field names and show what you have done so far. What you try is very basic mysql syntax. — user3606329, Jan 06 '17 at 10:51

score 0 · Answer 1 · answered Jan 06 '17 at 10:53

DELETE FROM your_table WHERE your_date_column < NOW() for what concerns the SQL query... Then simply use PDO to execute it

Your question actually is quite general, sounds like homework... Otherwise, posting some code attempts is appreciated as much as showing you did try / make some research beforehand. :)

score 0 · Answer 2 · answered Jan 06 '17 at 10:58

You'll need to create a page that sets tomorrow's date and executes the mysql command:

$conn = new mysqli($db_servername, $db_username, $db_password, $db_dbname);
if ($conn->connect_error) { } 

$tomorrow = new DateTime('tomorrow');
$tomorrow->format('Y-m-d');

$sql = "DELETE FROM 'yourtable' WHERE Date < '{$tomorrow}'";
$result = $conn->query($sql);

score 0 · Answer 3 · answered Jan 06 '17 at 10:59

0

you can use this query for delete past records

mysql> delete from your_table where date < curdate();

answered Jan 06 '17 at 10:59

denny

2,084
2
15
19

Delete item from the table if it's date is passed

3 Answers3