* @copyright 2013
* @license http://www.wtfpl.net/ see COPYING file
*/
/**
* TODO
* gestion des erreurs sqlite (duplicate tout ça)
* gérer si url vide
* traiter les variables passées en get
* récupérer le titre de la page pochée (cf readityourself.php)
* actions archive, fav et delete à traiter
* bookmarklet
* améliorer présentation des liens
* améliorer présentation d'un article
* aligner verticalement les icones d'action
* 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:db/poche.sqlite');
$db_handle->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch (Exception $e)
{
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'])) ? $_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 'toggle_fav' :
$sql_action = "UPDATE entries SET is_fav=~is_fav WHERE id=?";
$params_action = array($id);
break;
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;
}
# view query
try
{
$query = $db_handle->prepare($sql);
$query->execute($params);
$entries = $query->fetchAll();
}
catch (Exception $e)
{
die('query error : '.$e->getMessage());
}
?>
poche : queue
poche, a read it later open source system