<?php

include_once 'Category.php';

class Thread {
	public $id = 0;
	public $subject = 'Unknown thread';
	public $date_created = 0;
	public $date_lastpost = 0;
	public $category;
	public $author;

	function get_from_database($id, $dbc) {
		$sql = "SELECT thread_subject, thread_date_created, thread_date_lastpost, thread_category FROM threads WHERE thread_id = " . mysqli_real_escape_string($dbc, $id);
		$result = mysqli_query($dbc, $sql);
	
		if (!$result) {
			die('Error trying to display thread page: ' . mysqli_error($dbc));
		}
	
		if (mysqli_num_rows($result) == 0) {
			
		} else {
			while ($row = mysqli_fetch_assoc($result)) {
				$this->id = $id;
				$this->subject = $row['thread_subject'];
				$this->date_created = $row['thread_date_created'];
				$this->date_lastpost = $row['thread_date_lastpost'];

				$this->category = new Category();
				$this->category->get_from_database($row['thread_category'], $dbc);
			}
		}
	}
}