nuBuilder Forum

Code: Select all

header('Content-Type: application/excel');
header('Content-Disposition: attachment; filename="Truck_Export.csv"');

$sql = "SELECT * FROM customer";
$qry = nuRunQuery($sql);


$fp = fopen('php://output', 'w');

$header = false;
while($obj = db_fetch_array($qry)){

	$size = count($obj)/2;
	for ($i = 0; $i < $size; $i++) {
	  unset($obj[$i]);
	}

	if($header == false) {
		$a       = array();
		foreach ($obj as $key => $value){
			$a[] = $key;
		}
		fputcsv($fp, $a);		
		$header = true;
	}

    fputcsv($fp, $obj);
}
fclose($fp);