public static function getSearchIndexes() { //return eventname/media/hashtags $app = \Slim\Slim::getInstance(); $allGetVars = $app->request->get(); $startAt = @$allGetVars['startAt'] ? intval($allGetVars['startAt']) : 0; $count = \relive\models\SearchIndex::count(); if ($startAt >= $count) { echo json_encode([]); return; } $limit = $count - $startAt; $indexes = \relive\models\SearchIndex::select('event_id', 'eventName')->where('isPublished', '=', '1')->orderBy('event_id', 'desc')->skip($startAt)->take($limit)->get()->toArray(); echo json_encode($indexes, JSON_UNESCAPED_SLASHES); }