index.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 /**
  12  * TODO
  13  * gestion des erreurs sqlite (duplicate tout ça)
  14  * gérer si url vide
  15  * traiter les variables passées en get
  16  * récupérer le titre de la page pochée (cf readityourself.php)
  17  * actions archive, fav et delete à traiter
  18  * bookmarklet
  19  * améliorer présentation des liens
  20  * améliorer présentation d'un article
  21  * aligner verticalement les icones d'action
  22  * afficher liens mis en favoris et archivés
  23  * tri des liens
  24  */
  25 require_once dirname(__FILE__).'/inc/Readability.php';
  26 require_once dirname(__FILE__).'/inc/Encoding.php';
  27 include dirname(__FILE__).'/inc/functions.php';
  28
  29 try
  30 {
  31     $db_handle = new PDO('sqlite:db/poche.sqlite');
  32     $db_handle->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  33 }
  34 catch (Exception $e)
  35 {
  36     die('database error : '.$e->getMessage());
  37 }
  38
  39 $action = (isset ($_GET['action'])) ? htmlspecialchars($_GET['action']) : '';
  40 $view = (isset ($_GET['view'])) ? htmlspecialchars($_GET['view']) : '';
  41 $id = (isset ($_GET['id'])) ? htmlspecialchars($_GET['id']) : '';
  42
  43 switch ($action) {
  44     case 'add':
  45         $url = (isset ($_GET['url'])) ? $_GET['url'] : '';
  46         $url = html_entity_decode(trim($url));
  47         $title = $url;
  48         // if url use https protocol change it to http
  49         if (!preg_match('!^https?://!i', $url)) $url = 'http://'.$url;
  50         // convert page to utf-8
  51         $html = Encoding::toUTF8(get_external_file($url,15));
  52         if(isset($html) and strlen($html) > 0) {
  53             // send result to readability library
  54             $r = new Readability($html, $url);
  55             if($r->init()) {
  56                 $title = $r->articleTitle->innerHTML;
  57             }
  58         }
  59
  60         $query = $db_handle->prepare('INSERT INTO entries ( url, title ) VALUES (?, ?)');
  61         $query->execute(array($url, $title));
  62         break;
  63     case 'toggle_fav' :
  64         $sql_action = "UPDATE entries SET is_fav=~is_fav WHERE id=?";
  65         $params_action = array($id);
  66         break;
  67     case 'toggle_archive' :
  68         $sql_action = "UPDATE entries SET is_read=~is_read WHERE id=?";
  69         $params_action = array($id);
  70         break;
  71     case 'delete':
  72         $sql_action = "DELETE FROM entries WHERE id=?";
  73         $params_action = array($id);
  74         break;
  75     default:
  76         break;
  77 }
  78
  79 try
  80 {
  81     # action query
  82     if (isset($sql_action)) {
  83         $query = $db_handle->prepare($sql_action);
  84         $query->execute($params_action);
  85     }
  86 }
  87 catch (Exception $e)
  88 {
  89     die('query error : '.$e->getMessage());
  90 }
  91
  92 switch ($view) {
  93     case 'archive':
  94         $sql = "SELECT * FROM entries WHERE is_read=?";
  95         $params = array(-1);
  96         break;
  97     case 'fav' :
  98         $sql = "SELECT * FROM entries WHERE is_fav=?";
  99         $params = array(-1);
 100         break;
 101     default:
 102         $sql = "SELECT * FROM entries WHERE is_read=?";
 103         $params = array(0);
 104         break;
 105 }
 106
 107 # view query
 108 try
 109 {
 110     $query = $db_handle->prepare($sql);
 111     $query->execute($params);
 112     $entries = $query->fetchAll();
 113 }
 114 catch (Exception $e)
 115 {
 116     die('query error : '.$e->getMessage());
 117 }
 118
 119 ?>
 120 <!DOCTYPE html>
 121 <!--[if lte IE 6]> <html class="no-js ie6 ie67 ie678" lang="en"> <![endif]-->
 122 <!--[if lte IE 7]> <html class="no-js ie7 ie67 ie678" lang="en"> <![endif]-->
 123 <!--[if IE 8]> <html class="no-js ie8 ie678" lang="en"> <![endif]-->
 124 <!--[if gt IE 8]><!--> <html class="no-js" lang="en"> <!--<![endif]-->
 125 <html>
 126     <head>
 127         <meta name="viewport" content="width=device-width, minimum-scale=1.0, maximum-scale=1.0">
 128         <meta charset="utf-8">
 129         <meta http-equiv="X-UA-Compatible" content="IE=10">
 130         <title>poche : queue</title>
 131         <link rel="stylesheet" href="css/knacss.css" media="all">
 132         <link rel="stylesheet" href="css/style.css" media="all">
 133     </head>
 134     <body>
 135         <header>
 136             <h1><img src="img/logo.png" alt="logo poche" />poche, a read it later open source system</h1>
 137         </header>
 138         <div id="main" class="w800p">
 139             <ul id="links">
 140                 <li><a href="index.php">home</a></li>
 141                 <li><a href="?view=fav">favorites</a></li>
 142                 <li><a href="?view=archive">archive</a></li>
 143                 <li><a title="i am a bookmarklet, use me !" href="javascript:(function(){var%20url%20=%20location.href;var%20title%20=%20document.title%20||%20url;window.open('<?php echo url()?>?action=add&url='%20+%20encodeURIComponent(url),'_self');})();">poche it !</a></li>
 144             </ul>
 145             <ul id="entries">
 146                 <?php
 147                 foreach ($entries as $entry) {
 148                     echo '<li><a href="readityourself.php?url='.urlencode($entry['url']).'">' . $entry['title'] . '</a> <a href="?action=toggle_archive&id='.$entry['id'].'" title="toggle mark as read" class="tool">&#10003;</a> <a href="?action=toggle_fav&id='.$entry['id'].'" title="toggle favorite" class="tool">'.(($entry['is_fav'] == 0) ? '&#9734;' : '&#9733;' ).'</a> <a href="?action=delete&id='.$entry['id'].'" title="toggle delete" class="tool">&#10799;</a></li>';
 149                 }
 150                 ?>
 151             </ul>
 152         </div>
 153         <footer class="mr2 mt3">
 154             <p class="smaller"><a href="http://github.com/nicosomb/poche">poche</a> is a read it later open source system, based on <a href="http://www.memiks.fr/readityourself/">ReadItYourself</a>. <a href="https://twitter.com/getpoche" title="follow us on twitter">@getpoche</a>. Logo by <a href="http://www.iconfinder.com/icondetails/43256/128/jeans_monotone_pocket_icon">Brightmix</a>. poche is developed by <a href="http://nicolas.loeuillet.org">Nicolas Lœuillet</a> under the <a href="http://www.wtfpl.net/">WTFPL</a>.</p>
 155         </footer>
 156     </body>
 157 </html>