[Magento] Get the native SQL

原创于 2012-12-26 18:53:48 发布 · 389 阅读

0 ·

CC 4.0 BY-SA版权

Magento 专栏收录该内容

41 篇文章

订阅专栏

本文详细介绍了如何使用Zend_Db_Select的assemble或toString方法获取模型查询的原生SQL。对于集合类，也推荐使用此方法。通过连接资源管理器获取写入连接，执行SQL查询并获取结果，最后将查询结果以HTML模板形式展示。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

We use Zend_Db_Select's assemble or _toString to get the native sqlfor the model query. For collection class, it is also recommendedto use this way:

$sqlStruct['sql'] =$collection->getSelectSql(true);

<code>
$con =Mage::getSingleton('core/resource')->getConnection('core_write');
       $query =$this->getRequest()->getParam('sql');
       $queryParams =$this->getRequest()->getParam('params');

       $result = $con->query($query, $queryParams);

       $items = array();
       $headers = array();
       while ($row = $result->fetch(PDO::FETCH_ASSOC)){
           $items[] = $row;

           if (empty($headers)) {
               $headers = array_keys($row);
           }
       }

       $block = new Mage_Core_Block_Template();
       $block->setTemplate('debug/arrayformat.phtml');
       $block->assign('title', 'SQL Select');
       $block->assign('headers', $headers);
       $block->assign('items', $items);
       $block->assign('query', $query);
       echo $block->toHtml();

</code>