protected function getUserPermissions($userID) { $sqlQuery = "SELECT permission FROM Users WHERE id = :id LIMIT 1"; $sqlParam = array("id" => $userID); $this->database->prepare($sqlQuery); $this->database->execute($sqlParam); $response = $this->database->fetch(); return isset($response['permission']) ? $response['permission'] : FALSE; }
/** * Executes an SQL query string. * * @param string Optional. The SQL query to execute. * @param array Optional. Additional parameters to * supply to the query. * @return array | bool */ private function execute($query = NULL, $params = NULL) { if ($this->database === NULL) { return $this->errorMessage("No database connection found."); } if ($query !== NULL) { $this->database->prepare($query); } // Execute the query, but brace for errors. $error = $this->database->execute($params); if ($error !== NULL) { return $this->errorMessage($error); } return TRUE; }