- ";
$this->list_projects();
echo <<
- activehamptons.com
- transfishing.com
-
something i've worked on:
- tempositions.com
-
my repositories:
- git://dylansserver.com
-
some notes:
- here [rss]
- OTHER_PROJECTS; // Because of the CSS necessary for the animations, // the contact link needs to be in #portfolio to clear // the floats. echo "
- "; $this->display_contact(); echo " "; echo "
things i've done for others:
";
$sql = "SELECT text FROM projects";
$result = $this->db->query($sql);
while ($entry = $result->fetch_object()) {
echo $entry->text;
}
echo "
";
}
private function list_projects() {
echo <<my projects:
HEREDOC; $sql = "SELECT title FROM projects"; $result = $this->db->query($sql); while ($entry = $result->fetch_object()) { echo "";
$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();
$this->scripts = "
";
}
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];
$text = $entry['text'];
echo <<
END_NOTE;
}
echo "";
$this->write_navigation();
$this->display_close();
}
private function write_navigation() {
echo "";
}
}
class note extends cms {
private $id;
private $comments_enabled = false;
private $failed_captcha;
public $url;
public $title;
public $year_posted;
public $month_posted;
public $day_posted;
public $text;
public $number_of_comments;
public function __construct() {
$this->scripts = "
";
if (isset($_GET['comments'])) {
$this->scripts .= "
";
}
parent::__construct();
if (isset($_GET['comments'])) {
$this->comments_enabled = true;
}
$url = htmlspecialchars($_SERVER['REQUEST_URI']);
if (isset($_GET['verify'])) {
$url = substr($url, 0, (strlen($url)-6));
}
$this->url = $url;
$sql = "SELECT title, date_posted, text, id
FROM notes WHERE url = ?";
$result = $this->query($sql, "s",
$_GET['note']);
if ($result) {
$entry = $result[0];
$this->id = $entry["id"];
$this->title = $entry["title"];
$date_posted = explode("-", $entry["date_posted"]);
$this->year_posted = $date_posted[0];
$this->month_posted = $date_posted[1];
$datetime_posted = explode(' ', $date_posted[2]);
$this->day_posted = $datetime_posted[0];
$this->text = $entry["text"];
} else {
throw new notFound();
}
$sql = "SELECT COUNT(*) FROM comments
WHERE note = $this->id";
$result = $this->db->query($sql);
$result = $result->fetch_array();
$this->number_of_comments = $result[0];
if (isset($_GET['verify'])) {
$this->verify();
}
}
public function display() {
$this->display_head();
$this->display_note();
if ($this->comments_enabled) {
$this->display_comments();
$this->display_comment_form();
}
$this->write_navigation();
$this->display_close();
}
private function verify() {
if (!isset($_POST['captcha'])) {
require_once('includes/recaptchalib.php');
echo "$year_posted/$month_posted/$day_posted/$title
$text"; $resp = recaptcha_check_answer ($this->recaptcha_privatekey, $_SERVER["REMOTE_ADDR"], $_POST["recaptcha_challenge_field"], $_POST["recaptcha_response_field"]); if (!$resp->is_valid) { $this->failed_captcha = true; } } if (isset($_POST['captcha']) || $resp->is_valid) { $sql = ("INSERT INTO comments (date_posted, author, text, note) VALUES(NOW(), ?, ?, ?)"); $stmt = $this->db->prepare($sql); // Checks are needed here (no blank text, // and a default author needs to be set // for no-javascript users. $stmt->bind_param('sss', htmlspecialchars($_POST['name']), htmlspecialchars($_POST['text']), $this->id); $stmt->execute(); } } private function display_note() { echo <<
$this->year_posted/$this->month_posted/$this->day_posted/$this->title
$this->text END_OF_NOTE; } private function write_navigation() { echo <<END_OF_NAVIGATION; } private function display_comment_link() { if ($this->number_of_comments > 0) { $anchor_text = "comments($this->number_of_comments)/"; } else { $anchor_text = "comment?"; } if (substr($this->url, (strlen($this->url)-1), strlen($this->url)) == '/') { $url = $this->url . 'comments/'; } else { $url = $this->url . '/comments/'; } echo "$anchor_text"; } private function display_comments() { echo "
try again?
but you didn't write anything!
END_OF_ERRORS;
}
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 "
";
$this->write_navigation();
} else {
echo "";
echo "
";
}
echo ""; echo "$year_posted/$month_posted/$day_posted/"; echo "$title
"; echo $entry['text']; echo ""; echo "
$author
"; echo <<