From 5917f41972c038a125c054da1d7ae172fc3bd9d5 Mon Sep 17 00:00:00 2001 From: nicosomb Date: Thu, 4 Apr 2013 19:51:24 +0200 Subject: [PATCH 1/1] changement de la structure de la base sqlite --- index.php | 113 +++++++++++++++++++++++++++++++++++---------------- poche.sqlite | Bin 131072 -> 163840 bytes 2 files changed, 78 insertions(+), 35 deletions(-) diff --git a/index.php b/index.php index d89fa41c..be1ebef9 100755 --- a/index.php +++ b/index.php @@ -30,10 +30,12 @@ try } 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': @@ -42,9 +44,13 @@ switch ($action) { $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': break; @@ -52,13 +58,55 @@ switch ($action) { break; } -function url(){ - $protocol = "http"; - if(isset($_SERVER['HTTPS'])) - if($_SERVER['HTTPS'] != "off") - $protocol = "https"; - - return $protocol . "://" . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; +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()); +} + +function url() { + $protocol = "http"; + if(isset($_SERVER['HTTPS'])) { + if($_SERVER['HTTPS'] != "off") { + $protocol = "https"; + } + } + + return $protocol . "://" . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; } ?> @@ -76,31 +124,26 @@ function url(){ -
-

poche, a read it later open source system

-
-
- - prepare("SELECT * FROM entries WHERE read=?"); - $query->execute(array('FALSE')); - $entries = $query->fetchAll(); - ?> - -
-