interface/batchcom/batchCSV.php

   1 <?php
   2 /*
   3         batch CSV processor, included from batchcom
   4 */
   5
   6 // create file header.
   7 // menu for fields could be added in the future
   8
   9 while ($row=sqlFetchArray($res)) {
  10
  11         if (!$flag_on) {
  12                 $flag_on=TRUE;
  13                 foreach ($row as $key => $value ){
  14                         $file.="$key,";
  15                 }
  16                 $file=substr($file,0,-1);
  17                 $file.="\n";
  18                 reset ($row);
  19         }
  20
  21         foreach ($row as $key => $value) {
  22                 $line.="$value,";
  23         }
  24         $line=substr($line,0,-1);
  25         $line.="\n";
  26         $file.=$line;
  27         $line='';
  28
  29 }
  30
  31 //download
  32 $today=date('Y-m-d:H:i:s');
  33 $filename="CSVdata-".$today.".csv";
  34 header('Pragma: private');
  35 header('Cache-control: private, must-revalidate');
  36 header("Content-type: text/comma-separated-values");
  37 header("Content-Disposition: attachment; filename=".$filename);
  38 print $file;
  39 exit()
  40 ?>