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

score 8 · Accepted Answer · answered Mar 21 '11 at 11:09

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.

score 6 · Answer 2 · edited Jan 31 '12 at 10:59

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 '12 at 10:59

Dunhamzzz

14,682
4
50
74

answered Sep 30 '11 at 16:57

Toni

61
1
1

You should put a note about the language of the page :-) I was quite shocked it wasn't in english :-) :-) – xanatos Oct 01 '11 at 09:45
Dead link... :( – Andron Aug 09 '19 at 09:42

score 0 · Answer 3 · edited May 23 '17 at 11:48

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.

exporting csv in zend framework

3 Answers3