prepare('SELECT COUNT(*) as total FROM news WHERE site_id = ?');$count_stmt->execute([SITE_ID]);$count_result = $count_stmt->fetch();$total = $count_result['total'];$total_pages = ceil($total / $per_page);// Жаңалықтарды алу$news_stmt = $pdo->prepare('SELECT * FROM news WHERE site_id = ? ORDER BY created_at DESC LIMIT ' . (int)$per_page . ' OFFSET ' . (int)$offset);$news_stmt->execute([SITE_ID]);$news_list = $news_stmt->fetchAll();?>