Developing (v7+)

Export CSV File

Permalink November 24, 2013 at 6:26 AM

I have a single page and in the controller a function which queries the database and formats the results into csv format. What i want to do is prompt the browser. I have my headers but if i echo to the single page it does nothing. If i put the code in the view function it will download when i visit the page, but i want to pass parameters to it first.

Does any one know how can i get the browser to prompt for the download?

mhawke replied on Nov 24, 2013 at 6:53 am Permalink Best Answer Reply

Just a concept... can you use the single page to build a link to the view.php that includes the required parameters so you end up with a link something like this rendered on your single page:

[code]
<a href="path/to/view.php?column1=first_name&column2=last_name">Download CSV file</a>
[code]

kingdt replied on Nov 25, 2013 at 5:22 am Permalink Reply

Thanks mhawke, works a treat.

What i did was to create a new empty single page and copy my existing controller with the code. I'm using a select list to select a date, so i changed the href attribute of the link each time a new date was selected.

My js in the page to change the link

$('#week_list').change(function(){
   var weekLink = '<?php echo $this->url('/download_times/request/?week_date=') ?>';
   var weekDate = $('#week_list option:selected').text();
   var link = document.getElementById("requestLink");
   link.setAttribute("href", weekLink + weekDate);
   return false;
})

My link

<a href='#' id="requestLink">Download Times</a>

My controller

public function view(){
   $db = Loader::db();
   $js = Loader::helper('json');
   $week_date = $_REQUEST['week_date'];
   $sql = "SHOW FIELDS FROM table";
   $colResult = $db->GetAll($sql);
   $headRow = [];
   foreach($colResult as $row){ $headRow[] = $row[Field]; }
   // Fetch Record from Database
   $sql = "SELECT * FROM table WHERE week_date = ?";
   $rowResult = $db->GetAll($sql,array($week_date));
   header("Content-type: text/csv");  
   header("Cache-Control: no-store, no-cache");  
   header('Content-Disposition: attachment; filename="hi.csv"'); 
   $out = fopen('php://output', 'w');

Viewing 15 lines of 22 lines. View entire code block.

 
public function view(){
   $db = Loader::db();
   $js = Loader::helper('json');
   $week_date = $_REQUEST['week_date'];
   $sql = "SHOW FIELDS FROM table";
   $colResult = $db->GetAll($sql);
   $headRow = [];
   foreach($colResult as $row){ $headRow[] = $row[Field]; }
 
   // Fetch Record from Database
   $sql = "SELECT * FROM table WHERE week_date = ?";
   $rowResult = $db->GetAll($sql,array($week_date));
 
   header("Content-type: text/csv");  
   header("Cache-Control: no-store, no-cache");  
   header('Content-Disposition: attachment; filename="hi.csv"'); 
 
   $out = fopen('php://output', 'w');
 
   fputcsv($out, $headRow);
 
   // Get Records from the table
   foreach($rowResult as $row){ fputcsv($out, $row); }
 
   fclose($out);
   die; //stops Resource id from being included in the output
 
   exit();
}

Forums

Developing (v7+)

Export CSV File

Code

Post Reply

Delete Post

Mark Post as Spam

Destroy Spammer

Sign In?