`Get the SQL query that was executed in Zend Framework v1.9.6`

Tue, 17 September 2019

php

sql

before_your_query.php

<?php
// Enable the profiler.
Zend_Registry::get(
    'db'
)->getProfiler(
)->setEnabled(
    true
);

after_your_query.php

<?php
// Get the query
$sql = Zend_Registry::get(
    'db'
)->getProfiler(
)->getLastQueryProfile(
)->getQuery();

// Dump the query
var_dump($sql);

php

sql