[RESOLVED] PHP redirect download file

[mattm591]

Hi,
I have a redirect in PHP like this

header('Location: http://www.mattm591.com'.$dlfile);

This links to a .sql file, but my problem is that it just shows it on the screen and I want it to tell the browser to download it. How can I do this?
Thanks,
Matt

[leatherback]

Hi,

how does it 'point to a file'?

If it is a way to do a database dump, I usually do this on top of the script tat generates the dump:

header("Content-Disposition: attachment; filename=$filename");

and then echo the dump.

[mattm591]

I am using mysqldump which outputs to a file, and doesn't have an echoable output.

[bradgrafelman]

mattm591 wrote:

and doesn't have an echoable output.

On the contrary, it certainly has an "echoable output." [man]fopen/man the file and [man]fread/man all of the "echoable output" you desire! :p

[mattm591]

Ok, I have that all working nicely now thank you except one small thing... how do I get it to tell the browser the file is of type .sql?

I'm trying this

header("Content-type: sql");

but no such luck 🙁

Cheers

[bradgrafelman]

I would instead use "text/plain" as your content-type, if you know that it's going to be a .sql file that is being downloaded. In addition, if you don't get a "Save As" dialogue box, you might need to add this header as well:

header('Content-Disposition: attachment; filename="filename.sql"');

[mattm591]

Cheers. worked fine. I had had that previous header before, the problem was I'd just put a name in and not put the file extension....