-
- # view query
- try
- {
- $query = $db->getHandle()->prepare($sql);
- $query->execute($params);
- $entries = $query->fetchAll();
- }
- catch (Exception $e)
- {
- logm('view query error : '.$e->getMessage());
- }
-
- return $entries;
-}
-
-/**
- * Récupère un article en fonction d'un ID
- */
-function get_article($id)
-{
- global $db;
-
- $entry = NULL;
- $sql = "SELECT * FROM entries WHERE id=?";
- $params = array(intval($id));
-
- # view article query
- try
- {
- $query = $db->getHandle()->prepare($sql);
- $query->execute($params);
- $entry = $query->fetchAll();
- }
- catch (Exception $e)
- {
- logm('get article query error : '.$e->getMessage());
- }
-
- return $entry;
-}
-
-/**
- * Vérifie si le jeton passé en $_POST correspond à celui en session
- */
-function verif_token($token)
-{
- if(isset($_SESSION['token_poche']) && isset($_SESSION['token_time_poche']) && isset($token))
- {
- if($_SESSION['token_poche'] == $token)
- {
- $old_timestamp = time() - (15*60);
- if($_SESSION['token_time_poche'] >= $old_timestamp)
- {
- return TRUE;
- }
- else {
- session_destroy();
- logm('session expired');
- }
- }
- else {
- logm('token error : the token is different');
- return FALSE;
- }
- }
- else {
- logm('token error : the token is not here');
- return FALSE;
- }