prepare("SELECT COUNT(*) FROM mails $whereSql");
$stmt->execute($params);
$total = $stmt->fetchColumn();
$totalPages = ceil($total / $perPage);
$stmt = $db->prepare("SELECT id, account, account_label, from_addr, subject, mail_date,
is_starred, is_important, is_read, attachments
FROM mails $whereSql
ORDER BY mail_ts DESC, id DESC
LIMIT $perPage OFFSET $offset");
$stmt->execute($params);
$mails = $stmt->fetchAll(PDO::FETCH_ASSOC);
$accounts = $db->query("SELECT DISTINCT account, account_label FROM mails ORDER BY account_label")
->fetchAll(PDO::FETCH_ASSOC);
$page_title = '收件箱';
$nav_active = 'index';
require __DIR__ . '/includes/header.php';
?>