| Contents | ' . $message["contents"]; echo ' (' . format_timestamp(time() - strtotime($message["sent_at"])) . ' ago)'; echo ' | '; echo ''; if ($message["link"]) { echo '[ View ]'; } echo ' | '; echo ''; } ?>
|---|
prepare("SELECT * FROM inbox_messages WHERE recipient_id = ? ORDER BY sent_at DESC"); $stmt->execute([$_SESSION["user_id"]]); $messages = $stmt->fetchAll(PDO::FETCH_ASSOC); $stmt = $db->prepare("UPDATE inbox_messages SET has_read = true WHERE recipient_id = ?"); $stmt->execute([$_SESSION["user_id"]]); ?>
| Contents | ' . $message["contents"]; echo ' (' . format_timestamp(time() - strtotime($message["sent_at"])) . ' ago)'; echo ' | '; echo ''; if ($message["link"]) { echo '[ View ]'; } echo ' | '; echo ''; } ?>
|---|