Query limit data from a single table in Controller

Need Help
1

Guys,
I have a code which showing data from 3 tables in a page
but, what I want is a single table can use a query limit
this is my code

        $features = $this->paginate($this->Features);
        $categories = $this->paginate($this->Categories);

        $articles = $this->paginate($this->Articles->find('all', [
            'limit' => 1,
            'order' => 'Articles.created DESC',
        ]));
        $this->set(compact('articles'));
        $this->set(compact('categories'));
        $this->set(compact('features'));

but it did not working, all data still showing

2

You have the array with your pagination specs inside the find call rather than as a param on the paginate call. Should be:

        $articles = $this->paginate(
            $this->Articles->find('all'),
            [
               'limit' => 1,
               'order' => 'Articles.created DESC',
            ]
      );
3

Thank you for your respond, but this code is error in my controller
showing error:
$sortDefault = key($defaults[‘order’]);
in directory vendor\cakephp\cakephp\src\Datasource\Paginator.php

4

That’s not an error message, that’s a bit of code. What error does it give you?

5

The ‘order’ option in the Pagination component has a slightly different syntax as illustrated in the book

try:

$articles = $this->paginate(
            $this->Articles->find('all'),
            [
               'limit' => 1,
               'order' => [
                  'Articles.created' => 'desc'
               ]
            ]
      );