QueryBuilder - Count

Count the number of results found.

With DBAL QueryBuilder

use Ecommit\DoctrineUtils\Paginator\DoctrinePaginatorBuilder;

$count = DoctrinePaginatorBuilder::countQueryBuilder([
    'query_builder' => $queryBuilder,
    //Options - See below
]);

Available options :

Option	Type	Required	Default value	Description
query_builder	`Doctrine\DBAL\Query\QueryBuilder`	Yes		QueryBuilder
behavior	String	No	`count_by_select_all`	Method used to count results. Available values: `count_by_alias`: Use a alias (`SELECT count(alias) FROM ...`) (`alias` option is required)`count_by_sub_request` : Use a sub request (`connection` option is required)`count_by_select_all`: Use `SELECT count(*) FROM ...`)
alias	String	Only if `behavior = count_by_alias`		Can only be used when `behavior = count_by_alias`
distinct_alias	Bool	No	`true`	Use `DISTINCT` (`SELECT count(DISTINCT alias) FROM ...`). Can only be used when `behavior = count_by_alias`
connection	`Doctrine\DBAL\Connection`	Only if `behavior = count_by_sub_request`		Can only be used when `behavior = count_by_sub_request`

With ORM QueryBuilder

use Ecommit\DoctrineUtils\Paginator\DoctrinePaginatorBuilder;

$count = DoctrinePaginatorBuilder::countQueryBuilder([
    'query_builder' => $queryBuilder,
    //Options - See below
]);

Available options :

Option	Type	Required	Default value	Description
query_builder	`Doctrine\ORM\QueryBuilder`	Yes		QueryBuilder
behavior	String	No	`orm`	Method used to count results. Available values: `count_by_alias`: Use a alias (`SELECT count(alias) FROM ...`) (`alias` option is required)`count_by_sub_request` : Use a sub request`orm` : Use Doctrine engine
alias	String	Only if `behavior = count_by_alias`		Can only be used when `behavior = count_by_alias`
distinct_alias	Bool	No	`true`	Use `DISTINCT` (`SELECT count(DISTINCT alias) FROM ...`). Can only be used when `behavior = count_by_alias`
simplified_request	Bool	No	`true`	Remove unnecessary instructions (eg: `ORDER BY`) for counting. Can only be used when `behavior = orm`

Doctrine Utils Laravel Package

QueryBuilder - Count

With DBAL QueryBuilder

With ORM QueryBuilder