How to get params from query object in CakePHP 3

Question

How do I get the 'params' from a query object in CakePHP 3?

$response = $this->getTable()->find();
// there are beforeFinds...etc that make this more complex

When I debug the $response, I get this (:

// ...
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT .... WHERE ... article_id = :c2',
'params' => [
    ':c0' => [
        [maximum depth reached]
    ],
    ':c1' => [
        [maximum depth reached]
    ],
    ':c2' => [
        [maximum depth reached]
    ]
],
// ...

I'd like to know what the value of :c2 is, but I can't seem to get the params to debug.

I've tried these:

\Cake\Error\Debugger::log($response->params);
\Cake\Error\Debugger::log($response->params());
\Cake\Error\Debugger::log($response['params']);
\Cake\Error\Debugger::log($response->getParams());
\Cake\Error\Debugger::log($response->getQueryParams());

But none work.

Dave · Accepted Answer · 2018-02-03 22:55:31Z

0

By increasing the depth of the debug, I was able to see dditional information, including the values of the :c2

\Cake\Error\Debugger::log($response, 'debug', 4); // default depth is 3

answered Feb 3, 2018 at 22:55

Dave

29.2k26 gold badges117 silver badges184 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Greg Schmidt · Accepted Answer · 2018-02-04 06:54:24Z

0

You should be able to get them via $response->valueBinder()->bindings().

answered Feb 4, 2018 at 6:54

Greg Schmidt

5,1482 gold badges17 silver badges39 bronze badges

Comments

Dariusz Majchrzak · Accepted Answer · 2018-02-04 10:33:18Z

0

You can use __debugInfo() method:

$result = $this->Pages->find()->where(['is_public' => 1]);

dd($result->__debugInfo()['params']);

answered Feb 4, 2018 at 10:33

Dariusz Majchrzak

1,2472 gold badges12 silver badges25 bronze badges

Collectives™ on Stack Overflow

How to get params from query object in CakePHP 3

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related