您好,欢迎访问一九零五行业门户网

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

开始:
复制代码 代码如下:
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:
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/ 以上就介绍了symfony 如何在symfony中导出为csv文件中的数据,包括了symfony方面的内容,希望对php教程有兴趣的朋友有所帮助。
其它类似信息

推荐信息