latest.php

   1 <?php
   2
   3 /*  miniqdb - A minimalistic quote database
   4     Copyright (C) 2008  Ian Weller <ianweller@gmail.com>
   5
   6     This program is free software; you can redistribute it and/or modify
   7     it under the terms of the GNU General Public License as published by
   8     the Free Software Foundation; either version 2 of the License, or
   9     (at your option) any later version.
  10
  11     This program is distributed in the hope that it will be useful,
  12     but WITHOUT ANY WARRANTY; without even the implied warranty of
  13     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  14     GNU General Public License for more details.
  15
  16     You should have received a copy of the GNU General Public License along
  17     with this program; if not, write to the Free Software Foundation, Inc.,
  18     51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. */
  19
  20 require "header.php";
  21
  22 $st = $db->query("SELECT id,quote FROM miniqdb ORDER BY id DESC LIMIT 10");
  23
  24 foreach ($st->fetchAll() as $r) {
  25         echo '<div class="quote">';
  26         echo '<pre><a href="quote.php?id=' . $r['id'] . '">#' . $r['id'] . "</a>\n";
  27         echo $r['quote'];
  28         echo '</pre></div>';
  29 }
  30
  31 echo $footer;
  32
  33 ?>