- $parametres_url = prepare_url($url, $id);
- $sql_action = 'INSERT INTO entries ( url, title, content, is_read ) VALUES (?, ?, ?, ?)';
- $params_action = array($url, $parametres_url['title'], $parametres_url['content'], $read);
- try
- {
- # action query
- if (isset($sql_action))
- {
- $query = $db->getHandle()->prepare($sql_action);
- $query->execute($params_action);
- }
- }
- catch (Exception $e)
- {
- logm('error during pocket import : ' . $e->getMessage());
+ action_to_do('add', $url);
+ if ($read == '1') {
+ $last_id = $db->getHandle()->lastInsertId();
+ $sql_update = "UPDATE entries SET is_read=~is_read WHERE id=?";
+ $params_update = array($last_id);
+ $query_update = $db->getHandle()->prepare($sql_update);
+ $query_update->execute($params_update);