view.php

   1 <?php
   2 /**
   3  * poche, a read it later open source system
   4  *
   5  * @category   poche
   6  * @author     Nicolas Lœuillet <nicolas@loeuillet.org>
   7  * @copyright  2013
   8  * @license    http://www.wtfpl.net/ see COPYING file
   9  */
  10
  11 include dirname(__FILE__).'/inc/config.php';
  12
  13 if(isset($_GET['id']) && $_GET['id'] != '') {
  14
  15     $sql    = "SELECT * FROM entries WHERE id=?";
  16     $params = array(intval($_GET['id']));
  17
  18     # view article query
  19     try
  20     {
  21         $query  = $db->getHandle()->prepare($sql);
  22         $query->execute($params);
  23         $entry = $query->fetchAll();
  24     }
  25     catch (Exception $e)
  26     {
  27         die('query error : '.$e->getMessage());
  28     }
  29
  30     if ($entry != NULL) {
  31         $tpl->assign('id', $entry[0]['id']);
  32         $tpl->assign('url', $entry[0]['url']);
  33         $tpl->assign('title', $entry[0]['title']);
  34         $tpl->assign('content', $entry[0]['content']);
  35         $tpl->assign('is_fav', $entry[0]['is_fav']);
  36         $tpl->assign('is_read', $entry[0]['is_read']);
  37         $tpl->assign('load_all_js', 0);
  38         $tpl->draw('view');
  39     }
  40     else {
  41         die('error in view call');
  42     }
  43 }
  44 else {
  45     die('error in view call');
  46 }