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