";
+ $sql = "SELECT text FROM projects
+ WHERE title = ?";
+ $result = $this->query($sql, "s", $_GET['project']);
+ if ($result = $result[0]['text']) {
+ $text = str_replace("class=\"exhibit\"", "class=\"exhibit\" style=\"display:block;\"", $result);
+ echo $text;
+ echo "
";
+ } else {
+ throw new notFound();
+ }
+ }
+}
+
+class page extends cms {
+ private $page = 1;
+ private $offset = 0;
+ private $notes_per_page = 4;
+ private $number_of_pages = 1;
+
+ public function __construct() {
+ parent::__construct();
+ $this->page_offset();
+ }
+
+ private function page_offset() {
+ $sql = "SELECT COUNT(*) FROM notes";
+ $result = $this->db->query($sql);
+ $result = $result->fetch_array();
+ $this->number_of_pages = ceil($result[0] / $this->notes_per_page);
+ if (isset($_GET['page']) && is_numeric($_GET['page'])) {
+ $this->page = (int) $_GET['page'];
+ } else {
+ throw new notFound();
+ }
+ if ($this->page > $this->number_of_pages) {
+ throw new notFound();
+ }
+ if ($this->page < 1) {
+ throw new notFound();
+ }
+ $this->offset = ($this->page - 1) * $this->notes_per_page;
+ }
+
+ public function display() {
+ $this->display_head();
+ echo "";
+ $sql = "SELECT date_posted, title, url, text
+ FROM notes ORDER BY date_posted DESC
+ LIMIT ?, ?";
+ $result = $this->query($sql, "ii",
+ $this->offset,
+ $this->notes_per_page);
+ foreach ($result as $row => $entry) {
+ $title = $entry['title'];
+ $url = '/note/' . $entry['url'];
+ $date_posted = explode("-", $entry['date_posted']);
+ $year_posted = $date_posted[0];
+ $month_posted = $date_posted[1];
+ $datetime_posted = explode(' ', $date_posted[2]);
+ $day_posted = $datetime_posted[0];
+ echo "
";
+ echo "
$year_posted/$month_posted/$day_posted/ $title ";
+ echo $entry['text'];
+ echo "
";
+ }
+ echo "
";
+ $this->write_navigation();
+ $this->display_close();
+ }
+
+ private function write_navigation() {
+ echo "";
+ echo "
$year_posted/$month_posted/$day_posted/ $title";
+ echo $entry['text'];
+ $this->write_navigation();
+ $this->display_close();
+ }
+
+ private function write_navigation() {
+ echo "
";
+ echo "
";
+ echo "
";
+ echo "notes /";
+ echo " ";
+ echo "
";
+ }
+}
+
+
+class archive extends cms {
+
+ public function __construct() {
+ parent::__construct();
+ }
+
+ private function check_exists() {
+ $sql = "SELECT COUNT(*) FROM notes
+ WHERE url = ?";
+ $results = $this->query($sql, "s", $_GET['note']);
+ if ($results[0]["COUNT(*)"] != 1) {
+ $this->not_found();
+ }
+ }
+
+ public function display() {
+ // this really needs its own pagination...
+ // there should be a class for that.
+ $this->display_head();
+ switch (true) {
+ case (isset($_GET['year']) && !isset($_GET['month'])
+ && !isset($_GET['day'])):
+ $sql = "SELECT title, url, date_posted, text
+ FROM notes WHERE YEAR(date_posted) = ?
+ ORDER BY date_posted DESC";
+ $result = $this->query($sql, "d",
+ $_GET['year']);
+ break;
+ case (isset($_GET['year']) && isset($_GET['month'])
+ && !isset($_GET['day'])):
+ $sql = "SELECT title, url, date_posted, text
+ FROM notes WHERE YEAR(date_posted) = ?
+ AND MONTH(date_posted) = ?
+ ORDER BY date_posted DESC";
+ $result = $this->query($sql, "dd",
+ $_GET['year'], $_GET['month']);
+ break;
+ case (isset($_GET['year']) && isset($_GET['month'])
+ && isset($_GET['day'])):
+ $sql = "SELECT title, url, date_posted, text
+ FROM notes WHERE YEAR(date_posted) = ?
+ AND MONTH(date_posted) = ?
+ AND DAY(date_posted) = ?
+ ORDER BY date_posted DESC";
+ $result = $this->query($sql, "ddd",
+ $_GET['year'], $_GET['month'],
+ $_GET['day']);
+ break;
+ }
+ if (count($result) >= 1) {
+ echo "
";
+ foreach ($result as $row => $entry) {
+ $title = $entry['title'];
+ $url = '/note/' . $entry['url'];
+ $date_posted = explode("-", $entry['date_posted']);
+ $year_posted = $date_posted[0];
+ $month_posted = $date_posted[1];
+ $datetime_posted = explode(' ', $date_posted[2]);
+ $day_posted = $datetime_posted[0];
+ echo "
";
+ echo "
$year_posted/$month_posted/$day_posted/ $title ";
+ echo $entry['text'];
+ echo "
";
+ }
+ echo "
";
+ $this->write_navigation();
+ } else {
+ echo "
";
+ echo "
sorry, nothing here ";
+ echo "
Empty set (0.00 sec) ";
+ }
+ $this->display_close();
+ }
+
+ private function write_navigation() {
+ echo "
";
+ echo "
";
+ echo "
";
+ // fill me in!
+ echo " ";
+ echo "";
+ }
+}
+
+
+class rss extends cms {
+ public function display() {
+ $result = $this->db->query("SELECT date_posted, title, text, url
+ FROM notes ORDER BY date_posted DESC
+ LIMIT 5");
+ echo <<
+
+ dylanstestserver.com/notes/rss
+ http://dylanstestserver.com/notes
+ dylanstestserver.com/notes/rss
+
+END_OF_ENTRY;
+ while ($entry = $result->fetch_object()) {
+ $title = $entry->title;
+ $date_posted = $entry->date_posted;
+ $url = "http://dylanstestserver.com/note/" . $entry->url;
+ $text = $entry->text;
+ $text = strip_tags($text);
+ $end_of_first_sentence = strpos($text, '.');
+ if ($end_of_first_sentence) {
+ $end_of_second_sentence = strpos($text, '.', ($end_of_first_sentence + 1));
+ if ($end_of_second_sentence) {
+ $description = substr($text, '0', ($end_of_second_sentence + 1));
+ } else {
+ $description = substr($text, '0', ($end_of_first_sentence + 1));
+ }
+ }
+ echo <<
+ $title
+ $url
+ $url
+ $description
+
+END_OF_ENTRY;
+ }
+ echo " ";
+ echo "";
+
+ }
+}
+
+
+class notFound extends Exception {
+ public function __construct() {
+ header("HTTP/1.0 404 Not Found");
+ ob_end_clean();
+ include("404.php");
+ exit();
+ }
+}
+
+## now actually do something:
+switch (cms::determine_type()) {
+ case "index":
+ $index = new index();
+ $index->display();
+ break;
+ case "project":
+ $project = new project();
+ $project->display();
+ break;
+ case "note":
+ $note = new note;
+ $note->display();
+ break;
+ case "page":
+ $page = new page;
+ $page->display();
+ break;
+ case "archive":
+ $archive = new archive;
+ $archive->display();
+ break;
+ case "rss":
+ $rss = new rss();
+ $rss->display();
+}
+
+?>