diff options
| -rw-r--r-- | design/database.sql | 1 | ||||
| -rw-r--r-- | htdocs/index.php | 23 | ||||
| -rw-r--r-- | htdocs/postings.php | 51 | ||||
| -rw-r--r-- | htdocs/src/Post.inc.php | 32 | ||||
| -rw-r--r-- | htdocs/src/PostIterator.inc.php | 20 |
5 files changed, 122 insertions, 5 deletions
diff --git a/design/database.sql b/design/database.sql index 8b9c13c..22daf7f 100644 --- a/design/database.sql +++ b/design/database.sql @@ -43,6 +43,7 @@ CREATE TABLE post ( category_id INTEGER UNSIGNED NOT NULL, created DATETIME NOT NULL, description TEXT NOT NULL, + location VARCHAR(100) NOT NULL, email VARCHAR(255) NOT NULL, secretid VARCHAR(32) NOT NULL, diff --git a/htdocs/index.php b/htdocs/index.php index 4777b05..a5f5456 100644 --- a/htdocs/index.php +++ b/htdocs/index.php @@ -8,11 +8,30 @@ * */ -require_once "src/config.inc.php"; +require_once "src/base.inc.php"; require_once "src/header.inc.php"; -echo "Content"; +echo "<h2>Recent Posts</h2>"; + +// Get all recent, approved posts. +$posts = new PostIterator(); +$posts->filterStage('approved'); +$posts->limit(5); +$posts->query(); + +if ($posts->valid()) { + foreach ($posts as $id => $post) { + printf("<div class=\"post\"><p><a href=\"postings/%s.html\">%s</a></p>" + . "<div class=\"desc\"><span class=\"location\">%s</span>" + . " <span class=\"age\">%s</span></div></div>", + + $id, $post->getName(), $post->getLocation(), $post->getAge()); + } + +} else { + echo "<p>No recent posts.</p>"; +} require_once "src/footer.inc.php"; diff --git a/htdocs/postings.php b/htdocs/postings.php new file mode 100644 index 0000000..c6f53d5 --- /dev/null +++ b/htdocs/postings.php @@ -0,0 +1,51 @@ +<?php + +/* Foursquare Community Site + * + * Copyright (C) 2011 Foursquare Church. + * + * Developers: Jesse Morgan <jmorgan@foursquarestaff.com> + * + */ + +require_once "src/base.inc.php"; + +require_once "src/header.inc.php"; + + +// Make sure we had a path info +if (!isset($_SERVER['PATH_INFO'])) { + errorNotFound(); +} + +// Clean up the id in the path info. +$id = substr($_SERVER['PATH_INFO'], 1, strpos($_SERVER['PATH_INFO'], '.') - 1); + +if (!is_numeric($id)) { + errorNotFound(); +} + +// Get the post. +$post = Post::getById($id); + +if (!$post) { + errorNotFound(); +} + +// Display the post. + +echo "<h2>". $post->getName() ."</h2>"; + +echo "<p>". $post->getDescription() ."</p>"; + + + +require_once "src/footer.inc.php"; + +function errorNotFound() { + // TODO: Better 404 error + echo "404"; + exit; +} + +?> diff --git a/htdocs/src/Post.inc.php b/htdocs/src/Post.inc.php index a4d34f7..22d2fce 100644 --- a/htdocs/src/Post.inc.php +++ b/htdocs/src/Post.inc.php @@ -31,7 +31,7 @@ class Post { } private static function getPost($where) { - $query = "SELECT * FROM post WHERE $where"; + $query = "SELECT *, UNIX_TIMESTAMP(created) AS createdts FROM post WHERE $where"; $db = getDatabase(); @@ -59,7 +59,11 @@ class Post { } public function getName() { - return $this->info['name']; + return htmlspecialchars($this->info['name']); + } + + public function getDescription() { + return htmlspecialchars($this->info['description']); } public function getStage() { @@ -77,6 +81,30 @@ class Post { public function getCreated() { return $this->info['created']; } + + public function getAge() { + $diff = time() - $this->info['createdts']; + + if ($diff < 60) { + return floor($diff) ." seconds ago"; + + } else if ($diff < 3600) { + return floor($diff / 60) ." minutes ago"; + + } else if ($diff < 86400) { + return floor($diff / 3600) ." hours ago"; + + } else if ($diff < 604800) { + return floor($diff / 86400) ." days ago"; + + } else { + return floor($diff / 604800) . " weeks ago"; + } + } + + public function getLocation() { + return $this->info['location']; + } } ?> diff --git a/htdocs/src/PostIterator.inc.php b/htdocs/src/PostIterator.inc.php index 6106f23..52eb750 100644 --- a/htdocs/src/PostIterator.inc.php +++ b/htdocs/src/PostIterator.inc.php @@ -14,11 +14,15 @@ class PostIterator implements Iterator { private $where; private $rows; private $position; + private $order; + private $limit; public function __construct() { $this->where = array(); $this->rows = array(); $this->position = 0; + $this->order = "created desc"; + $this->limit = 0; } public function filterStage($stage) { @@ -29,6 +33,14 @@ class PostIterator implements Iterator { $this->where[] = "source_id='$source'"; } + public function orderBy($order) { + $this->order = $order; + } + + public function limit($limit) { + $this->limit = limit; + } + public function rewind() { $this->position = 0; } @@ -50,13 +62,19 @@ class PostIterator implements Iterator { } public function query() { - $query = "SELECT * FROM post"; + $query = "SELECT *, UNIX_TIMESTAMP(created) AS createdts FROM post"; if (count($this->where) > 0) { $where = join(' AND ', $this->where); $query .= " WHERE $where"; } + $query .= " ORDER BY ". $this->order; + + if ($this->limit != 0) { + $query .= " LIMIT ". $this->limit; + } + $db = getDatabase(); $this->rows = $db->fetchAssocRows($query); |