<?php

//Вывод категорий в сайдбаре
$categories = get_category($connect);
//Получение ID категории и присвоение в переменную
$category_id = $_GET['id'];
//Вывод постов по категории
if(isset($_GET['page'])){
	$page = (int)$_GET['page'];
} else {
	$page = 1;
}
	$notesOnPage = 3; //Количество выводимых записей
	$from = ($page - 1) * $notesOnPage; //Перебор записей
  //Запрос в БД
	$category_id = mysqli_real_escape_string($connect, $category_id);
	$sql = "SELECT * FROM posts ORDER BY id DESC WHERE category_id = ".$category_id;
	$result = mysqli_query($connect, $sql);
	$posts = mysqli_fetch_all($result, MYSQLI_ASSOC);
	$sql = "SELECT COUNT(*) as count FROM posts WHERE category_id = ".$category_id;
	$result = mysqli_query($connect, $sql);
	$count = mysqli_fetch_assoc($result)['count'];
	$pagesCount = ceil($count / $notesOnPage);
	?>