url_handler.php

   1 <?php
   2
   3 require('includes/header.php');
   4
   5 $requested_page = ltrim($_SERVER['REQUEST_URI'], '/');
   6
   7 $stmt = $link->prepare('SELECT page_title, content FROM pages WHERE url = ?');
   8 $stmt->bind_param('s', $requested_page);
   9 $stmt->execute();
  10
  11 $stmt->store_result();
  12 if($stmt->num_rows < 1)
  13 {
  14         redirect('The page you requested was not found.', '');
  15 }
  16
  17 $stmt->bind_result($page_title, $content);
  18 $stmt->fetch();
  19 $stmt->close();
  20
  21 echo $content;
  22
  23 require('includes/footer.php');
  24
  25 ?>