<?php
	$host = 'mysql021.phy.lolipop.lan';
	$user = 'LAA0558236';
	$pass = 'HGRd0N1y';
	$db = 'LAA0558236-c9bax4';
	$table = 'wp1_usermeta';
	$file = 'export';

	$link = mysql_connect($host, $user, $pass) or die("Can not connect." . mysql_error());
	mysql_select_db($db) or die("Can not connect.");

	$result = mysql_query("SELECT * FROM ".$table." WHERE NOT user_id = 1 ");
	$i = 0;
	if (mysql_num_rows($result) > 0) {
	while ($row = mysql_fetch_assoc($result)) {
		$csv_output .= "User ID"."\t";
		$csv_output .= "Name"."\t";
		$csv_output .= "Date of Birth"."\t";
		$csv_output .= "Address"."\t";
		$csv_output .= "Email"."\t";
		$csv_output .= "Annual Income"."\t";
		$csv_output .= "Doctor ID"."\t";
		$csv_output .= "Reg. No"."\t";
		$csv_output .= "Username"."\t";
		$csv_output .= "Password"."\t";
		$i++;
	}
	}
	$csv_output .= "\n";

	$values = mysql_query("SELECT * FROM ".$table."");
	while ($rowr = mysql_fetch_row($values)) {
	for ($j=0;$j<$i;$j++) {
	$csv_output .= $rowr[$j]." ";
	}
	$csv_output .= "\n";
	}

	$filename = $file."_".date("Y-m-d_H-i",time());
	header("Content-type: application/vnd.ms-excel");
	header("Content-disposition: csv" . date("Y-m-d") . ".csv");
	header( "Content-disposition: filename=".$filename.".csv");
	print $csv_output;
	exit;
?>