如何将 Magento sql 查询显示为字符串？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/4680116/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
提示：将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间：2020-09-01 08:51:53 来源:igfitidea点击:
How do you display a Magento sql query as a string?
提问by woot586
Magento constructs its SQL queries like
Magento 构建其 SQL 查询，如
$this->getSelect()->joinInner(
array('sbao' => $this->getTable('sales/billing_agreement_order')),
'main_table.entity_id = sbao.order_id',
array()
)
Is there a way to display the resulting query in a string format rather than printing out the huge object e.g.
有没有办法以字符串格式显示结果查询，而不是打印出巨大的对象，例如
echo $this->getSelect()->joinInner(
array('sbao' => $this->getTable('sales/billing_agreement_order')),
'main_table.entity_id = sbao.order_id',
array()
)->toString();
回答by Max Pronko
$select = $this->getSelect()->joinInner(
array('sbao' => $this->getTable('sales/billing_agreement_order')),
'main_table.entity_id = sbao.order_id',
array()
);
echo $select;
回答by woot586
I nearly had it for those interested you need to use ->__toString() e.g.
我几乎为那些有兴趣的人准备了它，你需要使用 ->__toString() 例如
echo $this->getSelect()->joinInner(
array('sbao' => $this->getTable('sales/billing_agreement_order')),
'main_table.entity_id = sbao.order_id',
array()
)->__toString()
