How can PHP developers efficiently delete records older than a year from a database using PDO?

To efficiently delete records older than a year from a database using PDO, you can use a combination of SQL's DATE_SUB function and PHP's date function to calculate the date one year ago. Then, you can execute a DELETE query with a WHERE clause to delete the records older than that date. 

<?php

// Connect to the database
$pdo = new PDO('mysql:host=localhost;dbname=your_database', 'username', 'password');

// Calculate the date one year ago
$one_year_ago = date('Y-m-d', strtotime('-1 year'));

// Prepare and execute the DELETE query
$stmt = $pdo->prepare("DELETE FROM your_table WHERE date_column < :one_year_ago");
$stmt->bindParam(':one_year_ago', $one_year_ago);
$stmt->execute();

echo "Records older than a year have been successfully deleted.";

?>

Keywords

PHP PDO database delete records

Related Questions