nuBuilder Forum

Code: Select all

// output headers so that the file is downloaded rather than displayed
header('Content-Type: text/csv; charset=utf-8');
header('Content-Disposition: attachment; filename=ExpTaxCustomers.csv');

// create a file pointer connected to the output stream
$output = fopen('php://output', 'w');

// output the column headings of my table
fputcsv($output, array('TaxCustomers_id', 'cust_prissn', 'cust_retdate', 'cust_lastname', 'cust_firstname', 'cust_midinit', 'cust_surname', 'cust_spouse',  'tax_office', 'tax_comments', 'count'));

// fetch the data from the temporary table $tabid - I know this table exists and has the correct data in it.  I checked my nudebug to make sure its using the correct table name.
$expsql = "SELECT * From $tabid";
nuDebug($expsql);
$t = nuRunQuery($expsql);


// loop over the rows, outputting them  this should output the rows to the output device.
while($r = db_fetch_array($t)){
   fputcsv($output, $r);
} //end While Loop

Code: Select all

// output headers so that the file is downloaded rather than displayed
$fileName = "ExpTaxCustomers.csv";

header('Content-Type: application/excel');
header('Content-Encoding: UTF-8');
header('Content-Disposition: attachment; filename="' . $fileName . '"');

// create a file pointer connected to the output stream
$output = fopen('php://output', 'w');

Code: Select all

// fetch the data
$expsql = "SELECT * From $tabid";
nuDebug($expsql);
$t = nuRunQuery($expsql);

// loop over the rows, outputting them
while($r = db_fetch_row($t)){
   fputcsv($output, $r);
} //end While Loop

//Close the file pointer.
fclose($output);

Code: Select all

/ Drop the Temporary data table 
$dropsql = "DROP TABLE IF EXISTS $tabid";
nuDebug($dropsql);
$t = nuRunQuery($dropsql);