Recently, I delved into the world of PHP and database management about a month ago. Luckily, most of my issues were resolved through diligent Google searches.
Currently, I am working on creating an admin feature that allows for the deletion of entries older than a specified number of days. However, I suspect there may be an issue with my PDO syntax, particularly with the part involving ':days'.
Here is the snippet of PHP code:
$backsite = $_SERVER['PHP_SELF'];
if (isset($_POST['days'])) {
$days = $_POST['days'];
$statement = $db->prepare("DELETE FROM $tbl_name WHERE date < DATE_SUB(NOW(), INTERVAL :days DAY)");
$statement->execute(array(':days' => $days));
}
And here's the corresponding HTML form:
<form method="post" action="' . $backsite .'">
<input type="number" min="7" max="90" placeholder="7" required="" name="days"/>
<input type="submit" name="delete" value="Delete" />
</form>
An error message is being displayed:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DAYS)' at line 1' in /Applications/XAMPP/xamppfiles/htdocs/skiss/archive.php:10 Stack trace: #0 /Applications/XAMPP/xamppfiles/htdocs/skiss/archive.php(10): PDOStatement->execute(Array) #1 {main} thrown in /Applications/XAMPP/xamppfiles/htdocs/skiss/archive.php on line 10