Limit amount of results in CakePHP

Question

Limit amount of results in CakePHP

Navigation

#1 by (1 votes)
#2 by (1 votes)

1

I'm learning CakePHP and this doubt came to me, if I want to put my limit so that it has start and long range, what would it be like?

$posts = $this->Post->find('all',
                array('conditions' => array(
                    'post_visible !=' => '0'
                    ),
                'limit' => '0,10', 
                'order' => 'id'
                )       
            );

Currently I have it like that but the limit puts it as 0.

I tried it this way: 'limit' => '0'.','.'10' .

php cakephp

asked by PardusNIx 14.09.2017 в 17:03

source

2 answers

Node - console.log (req.body) -undefined Change ImageView src by the name of an Android studio image

score 1 · Answer 1

Only the limit is established. And by default you order by id, this would not be necessary.

Try it like this:

$post = $this->Post->find('all')
->where(['post_visible !=' => '0'])
->limit('10');

Here you have the documentation of Cake, read without fear, you will be understanding!

link

Greetings!

score 1 · Answer 2

The limit only receives a value not a range, if what you need is page use the method paginate() of the framework you pass as a parameter of how many records you will page

$posts = $this->Post->find('all',
        array('conditions' => array(
            'post_visible !=' => '0'
            ),
        'limit' => 10, 
        'order' => 'id'
        )       
    );

If you need it for something else you can do the find all search then go through the records of 1-10 and perform the logic you need with these records. You can receive in your for these variables of ranges and you already pass them from where you want and you are modifying them.