<?php
include_once('init.php');

$mysqli = new mysqli($db['host'], $db['user'], $db['pass'], $db['name']);
if ($mysqli->connect_errno) {
    echo "Не удалось подключиться к MySQL: " . $mysqli->connect_error;
}

if (!($stmt = $mysqli->prepare("SELECT posts.post_id, posts.user_id, users.user_login, posts.post_text, posts.post_time, posts.is_deleted
								FROM posts JOIN users on users.user_id = posts.user_id ORDER BY post_id"))) {
    echo "Не удалось подготовить запрос: (" . $mysqli->errno . ") " . $mysqli->error;
}

if (!$stmt->execute()) {
    echo "Не удалось выполнить запрос: (" . $stmt->errno . ") " . $stmt->error;
}

$queryResult = $stmt->get_result();

$posts = $queryResult->fetch_all(MYSQLI_ASSOC);

//echo "<pre>";
//var_dump($posts);

if (isset($_SESSION['user_login'])) {	
	$userName = $_SESSION['user_login'];	
	$userId = $_SESSION['user_id'];
} else {
	$userId = 'null';
}

include ('view.php');
?>