How can i find the sql query statement of insert() in Zend Framework?

Question

How can i find the sql query statement in Zend Framework for insert(), like its done for db table select's. $select->__toString().

Answer 1

Try this which work for me:

    $db = Zend_Db_Table_Abstract::getDefaultAdapter();
    $db->getProfiler()->setEnabled(true);
    $profiler = $db->getProfiler();

    $lastID = ($this->insert($data));

    $query = $profiler->getLastQueryProfile();
    $params = $query->getQueryParams();
    $sqlQuery= $query->getQuery();

    foreach ($params as $par) {
        $sqlQuery = preg_replace('/\\?/', "'" . $par . "'", $sqlQuery, 1);
    }
    echo $sqlQuery;