query("SELECT COUNT(*) as total FROM posts WHERE status = 'published'");
$row = $stmt->fetch();
$total_posts = $row['total'];
$total_pages = ceil($total_posts / $limit);
// Get posts - perbaikan query untuk MySQL versi lama
$stmt = $pdo->prepare("SELECT * FROM posts WHERE status = 'published' ORDER BY created_at DESC LIMIT ?, ?");
$stmt->bindValue(1, $offset, PDO::PARAM_INT);
$stmt->bindValue(2, $limit, PDO::PARAM_INT);
$stmt->execute();
$posts = $stmt->fetchAll();
// Update view count
if (isset($_GET['id'])) {
$stmt = $pdo->prepare("UPDATE posts SET view_count = view_count + 1 WHERE id = ?");
$stmt->execute([$_GET['id']]);
}
?>
COD178SLOT - Bukti JP Maxwin Setiap Hari
