function getAll() { SecurityResource::requirePermission("VIEW"); $sql = "SELECT * from security_resource"; $result = Database::query($sql); $all = array(); while($line = $result->next()) { array_push($all, SecurityResource::build($line)); } return $all; }
function getById($id) { SecurityResource::requirePermission("VIEW"); $sql = "SELECT * from security_resource WHERE id=".Database::sqlValue($id); $result = Database::query($sql); $r = NULL; if ($line = $result->next()) { $r = SecurityResource::build($line); } return $r; }