/** * Test passing in a LIMIT with OFFSET clause string. */ public function testLimitSetFromClauseString() { $query = new SQLSelect(); $query->setSelect('*'); $query->setFrom('"SQLSelectTest_DO"'); $query->setLimit('20 OFFSET 10'); $limit = $query->getLimit(); $this->assertEquals(20, $limit['limit']); $this->assertEquals(10, $limit['start']); }
/** * Set the limit of this query. * * @param int $limit * @param int $offset * @return $this */ public function limit($limit, $offset = 0) { $this->query->setLimit($limit, $offset); return $this; }