W3cubDocs

/Drupal 8

public function Select::countQuery

public Select::countQuery()

Get the equivalent COUNT query of this query as a new query object.

Return value

\Drupal\Core\Database\Query\SelectInterface A new SelectQuery object with no fields or expressions besides COUNT(*).

Overrides SelectInterface::countQuery

File

core/lib/Drupal/Core/Database/Query/Select.php, line 703

Class

Select
Query builder for SELECT statements.

Namespace

Drupal\Core\Database\Query

Code

public function countQuery() {
  $count = $this->prepareCountQuery();

  $query = $this->connection->select($count, NULL, $this->queryOptions);
  $query->addExpression('COUNT(*)');

  return $query;
}

© 2001–2016 by the original authors
Licensed under the GNU General Public License, version 2 and later.
Drupal is a registered trademark of Dries Buytaert.
https://api.drupal.org/api/drupal/core!lib!Drupal!Core!Database!Query!Select.php/function/Select::countQuery/8.1.x