diff options
Diffstat (limited to 'model/Thread.php')
| -rw-r--r-- | model/Thread.php | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/model/Thread.php b/model/Thread.php new file mode 100644 index 0000000..78d2614 --- /dev/null +++ b/model/Thread.php @@ -0,0 +1,35 @@ +<?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); + } + } + } +}
\ No newline at end of file |