3 * poche, a read it later open source system
6 * @author Nicolas Lœuillet <nicolas@loeuillet.org>
8 * @license http://www.wtfpl.net/ see COPYING file
13 * gestion des erreurs sqlite (duplicate tout ça)
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
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
25 require_once dirname(__FILE__
).'/inc/Readability.php';
26 require_once dirname(__FILE__
).'/inc/Encoding.php';
27 include dirname(__FILE__
).'/inc/functions.php';
31 $db_handle = new PDO('sqlite:db/poche.sqlite');
32 $db_handle->setAttribute(PDO
::ATTR_ERRMODE
, PDO
::ERRMODE_EXCEPTION
);
36 die('database error : '.$e->getMessage());
39 $action = (isset ($_GET['action'])) ? htmlspecialchars($_GET['action']) : '';
40 $view = (isset ($_GET['view'])) ? htmlspecialchars($_GET['view']) : '';
41 $id = (isset ($_GET['id'])) ? htmlspecialchars($_GET['id']) : '';
45 $url = (isset ($_GET['url'])) ? $_GET['url'] : '';
46 $url = html_entity_decode(trim($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);
56 $title = $r->articleTitle
->innerHTML
;
60 $query = $db_handle->prepare('INSERT INTO entries ( url, title ) VALUES (?, ?)');
61 $query->execute(array($url, $title));
64 $sql_action = "UPDATE entries SET is_fav=~is_fav WHERE id=?";
65 $params_action = array($id);
67 case 'toggle_archive' :
68 $sql_action = "UPDATE entries SET is_read=~is_read WHERE id=?";
69 $params_action = array($id);
72 $sql_action = "DELETE FROM entries WHERE id=?";
73 $params_action = array($id);
82 if (isset($sql_action)) {
83 $query = $db_handle->prepare($sql_action);
84 $query->execute($params_action);
89 die('query error : '.$e->getMessage());
94 $sql = "SELECT * FROM entries WHERE is_read=?";
98 $sql = "SELECT * FROM entries WHERE is_fav=?";
102 $sql = "SELECT * FROM entries WHERE is_read=?";
110 $query = $db_handle->prepare($sql);
111 $query->execute($params);
112 $entries = $query->fetchAll();
116 die('query error : '.$e->getMessage());
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]-->
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">
136 <h1
><img src
="img/logo.png" alt
="logo poche" />poche
, a read it later open source system
</h1
>
138 <div id
="main" class="w800p">
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
>
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">✓</a> <a href="?action=toggle_fav&id='.$entry['id'].'" title="toggle favorite" class="tool">'.(($entry['is_fav'] == 0) ? '☆' : '★' ).'</a> <a href="?action=delete&id='.$entry['id'].'" title="toggle delete" class="tool">⨯</a></li>';
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
>