Example #1
0
 /**
  * @param $state
  * @param $uid
  * @param Application $app
  * @return bool
  */
 public static function setState($state, $uid, Application $app)
 {
     if (!isset($state) || !isset($uid)) {
         return false;
     }
     try {
         $query = $app->getDataManager()->getDataManager()->update('users', array('date_updated' => new \FluentLiteral('NOW()'), 'state' => $state), $uid);
         $executed = $query->execute(true);
     } catch (\PDOException $ex) {
         $app->getErrorManager()->addMessage("Error : " . $ex->getMessage());
         return false;
     }
     return $executed;
 }
Example #2
0
 /**
  * @param $article_data
  * @param Application $app
  * @return bool|int
  */
 public static function addArticle($article_data, Application $app)
 {
     if (empty($article_data)) {
         return false;
     }
     $article_data['date_inserted'] = new \FluentLiteral('NOW()');
     try {
         $query = $app->getDataManager()->getDataManager()->insertInto('articles')->values($article_data);
         $executed = $query->execute(true);
     } catch (\PDOException $ex) {
         $app->getErrorManager()->addMessage("Error : " . $ex->getMessage());
         return false;
     }
     return $executed;
 }