for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
declare(strict_types = 1);
namespace SimpleCrud\Query\Traits;
use PDO;
trait HasPagination
{
private $page;
private $perPage = 10;
public function page(int $page): self
$this->page = $page;
$this->query->page($page);
query
In PHP it is possible to write to properties without declaring them. For example, the following is perfectly valid PHP code:
class MyClass { } $x = new MyClass(); $x->foo = true;
Generally, it is a good practice to explictly declare properties to avoid accidental typos and provide IDE auto-completion:
class MyClass { public $foo; } $x = new MyClass(); $x->foo = true;
return $this;
}
public function perPage(int $perPage = 10): self
$this->perPage = $perPage;
$this->query->perPage($perPage);
public function getPageInfo()
$query = clone $this->query;
$query->resetOrderBy();
$query->resetLimit();
$query->resetColumns();
$query->columns('COUNT(*)');
$statement = $query->perform();
$statement->setFetchMode(PDO::FETCH_NUM);
$page = $this->page;
$count = $statement->fetch();
$count = intval($count[0]);
return [
'total' => $count,
'page' => $page,
'previous' => $page > 1 ? $page - 1 : null,
'next' => $count > ($page * $this->perPage) ? $page + 1 : null,
];
oscarotero /
simple-crud
In PHP it is possible to write to properties without declaring them. For example, the following is perfectly valid PHP code:
Generally, it is a good practice to explictly declare properties to avoid accidental typos and provide IDE auto-completion: