Export to CSV (MySQL)

exporttocsv

<?php
	$conn = mysqli_connect('localhost','user','pw') or die(mysqli_error());
	$db=mysqli_select_db($conn,'database') or die(mysqli_error());

	$filename = 'filename-' . date("d-m-Y") . '.csv';

	header( 'Cache-Control: must-revalidate, post-check=0, pre-check=0' );
	header( 'Content-Description: File Transfer' );
	header( 'Content-type: text/csv' );
	header( "Content-Disposition: attachment; filename={$filename}" );
	header( 'Expires: 0' );
	header( 'Pragma: public' ); 

	$select_table=mysqli_query($conn,'select * from table');
	$rows = mysqli_fetch_assoc($select_table);

	if ($rows) {
		getcsv(array_keys($rows));
	}
	while($rows)
	{
		getcsv($rows);
		$rows = mysqli_fetch_assoc($select_table);
	}

	function getcsv($no_of_field_names)
	{
		$seperate = '';
		foreach ($no_of_field_names as $field_name)
	{
		if (preg_match('/\\r|\\n|,|"/', $field_name))
	{
		$field_name = '' . str_replace('', $field_name) . '';
	}
	echo $seperate . $field_name;
	$seperate = ',';
	}
	echo "\r\n";
	}
?>