admin_purge.php

<?php


if ($_SERVER['REQUEST_METHOD'] == "POST") {
    if ($_POST['purge'] == 'purge') {
        db_execute("DELETE FROM `password_resets` WHERE expiration < ?", [time()]);
        db_execute("DELETE FROM `tokens` WHERE expiry < ?", [time()]);
    }
}

$expired_password_resets = db_execute("SELECT * FROM `password_resets` WHERE expiration < ?", [time()]);
$expired_tokens = db_execute("SELECT * FROM `tokens` WHERE expiry < ?", [time()]);

?>



<h1>Purge</h1>
<form method="post">
    <p>
        <button name="purge" value="purge" type="submit" class="primary">Purge</button>
    </p>
</form>

<h2>Expired password resets</h2>
<pre><?php print_r($expired_password_resets) ?></pre>

<h2>Expired Login tokens</h2>
<pre><?php print_r($expired_tokens) ?></pre>