本文整理匯總了PHP中Cake\Database\Query::limit方法的典型用法代碼示例。如果您正苦於以下問題：PHP Query::limit方法的具體用法？PHP Query::limit怎麽用？PHP Query::limit使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Cake\Database\Query的用法示例。
在下文中一共展示了Query::limit方法的3個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: findCursor
public function findCursor(Query $query)
{
$current = $this->request->query('cursor');
$limit = $this->request->query('limit') ?: 10;
if ($current) {
$query->where(['id >' => $current]);
}
$query->limit($limit);
return $query;
}示例2: testSelectOffset
/**
* Tests selecting rows combining a limit and offset clause
*
* @return void
*/
public function testSelectOffset()
{
$query = new Query($this->connection);
$result = $query->select('id')->from('comments')->limit(1)->offset(0)->order(['id' => 'ASC'])->execute();
$this->assertCount(1, $result);
$this->assertEquals(['id' => 1], $result->fetch('assoc'));
$query = new Query($this->connection);
$result = $query->select('id')->from('comments')->limit(1)->offset(1)->execute();
$this->assertCount(1, $result);
$this->assertEquals(['id' => 2], $result->fetch('assoc'));
$query = new Query($this->connection);
$result = $query->select('id')->from('comments')->limit(1)->offset(2)->execute();
$this->assertCount(1, $result);
$this->assertEquals(['id' => 3], $result->fetch('assoc'));
$query = new Query($this->connection);
$result = $query->select('id')->from('articles')->order(['id' => 'DESC'])->limit(1)->offset(0)->execute();
$this->assertCount(1, $result);
$this->assertEquals(['id' => 3], $result->fetch('assoc'));
$result = $query->limit(2)->offset(1)->execute();
$this->assertCount(2, $result);
$this->assertEquals(['id' => 2], $result->fetch('assoc'));
$this->assertEquals(['id' => 1], $result->fetch('assoc'));
}示例3: testSelectOffset
/**
* Tests selecting rows combining a limit and offset clause
*
* @return void
*/
public function testSelectOffset()
{
$this->loadFixtures('Articles', 'Comments');
$query = new Query($this->connection);
$result = $query->select('id')->from('comments')->limit(1)->offset(0)->order(['id' => 'ASC'])->execute();
$this->assertCount(1, $result);
$this->assertEquals(['id' => 1], $result->fetch('assoc'));
$query = new Query($this->connection);
$result = $query->select('id')->from('comments')->limit(1)->offset(1)->execute();
$this->assertCount(1, $result);
$this->assertEquals(['id' => 2], $result->fetch('assoc'));
$query = new Query($this->connection);
$result = $query->select('id')->from('comments')->limit(1)->offset(2)->execute();
$this->assertCount(1, $result);
$this->assertEquals(['id' => 3], $result->fetch('assoc'));
$query = new Query($this->connection);
$result = $query->select('id')->from('articles')->order(['id' => 'DESC'])->limit(1)->offset(0)->execute();
$this->assertCount(1, $result);
$this->assertEquals(['id' => 3], $result->fetch('assoc'));
$result = $query->limit(2)->offset(1)->execute();
$this->assertCount(2, $result);
$this->assertEquals(['id' => 2], $result->fetch('assoc'));
$this->assertEquals(['id' => 1], $result->fetch('assoc'));
$query = new Query($this->connection);
$query->select('id')->from('comments')->limit(1)->offset(1)->execute();
$dirty = $this->readAttribute($query, '_dirty');
$this->assertFalse($dirty);
$query->offset(2);
$dirty = $this->readAttribute($query, '_dirty');
$this->assertTrue($dirty);
}