quote.php

   1 <?php
   2
   3 /*  miniqdb - A simple quote database written in PHP
   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 if (!isset($_GET['id'])) {
  21         header('Location: index.php');
  22 }
  23
  24 $id = $_GET['id'];
  25
  26 require "header.php";
  27
  28 $st = $db->query("SELECT id,quote FROM miniqdb WHERE id=$id");
  29 if (!$st) {
  30         echo "<p>Quote $id doesn't exist.</p>";
  31 } else {
  32         foreach ($st->fetchAll() as $r) {
  33                 echo '<div class="quote">';
  34                 echo '<pre><a href="quote.php?id=' . $r['id'] . '">#' . $r['id'] . "</a>\n";
  35                 echo $r['quote'];
  36                 echo '</pre></div>';
  37         }
  38 }
  39
  40 echo $footer;
  41
  42 ?>