PHP Code for CSV export

[arvind.acharya]

Hi,

I am trying to get csv export in Nubuilder pro from mysql table with selected criteria. I had used in Nubuilder 2.8 which had csv export option under php code. How can this be done in Nubuilder PRO?

Regards,

AA

[admin]

AA,

Try running this as PHP Code..

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);

Steven

[arvind.acharya]

Thanks this works..

[admin]

.