如何使用 Zend 框架使用 mySQL 的 INTO OUTFILE 功能导出到 CSV

2021-12-29 00:00:00 sql mysql zend-framework zend-db into-outfile

我希望使用 Zend Framework 将大量数据导出到 CSV 文件中以供用户下载.有什么方法可以使用 Zend_Db 的功能并使用INTO OUTFILE"语法将文件输出为 csv?基本上我希望能够调整我的 Zend_Db 模型以导出到一个 csv 文件而不是返回一个 PHP 数组.我想使用的 mysql 语法的一个例子是:

I am looking to export a large amount of data into a CSV file for user download using Zend Framework. Is there any way to use Zend_Db's functionaity and use the "INTO OUTFILE" syntax to output the file as a csv? Basically I want to be able to adapt my Zend_Db models to export to a csv file instead of returning a PHP array. An example of the mysql syntax I want to use would be: 

SELECT a,b,a+b INTO OUTFILE '/tmp/result.text' 
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' 
LINES TERMINATED BY '
' 
FROM test_table;

推荐答案

您可以尝试构建一个基本查询，将其转换为字符串，然后从那里追加.优点是您可以使用 Zend 的绑定功能(至少对于 where 子句)，以防万一.像这样:

You can try to build a base query, convert it to a string and then append from there. The advantage being that you can use Zend's bind functionality (at least for the where clause), in case you need that. Like so:

$filename = 'tmp/test.csv';
$value = 'given';

 // build base query making use of Zend´s binding feature.
$select = $this->_db->select()
    ->from(test_table, array(a,b,a+b))
    ->where('column = ?', $value)
    ->__toString()

 // append the rest of the query.
.' INTO OUTFILE "'. $filename .'"'
.' FIELDS TERMINATED BY ";"'
.' OPTIONALLY ENCLOSED BY "\""'
.' LINES TERMINATED BY "\n"';

 // execute query.
$this->_db->query($select);

相关文章