php - Show SQL query of controller

Question

I am using cakephp v3.x and mysql.

I would like to see the SQL query of a controller. There is no error with this controller and it runs successfully.

public function appGetResult()
{
    $this->autoRender = false;
    $start_date = $this->request->query['start_date'];
    $end_date = $this->request->query['end_date']; 

    $results = $this->MonthlyReports->getResult($start_date, $end_date);

    echo json_encode($results);
} 

How to modify the controller code to display the SQL query used in generating the results? This is not for actual production use. More for examination.

Answer 1

You can turn on query logging on CakePHP3: http://book.cakephp.org/3.0/en/orm/database-basics.html#query-logging

If you're interested in doing more debugging and such, DebugKit does an amazing job.