复制代码 代码如下:
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
<? foreach($aobjreg as $r): ?>
<?= $r->gettitle() ?>,<?= $r->getname() ?>,<?= $r->getemail() ?>,<?= $r->getphone() ?>,<?= $r->getorganisation() ?>,<?= $r->getstate() ?>,<?= $r->getcity() ?>,<?= $r->getcountry() ?>,<?= $r->getlogindate() ?>,<?= $r->getipaddress() ?>,
<? endforeach ?>
in the templates/csv.php:
<?php echo $sf_data->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/
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:)！