$param = $_GET['code'] ?? ''; if (!$param) { header("Location: ".SITE_URL."login.php"); exit(); } $currentDate = date('Y-m-d H:i:s'); $stmt = $db->query( "SELECT COUNT(1) jumlah FROM tbl_users a LEFT JOIN verification_temp b ON a.id = b.user_id WHERE b.code = :code AND b.expired_date >= :now AND a.verify_email = 0", [ ':code' => $param, ':now' => $currentDate ] ); $data = $stmt ? $stmt->fetch() : null; if (!$data || $data['jumlah'] == 0) { header("Location: ".SITE_URL."login.php?error=invalid_code"); exit(); }