How to get the last query executed by CakePHP?

Question

How to get the last query executed by CakePHP?

Navigation

#1 by (1 votes)

4

I want to get the last query executed by CakePHP

Example

$data  =  $this->Ticket->find('all',  array('conditions'  =>  $conditions,  'order'  =>  array('Ticket.id'  =>  'DESC')));

$this->query = $this->Ticket->getLastQuery();

public function getLastQuery($fromWhereClause = false){
        $dbo = $this->getDatasource();
        $logs = $dbo->getLog();
        $lastLog = end($logs['log']);
        if ($fromWhereClause) {
            return strstr($lastLog['query'], 'WHERE');
        }
        return $lastLog['query'];
}

but the getLastQuery is only executed when the debug is set to the value 2 I would like to get it set to 0

php cakephp query debug log

asked by anonymous 11.07.2014 / 23:41

1 answer

Creating automatic tables by Hibernate How to replace the HTML content of a div using DOMElement of php

score 1 · Accepted Answer

Try this:

$data  =  $this->Ticket->find('all',  array('conditions'  =>  $conditions,  'order'  =>  array('Ticket.id'  =>  'DESC')));

$this->query = $this->Ticket->getLastQuery();

public function getLastQuery($fromWhereClause = false){
    $dbo = $this->getDatasource();
    $dbo->fullDebug = true;
    $logs = $dbo->getLog();
    $lastLog = end($logs['log']);
    if ($fromWhereClause) {
        return strstr($lastLog['query'], 'WHERE');
    }
    $dbo->fullDebug = false;
    return $lastLog['query'];
}

Based on this SOen response: link