exporting csv in zend framework

Question

I know how to export a csv file in php. Now I want to do this task in zendframe work.

1 I want to know is there any built in functionality that zend provides for this purposes or we have to write the same code that we use in simple php?

2 If I have to use same code then where should I put that whether in model or controller?

3 I have a view where user can select start date, last date and user andthen press enter. On the basis of that selection I want to exprot csv file.

Any one guide me how to accomplish this task

David Snabel-Caunt · Accepted Answer · 2011-03-21 11:09:30Z

8

To address your points in order

There is not a component in the Zend Framework that will generate and dispose of CSV files.
Your controller should just collect request parameters (i.e. date ranges from point 3) and initiate a response. I would create another class which can generate a CSV and then use this Controller Action Helper, SendFile to actually send the CSV file as a download.
Have your controller receive the request parameters using a form. Generate a CSV using your class (point 2) and then use the helper to send the response.

For generating CSV files it's recommended to use fputcsv rather than building strings yourself.

answered Mar 21, 2011 at 11:09

David Snabel-Caunt

58.4k13 gold badges118 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dunhamzzz · Accepted Answer · 2012-01-31 10:59:04Z

6

Here is a Zend Framework Action Helper - may be helpful. Note the site and code comments are in German. http://blog.abmeier.de/zend-csv-action-helper

edited Jan 31, 2012 at 10:59

Dunhamzzz

14.8k4 gold badges54 silver badges74 bronze badges

answered Sep 30, 2011 at 16:57

Toni

611 silver badge1 bronze badge

2 Comments

xanatos Over a year ago

You should put a note about the language of the page :-) I was quite shocked it wasn't in english :-) :-)

Andron Over a year ago

Dead link... :(

Community · Accepted Answer · 2017-05-23 11:48:33Z

0

Building on regilero's answer for this question, I did come up with a Zend solution. Just use a complete query on the database itself:

$result = $this->_db->query(
     'SELECT * FROM `table_xy`'
    .'INTO OUTFILE \'tmp/outputfile.csv\''
    .'FIELDS TERMINATED BY \';\''
    .'ENCLOSED BY \'"\''
    .'LINES TERMINATED BY \'\\n\''
);

Just don't forget to set up the necessary privileges for that user.

edited May 23, 2017 at 11:48

CommunityBot

11 silver badge

answered Apr 15, 2015 at 14:23

WoodrowShigeru

1,6621 gold badge20 silver badges29 bronze badges

Collectives™ on Stack Overflow

exporting csv in zend framework

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related