public static function getProxyItemByValidToken(Database $db, $token) { $query = "SELECT id, token, valid_from, valid_to, data, route, action, only_authenticated, only_uid, only_gid FROM proxy WHERE (token=:token AND valid_from<=NOW() AND (valid_to IS NULL OR valid_to>NOW()))"; $queryArgs = array(":token" => $token); $fetchArgs = array("type" => PDO::FETCH_CLASS, "className" => "ProxyEntity"); return $db->selectQuery($query, $queryArgs, $fetchArgs); }
/** * Frontcontroller constructor. * It performs dispatching user request and runs the controller action. * * @param Phoenix\Core\Database $db * @param Phoenix\Http\Request $request * @return void */ public function __construct(Database $db, Request $request) { $this->response = null; try { if ($db->getStatus() !== true) { throw new FailureException(FrameworkExceptions::F_DB_UNABLE_CONNECT); } $this->db = $db; $this->request = $request; $this->response_format = $this->request->getUrl()->getQueryParameter(self::URL_GET_FORMAT); $this->router = RouterFactory::createRouter(Config::get(Config::KEY_APP_USE_ROUTER)); $this->dispatch(); $this->performControllerAction(); } catch (NoticeException $e) { $this->response = ResponseFactory::createResponse($this->response_format); $this->response->setException($e); } catch (WarningException $e) { Logger::log($e, $this->db); $this->response = ResponseFactory::createResponse($this->response_format); $this->response->setException($e); } catch (FailureException $e) { Logger::log($e); $this->response = ResponseFactory::createResponse($this->response_format); $this->response->setException($e); } catch (Exception $e) { Logger::log($e); $this->response = ResponseFactory::createResponse($this->response_format); $this->response->setException($e); } }
public static function insertRecord(Database $db, $user_uid, $message) { $query = "INSERT INTO log_activity (id, ts_insert, user_uid, message) VALUES (default, NOW(), :user_uid, :message)"; $queryArgs = array(":user_uid" => $user_uid, ":message" => $message); return $db->actionQuery($query, $queryArgs); }
public static function insertRecord(Database $db, $class, $code, $stack, $message = null) { $query = "INSERT INTO log_internal (id, ts_insert, class, code, stack, message) VALUES (default, default, :class, :code, :stack, :message)"; $queryArgs = array(":class" => $class, ":code" => $code, ":stack" => $stack, ":message" => $message); return $db->actionQuery($query, $queryArgs); }