当前位置:Gxlcms > PHP教程 > 如何在symfony中导出为CSV文件中的数据_php技巧

如何在symfony中导出为CSV文件中的数据_php技巧

时间:2021-07-01 10:21:17 帮助过:5人阅读

开始:
代码如下:

public function executeRegistrantsToCsv(){

$id = $this->getRequestParameter('id');

$c = new Criteria();
$c->add(RegistrantPeer::EVENT_ID, $id);
$c->add(RegistrantPeer::STATUS, 1);
$this->aObjReg = RegistrantPeer::doSelect($c);

$this->forward404Unless($this->aObjReg);
$this->setlayout('csv');

$this->getResponse()->clearHttpHeaders();
$this->getResponse()->setHttpHeader('Content-Type', 'application/vnd.ms-excel');
$this->getResponse()->setHttpHeader('Content-Disposition', 'attachment; filename=registrants_report_event_' . $id . '.csv');

}

在模板registrantsToCsvSuccess.php:
代码如下:

Title,Name,Email,Phone,Organisation,State,City,Country,Login Date,IpAddress

getTitle() ?>,getName() ?>,getEmail() ?>,getPhone() ?>,getOrganisation() ?>,getState() ?>,getCity() ?>,getCountry() ?>,getLoginDate() ?>,getIpAddress() ?>,


in the templates/csv.php:
getRaw('sf_content') ?>
From: http://blog.baddog.net.au/sonius/steve-sonius/how-to-export-data-as-a-csv-file-in-symfony/
If it doesn't work, try this:http://blog.baddog.net.au/sonius/steve-sonius/how-to-export-data-as-an-xls-or-csv-file-from-the-admin-generator-in-symfony-1-4/

人气教程排行