offer dump file of db with php

[rubing]

good evening folks.

 

I have a website, which logs a lot of client info to a mysql database.  I want to offer these logs to the client as a file download (csv, sql, whatever...)

 

so, I know its easy to create a dump file of a database with the mysql dump command.  But I am confused as to how to let a customer download a dump of their customer data.

 

I guess basically I am asking how do I get php to present a file for download to the client???

[ratcateme]

try this

// We'll be outputting a PDF
header('Content-type: text/plain');

// It will be called downloaded.pdf
header('Content-Disposition: attachment; filename="database.sql"');

echo `mysqldump -ppassword -uusername database`;

 

Scott.

[rubing]

yup.  works great!!  apreciate it scott!!! thanks.