index.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 echo "<p>displaying random 20 or so quotes</p>";
  22
  23 // we take '20 or so' literally
  24 $limit = mt_rand(18, 22);
  25
  26 $st = $db->query("SELECT id,quote FROM miniqdb ORDER BY RAND() LIMIT $limit");
  27
  28 foreach ($st->fetchAll() as $r) {
  29         echo '<div class="quote">';
  30         echo '<pre><a href="quote.php?id=' . $r['id'] . '">#' . $r['id'] . "</a>\n";
  31         echo $r['quote'];
  32         echo '</pre></div>';
  33 }
  34
  35 echo $footer;
  36
  37 ?>