notes/notes.php

   1 <?php
   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];
   9   $notes_per_page = 4;
  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>";
  24           echo $note['text'];
  25           echo "</div>";
  26         }
  27   } else {
  28     if (isset($_GET['page']) && is_numeric($_GET['page'])) {
  29       $page = (int) $_GET['page'];
  30     } else {
  31       $page = 1;
  32     }
  33     if ($page < 1) {
  34       $page = 1;
  35     } else if ($page > $total_number_of_pages) {
  36       $page = $total_number_of_pages;
  37     }
  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];
  49           $url = $note['url'];
  50       echo "<h2><span style=\"color:grey;\">$year_posted/$month_posted/$day_posted/</span><a href=\"/dylanstestserver/notes/$url\">$title</a></h2>";
  51           echo $note['text'];
  52           echo "</div>";
  53     }
  54     echo "<h2>";
  55     if($page != 1){
  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>";
  60     }
  61     if($page < $total_number_of_pages) {
  62       $forward_page = $page + 1;
  63       echo "<a href=\"/dylanstestserver/notes/page/$forward_page\">next</a>";
  64     }
  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>";
  67     }
  68     echo "</h2>";
  69   }
  70 ?>