2 mysql_connect('localhost', 'dylan', 'password') or die(mysql_error());
3 mysql_select_db('dylanstestserver') or die(mysql_error());
4 $sql = "SELECT COUNT(*) FROM notes";
5 $result = mysql_query($sql);
6 $result = mysql_fetch_row($result);
7 $number_of_notes = $result[0];
9 $total_number_of_pages = ceil($number_of_notes/$notes_per_page);
10 if (isset($_GET['note'])) {
11 $note = mysql_real_escape_string($_GET['note']);
12 $sql = "SELECT title, date_posted, text
13 FROM notes WHERE url=\"$note\"";
14 $result = mysql_query($sql) or die(mysql_error());
15 while($note = mysql_fetch_array($result)) {
16 echo "<div class=\"note\">";
17 $title = $note['title'];
18 $date_posted = explode("-", $note['date_posted']);
19 $year_posted = $date_posted[0];
20 $month_posted = $date_posted[1];
21 $day_posted = $date_posted[2];
22 echo "<h2><span style=\"color:grey;\">$year_posted/$month_posted/$day_posted/</span>$title</h2>";
27 if (isset($_GET['page']) && is_numeric($_GET['page'])) {
28 $page = (int) $_GET['page'];
34 } else if ($page > $total_number_of_pages) {
35 $page = $total_number_of_pages;
37 $page_offset = ($page - 1) * $notes_per_page;
38 $notes = mysql_query("SELECT title, date_posted, text, url
39 FROM notes ORDER BY date_posted DESC
40 LIMIT $page_offset, $notes_per_page");
41 while($note = mysql_fetch_array($notes)) {
42 echo "<div class=\"note\">";
43 $title = $note['title'];
44 $date_posted = explode("-", $note['date_posted']);
45 $year_posted = $date_posted[0];
46 $month_posted = $date_posted[1];
47 $day_posted = $date_posted[2];
49 echo "<h2><span style=\"color:grey;\">$year_posted/$month_posted/$day_posted/</span><a href=\"note/$url\">$title</a></h2>";
55 if(!$page == 2 && $total_number_of_pages == 2)
56 echo "<a href=\"{$_SERVER['PHP_SELF']}/page/1\">first</a> / ";
57 $previous_page = $page - 1;
58 echo "<a href=\"notes/page/$previous_page\">prev</a>";
60 if($page < $total_number_of_pages) {
61 $forward_page = $page +
1;
62 echo "<a href=\"notes/page/$forward_page\">next</a>";
64 if($page != $total_number_of_pages && (!$page == 1 && $total_number_of_pages == 2)){
65 echo " / <a href=\"notes/page/$total_number_of_pages\">last</a>";