prepare("
SELECT id, subject, body, created_at
FROM saved_emails
WHERE user_id = :user_id
ORDER BY created_at DESC
");
$stmt->execute([':user_id' => $user_id]);
$emails = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>
📑 Saved Emails
| Subject | Preview | Date | Action |
| = htmlspecialchars($email['subject'] ?: '(No Subject)') ?> |
= htmlspecialchars(substr($email['body'], 0, 50)) ?>... |
= $email['created_at'] ?> |
|
No saved emails yet.