public static function getRange($start, $end)
{
if ($start < 0) {
if ($end > $start) {
return null;
}
$direction = "DESC";
$start *= -1;
$end *= -1;
} else {
if ($end < $start) {
return null;
}
$direction = "ASC";
}
$mysqli = new mysqli("classroom.cs.unc.edu", "zrkaplan", "KMP4president", "zrkaplandb");
$result = $mysqli->query("select id from Ai order by id " . $direction);
$ais = array();
if ($result) {
for ($i = 1; $i < $start; $i++) {
$result->fetch_row();
}
for ($i = $start; $i <= $end; $i++) {
$next_row = $result->fetch_row();
if ($next_row) {
$ais[] = Ai::findByID($next_row[0]);
}
}
}
return $ais;
}
