<?php

include_once 'Thread.php';

class Post
{
	public $id;
	public $content;
	public $date_created;
	public $date_edited;
	public $thread;
	public $author;

	function get_from_database($id): bool
	{
		$sql = "SELECT post_content, post_date_created, post_date_edited, post_thread, post_author FROM posts WHERE post_id = ?;";
		$result = Database::get()->query($sql, "i", $id);

		if (empty($result)) {
			return false;
		}

		$this->id = $id;
		$this->content = $result[0]['post_content'];
		$this->date_created = $result[0]['post_date_created'];
		$this->date_edited = $result[0]['post_date_edited'];

		$this->thread = new Thread();
		$this->thread->get_from_database($result[0]['post_thread']);

		$this->author = new User();
		$this->author->get_by_id($result[0]['post_author']);

		return true;
	}
}