<?php
require_once __DIR__ . '/config/db.php';
$database = new Database();
$db = $database->getConnection();

$stmt = $db->query("SELECT id, media_type, schedule_time, is_sent, sent_at, sent_message_id FROM telegram_posts ORDER BY id DESC LIMIT 5");
$posts = $stmt->fetchAll(PDO::FETCH_ASSOC);

echo "System Time: " . date('Y-m-d H:i:s') . " [" . date_default_timezone_get() . "]\n";
echo json_encode($posts, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE);