CakePHP – get last query run

by

For Cake 2.0, the query log is protected so this will work

function getLastQuery() {
  $dbo = $this->getDatasource();
  $logs = $dbo->getLog();
  $lastLog = end($logs['log']);
  return $lastLog['query'];
}

More Related Contents:

  1. Cakephp Career Database Design
  2. How to show the last queries executed on MySQL?
  3. How to enable MySQL Query Log?
  4. Log all queries in mysql
  5. How to see log files in MySQL?
  6. MySQL/Writing file error (Errcode 28)
  7. i have an error which i dont understand. can you help me? [closed]
  8. How to group by week in MySQL?
  9. Can I use a function for a default value in MySql?
  10. Mysql order by specific ID values
  11. How do I check if a column is empty or null in MySQL?
  12. MySQL versus PDO [duplicate]
  13. What is this operator in MySQL?
  14. SELECT * WHERE NOT EXISTS
  15. Row number per group in mysql
  16. Resetting ROOT password in MySQL 5.6
  17. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  18. Field ‘id’ doesn’t have a default value?
  19. “SELECT COUNT(*)” is slow, even with where clause
  20. is there a mysql function to decode html entities?
  21. MySQL fails on: mysql “ERROR 1524 (HY000): Plugin ‘auth_socket’ is not loaded”
  22. MySQL – SQL_BIG_SELECTS
  23. How to use unsigned int / long types with Entity Framework?
  24. How to Prevent Connection Timeouts for Large MySQL Imports
  25. Can I launch a trigger on select statement in mysql?
  26. How do you write a case insensitive query for both MySQL and Postgres?
  27. How to use MySQL DECIMAL?
  28. MySQL: return updated rows
  29. SQL doesnt differentiate u and ü although collation is utf8mb4_unicode_ci
  30. Mysql stored procedure don’t take table name as parameter

Leave a Comment