added powermate css
[dylansserver.git] / model / page.php
1 <?php
2
3 class page extends model {
4
5 public $page = 1;
6 public $offset = 0;
7 public $notes_per_page = 4;
8 public $number_of_pages = 1;
9
10 public function __construct() {
11 parent::__construct();
12 $this->page_offset();
13 }
14
15 private function page_offset() {
16 $sql = "SELECT COUNT(*) FROM notes";
17 $result = $this->db->query($sql);
18 $result = $result->fetch_array();
19 $this->number_of_pages = ceil($result[0] / $this->notes_per_page);
20 if (isset($_GET['page']) && is_numeric($_GET['page'])) {
21 $this->page = (int) $_GET['page'];
22 } else {
23 throw new notFound();
24 }
25 if ($this->page > $this->number_of_pages) {
26 throw new notFound();
27 }
28 if ($this->page < 1) {
29 throw new notFound();
30 }
31 $this->offset = ($this->page - 1) * $this->notes_per_page;
32 }
33
34 public function display() {
35 require_once("view/page.php");
36 }
37
38 public function display_notes() {
39 echo "<div id='notes'>";
40 $sql = "SELECT date_posted, title, url, text
41 FROM notes ORDER BY date_posted DESC
42 LIMIT ?, ?";
43 $result = $this->query($sql, "ii",
44 $this->offset,
45 $this->notes_per_page);
46 foreach ($result as $row => $entry) {
47 $title = $entry['title'];
48 $url = '/note/' . $entry['url'];
49 $date_posted = explode("-", $entry['date_posted']);
50 $year_posted = $date_posted[0];
51 $month_posted = $date_posted[1];
52 $datetime_posted = explode(' ', $date_posted[2]);
53 $day_posted = $datetime_posted[0];
54 $text = $entry['text'];
55 echo <<<END_NOTE
56 <div class='note'>
57 <h1>
58 <span class='date'>$year_posted/$month_posted/$day_posted/</span><a rel="canonical" href='$url'>$title</a>
59 </h1>
60 $text
61 </div>
62 END_NOTE;
63 }
64 echo "</div>";
65 }
66 }
67
68 ?>