MYSQL, EXPORT CSV: Export to csv straight from MySQL - note MySQL may not have permission to write this file to your app directory

gistfile1

$app_directory   = dirname(BASEPATH);
		$export_location = $app_directory . '/assets/exports/';
		$filename        = "export-" . date('Y-m-d H-i-s') . ".csv";
		$export_location = $export_location .  $filename;
		

		$query = $this->db->query("
			SELECT users.id, users.firstname, users.lastname, users.email, users.dob, messages.line1, messages.line2, messages.line3, messages.barcode_selected, address.my_address, address.firstname, address.lastname, address.address1, address.address2, address.town, address.postcode, address.datecreated 
			FROM users
			JOIN messages
			ON users.id = messages.user_id
			JOIN address
			ON users.id = address.user_id 
			INTO OUTFILE '$export_location'
			FIELDS TERMINATED BY ','
			LINES TERMINATED BY '\r\n'
		");