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->prepare("SELECT id,quote FROM miniqdb WHERE id=?");
  29 $st->execute(array($id));
  30 if ($st->rowCount() == 0) {
  31         echo "<p>Quote $id doesn't exist.</p>";
  32 } else {
  33         foreach ($st->fetchAll() as $r) {
  34                 echo '<div class="quote">';
  35                 echo '<pre><a href="quote.php?id=' . $r['id'] . '">#' . $r['id'] . "</a>\n";
  36                 echo $r['quote'];
  37                 echo '</pre></div>';
  38         }
  39 }
  40
  41 echo $footer;
  42
  43 ?>