ccah-assessment/db.php

16 lines
420 B
PHP

<?php
define("DB_HOST", "localhost");
define("DB_USER", "ccah_user");
define("DB_PASS", "e_NQ,S^#sW6X:;nV!Uw.my");
define("DB_NAME", "ccah_assessment");
$conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
if ($conn->connect_error) {
die("Database connection failed: " . $conn->connect_error);
}
// Mark expired tokens
$conn->query("UPDATE users SET expired = 1 WHERE expiry_date < NOW() AND expired = 0");
?>