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; }
/** * Run the supplied query. Only for fetching rows from * the database. * * @param string Optional. The SQL query to execute. * @param array Optional. Additional parameters to * supply to the query. * @param bool If true, fetches all matching rows. * Defaults to TRUE. * @return array **/ protected final function read($query = NULL, $params = NULL, $fetchAll = TRUE) { $execution = $this->execute($query, $params); if ($execution !== TRUE) { return $execution; } if ($fetchAll) { return $this->database->fetchAll(); } return $this->database->fetch(); }