如何操作cakePHP paginator

Question

I have a Page with 80 Addresses and I want to set the addresses on a GoogleMap. This runs very fine

foreach ($atlas as $atla): 
    $options = array(
    'title' => $atla['Atla']['name'],
    'lng' => $atla['Atla']['longitude'],
    'lat' => $atla['Atla']['latitude'],
    'content' => $atla['Atla']['name']
);
echo $this->GoogleMapV3->addMarker($options);

endforeach;

Thats my foreach for that Add option. Not so good for performance, but it has only 80 Addresses. And it's a Test. CakePHP brings a paginator in Standardsetup, so that array is not the whole array with 80 Addresses. How do i get the whole array in the view for showing, without shutting down the paginator?

If any can help me.

Many greetings Marcus

Answer 1

The paginator queries the number of records set in the limit. So if you have 80 records in your database and have the paginator set to 20. It only queries the first 20 records from the database.

So you either have to set the limit of the paginator or use a different query to get all the records from the database.