+
+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 "<div id=\"notes\">";
+ 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 "<div class=\"note\">";
+ echo "<h2><span style=\"color:grey;\">$year_posted/$month_posted/$day_posted/</span><a href=\"$url\">$title</a></h2>";
+ echo $entry['text'];
+ echo "</div>";
+ }
+ echo "</div>";
+ $this->write_navigation();
+ } else {
+ echo "<br>";
+ echo "<h2 style=\"font-family:sans-serif;\">sorry, nothing here</h2>";
+ echo "<pre>Empty set (0.00 sec)</pre>";
+ }
+ $this->display_close();
+ }
+
+ private function write_navigation() {
+ echo "<br>";
+ echo "<div id=\"navigation\">";
+ echo "<h2>";
+ // fill me in!
+ echo "</h2>";
+ echo "</div>";
+ }
+}
+
+
+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 <<<END_OF_ENTRY
+ <rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
+ <channel>
+ <title>dylanstestserver.com/notes/rss</title>
+ <link>http://dylanstestserver.com/notes</link>
+ <description>dylanstestserver.com/notes/rss</description>
+ <atom:link href="http://dylanstestserver.com/notes/rss" rel="self" type="application/rss+xml" />
+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 <<<END_OF_ENTRY
+ <item>
+ <title>$title</title>
+ <link>$url</link>
+ <guid>$url</guid>
+ <description>$description</description>
+ </item>
+END_OF_ENTRY;
+ }
+ echo "</channel>";
+ echo "</rss>";
+
+ }
+}
+
+