-/**
- * 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
- */
-
-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'])) ? htmlspecialchars($_GET['url']) : '';
- $title = $url;
- $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':
- 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());
-}