ProAnswers.org

Create a CSV file in PHP

I have data in a MySQL database. I am sending the user a URL to get their data out as a CSV file.

I have the e-mailing of the link, MySQL query, etc. covered.

How can I, when they click the link, have a pop-up to download a CVS with the record from MySQL?

I have all the information to get the record already. I just don’t see how to have PHP create the CSV file and let them download a file with a .csv extension.

Try this

			header("Content-type: application/csv"); 
			header("Content-Disposition: attachment; filename=file.csv"); 
			header("Pragma: no-cache"); 
			header("Expires: 0"); 
			 
			echo "record1,record2,record3

";