CakePHP3: how to get result set size?

Need Help
1

Hello,

I have the following code:

$sites = $this->Sites->find()
->contain([
	'Sitecategories',
	'Sitedescriptions.Languages',
	'Countries',
	'Users'
])
->where([
		'postcode LIKE' => $this->request->data['numero'] . '%'
])
->sortBy(function($row) { return substr($row->postcode, 0, 2); }, SORT_ASC);

debug($sites); displays:

object(Cake\Collection\Iterator\SortIterator) {

'count' => (int) 428

}

And so I’m very desappointed because I don’t understand how to access to that count var.

2

I usuallly just do something like this:

$result = $connection->execute('SELECT COUNT(dogid) as total FROM dogs WHERE adopted = 0')->fetchAll('assoc');
$dogrows = $result[0]['total'];

That is just the count not the query that retrieves the results. You can use querybuilder also.

3

Should be $sites->count()

http://book.cakephp.org/3.0/en/orm/query-builder.html#returning-the-total-count-of-records

4

@rrd, unfortunately not, I tried it and I get the following error:

Error: You cannot issue a count on a Collection.