<?
header("Content-type: application/csv");
header("Content-Disposition: attachment; filename=Rusthuizen.csv");
header("Pragma: no-cache");
header("Expires: 0");

include("db.inc.php");
mysqli_connect($hostname,$dbuser,$dbpass);
mysqli_select_db($db);

$t = $_GET['t'];

//$res = mysql_query("SELECT * INTO OUTFILE '/tmp/result.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY ‘\\\\’ LINES TERMINATED BY '\\n' FROM rusthuizen WHERE 1");

if ($t==0) {
	$res = mysqli_query("SELECT * FROM rusthuizen where 1");
	if ($res) {
		echo "\"NAAM\",\"STRAAT\",\"POSTCODE\",\"GEMEENTE\",\"PROVINCIE\",\"TELEFOON\",\"CONTRACT\",\"INDEX\",\"BEF\",\"EURO\",\"LAATSTE OH\",\"OPMERKINGEN\" \n";
		while ($row=mysqli_fetch_object($res)) {
			echo '"' . $row->naam .'","'. $row->straat .'","'. $row->postcode .'","'. $row->gemeente .'","'. $row->provincie .'","'. $row->telefoon .'","'. $row->contract .'","'. $row->index .'","'. $row->bef .'","'. $row->euro .'","'. $row->laatste .'","'. $row->opmerkingen . '"' . "\n";
		}
	}
}

if ($t==1) {
	$res = mysqli_query("SELECT * FROM rusthuizen where 1");
	if ($res) {
		echo "\"NAAM\",\"STRAAT\",\"POSTCODE\",\"GEMEENTE\",\"PROVINCIE\",\"TELEFOON\",\"LAATSTE OH\",\"OPMERKINGEN\" \n";
		while ($row=mysqli_fetch_object($res)) {
			echo '"' . $row->naam .'","'. $row->straat .'","'. $row->postcode .'","'. $row->gemeente .'","'. $row->provincie .'","'. $row->telefoon .'","'. $row->laatste .'","'. $row->opmerkingen . '"' . "\n";
		}
	}
}

mysqli_close();
?>