* afficher liens mis en favoris et archivés
* tri des liens
*/
+require_once dirname(__FILE__).'/inc/Readability.php';
+require_once dirname(__FILE__).'/inc/Encoding.php';
+include dirname(__FILE__).'/inc/functions.php';
try
{
- $db_handle = new PDO('sqlite:poche.sqlite');
+ $db_handle = new PDO('sqlite:db/poche.sqlite');
$db_handle->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch (Exception $e)
{
- die('error : '.$e->getMessage());
+ die('database error : '.$e->getMessage());
}
$action = (isset ($_GET['action'])) ? htmlspecialchars($_GET['action']) : '';
+$view = (isset ($_GET['view'])) ? htmlspecialchars($_GET['view']) : '';
+$id = (isset ($_GET['id'])) ? htmlspecialchars($_GET['id']) : '';
switch ($action) {
case 'add':
- $url = (isset ($_GET['url'])) ? htmlspecialchars($_GET['url']) : '';
+ $url = (isset ($_GET['url'])) ? $_GET['url'] : '';
+ $url = html_entity_decode(trim($url));
$title = $url;
+ // if url use https protocol change it to http
+ if (!preg_match('!^https?://!i', $url)) $url = 'http://'.$url;
+ // convert page to utf-8
+ $html = Encoding::toUTF8(get_external_file($url,15));
+ if(isset($html) and strlen($html) > 0) {
+ // send result to readability library
+ $r = new Readability($html, $url);
+ if($r->init()) {
+ $title = $r->articleTitle->innerHTML;
+ }
+ }
+
$query = $db_handle->prepare('INSERT INTO entries ( url, title ) VALUES (?, ?)');
$query->execute(array($url, $title));
break;
- case 'archive':
+ case 'toggle_fav' :
+ $sql_action = "UPDATE entries SET is_fav=~is_fav WHERE id=?";
+ $params_action = array($id);
break;
- case 'fav' :
+ case 'toggle_archive' :
+ $sql_action = "UPDATE entries SET is_read=~is_read WHERE id=?";
+ $params_action = array($id);
break;
case 'delete':
+ $sql_action = "DELETE FROM entries WHERE id=?";
+ $params_action = array($id);
+ break;
+ default:
+ break;
+}
+
+try
+{
+ # action query
+ if (isset($sql_action)) {
+ $query = $db_handle->prepare($sql_action);
+ $query->execute($params_action);
+ }
+}
+catch (Exception $e)
+{
+ die('query error : '.$e->getMessage());
+}
+
+switch ($view) {
+ case 'archive':
+ $sql = "SELECT * FROM entries WHERE is_read=?";
+ $params = array(-1);
+ break;
+ case 'fav' :
+ $sql = "SELECT * FROM entries WHERE is_fav=?";
+ $params = array(-1);
break;
default:
+ $sql = "SELECT * FROM entries WHERE is_read=?";
+ $params = array(0);
break;
}
-function url(){
- $protocol = "http";
- if(isset($_SERVER['HTTPS']))
- if($_SERVER['HTTPS'] != "off")
- $protocol = "https";
-
- return $protocol . "://" . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'];
+# view query
+try
+{
+ $query = $db_handle->prepare($sql);
+ $query->execute($params);
+ $entries = $query->fetchAll();
+}
+catch (Exception $e)
+{
+ die('query error : '.$e->getMessage());
}
+
?>
<!DOCTYPE html>
<!--[if lte IE 6]> <html class="no-js ie6 ie67 ie678" lang="en"> <![endif]-->
<link rel="stylesheet" href="css/style.css" media="all">
</head>
<body>
- <header>
- <h1>poche, a read it later open source system</h1>
- </header>
- <div id="main" class="w800p">
- <ul id="links">
- <li><a href="index.php">home</a></li>
- <li><a href="#">favorites</a></li>
- <li><a href="#">archive</a></li>
- <li><a 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>
- </ul>
- <?php
- $query = $db_handle->prepare("SELECT * FROM entries WHERE read=?");
- $query->execute(array('FALSE'));
- $entries = $query->fetchAll();
- ?>
- <ul id="entries">
- <?php
- foreach ($entries as $entry) {
- echo '<li><a href="readityourself.php?url='.urlencode($entry['url']).'">' . $entry['title'] . '</a> <a href="#" title="toggle delete" class="tool">✓</a> <a href="#" title="toggle favorite" class="tool">☆</a> <a href="#" title="toggle mark as read" class="tool">⨯</a></li>';
- }
- ?>
- </ul>
- </div>
- <footer class="mr2 mt3">
- <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>. poche is developed by <a href="http://nicolas.loeuillet.org">Nicolas Lœuillet</a> under the <a href="http://www.wtfpl.net/">Do What the Fuck You Want to Public License</a></p>
+ <header>
+ <h1><img src="img/logo.png" alt="logo poche" />poche, a read it later open source system</h1>
+ </header>
+ <div id="main" class="w800p">
+ <ul id="links">
+ <li><a href="index.php">home</a></li>
+ <li><a href="?view=fav">favorites</a></li>
+ <li><a href="?view=archive">archive</a></li>
+ <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>
+ </ul>
+ <ul id="entries">
+ <?php
+ foreach ($entries as $entry) {
+ 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>';
+ }
+ ?>
+ </ul>
+ </div>
+ <footer class="mr2 mt3">
+ <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>. 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>
</footer>
- </body>
+ </body>
</html>
\ No newline at end of file