From 1a268ba710b2cdb4ede98af3368c43d66c4c5e53 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Nicolas=20L=C5=93uillet?= Date: Wed, 3 Apr 2013 15:14:01 +0200 Subject: first commit --- index.php | 97 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 97 insertions(+) create mode 100755 index.php (limited to 'index.php') diff --git a/index.php b/index.php new file mode 100755 index 00000000..8861d31e --- /dev/null +++ b/index.php @@ -0,0 +1,97 @@ + + * @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 + */ + +try +{ + $db_handle = new PDO('sqlite:poche.sqlite'); + $db_handle->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); +} +catch (Exception $e) +{ + die('error : '.$e->getMessage()); +} + +$action = (isset ($_GET['action'])) ? htmlspecialchars($_GET['action']) : ''; + +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 'archive': + break; + case 'fav' : + break; + case 'delete': + break; + default: + break; +} +?> + + + + + + + + + + + poche : queue + + + + +
+

poche, a read it later open source system

+
+
+ + prepare("SELECT * FROM entries WHERE read=?"); + $query->execute(array('FALSE')); + $entries = $query->fetchAll(); + ?> + +
+ + + \ No newline at end of file -- cgit v1.2.3