StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>This solution is for CakePHP 2.0.. u can also integrate it in CakePHP 1.3</p> <p>Step 1: Save the following file as Csv.php into your app/View/Helper directory</p> <pre><code><?php class CsvHelper extends AppHelper { var $delimiter = ','; var $enclosure = '"'; var $filename = 'Export.csv'; var $line = array(); var $buffer; function CsvHelper() { $this->clear(); } function clear() { $this->line = array(); $this->buffer = fopen('php://temp/maxmemory:'. (5*1024*1024), 'r+'); } function addField($value) { $this->line[] = $value; } function endRow() { $this->addRow($this->line); $this->line = array(); } function addRow($row) { fputcsv($this->buffer, $row, $this->delimiter, $this->enclosure); } function renderHeaders() { header('Content-Type: text/csv'); header("Content-type:application/vnd.ms-excel"); header("Content-disposition:attachment;filename=".$this->filename); } function setFilename($filename) { $this->filename = $filename; if (strtolower(substr($this->filename, -4)) != '.csv') { $this->filename .= '.csv'; } } function render($outputHeaders = true, $to_encoding = null, $from_encoding ="auto") { if ($outputHeaders) { if (is_string($outputHeaders)) { $this->setFilename($outputHeaders); } $this->renderHeaders(); } rewind($this->buffer); $output = stream_get_contents($this->buffer); if ($to_encoding) { $output = mb_convert_encoding($output, $to_encoding, $from_encoding); } return $this->output($output); } } ?> </code></pre> <p>Step 2: Add this Helper to your controller:</p> <pre><code>var $helpers = array('Html', 'Form','Csv'); </code></pre> <p>Step 3: create a method “download” at controller for eg. homes_controller.php</p> <pre><code><?php function download() { $this->set('orders', $this->Order->find('all')); $this->layout = null; $this->autoLayout = false; Configure::write('debug', '0'); } ?> </code></pre> <p>Step 4: put this link on page from where you have to download CSV</p> <pre><code><?php echo $this->Html->link('Download',array('controller'=>'homes','action'=>'download'), array('target'=>'_blank')); ?> </code></pre> <p>Step: 5 (final step)</p> <p>Put this code on View/Homes/download.ctp</p> <pre><code><?php $line= $orders[0]['Order']; $this->CSV->addRow(array_keys($line)); foreach ($orders as $order) { $line = $order['Order']; $this->CSV->addRow($line); } $filename='orders'; echo $this->CSV->render($filename); ?> </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload