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

$link = mysqli_connect($db['host'], $db['user'], $db['pass'], $db['name']);
$query = "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";

$queryResult = mysqli_query($link, $query) or die (mysqli_error($link));
//var_dump($queryResult);

$posts = mysqli_fetch_all($queryResult, MYSQLI_ASSOC);

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

include ('view.php');
?>