如何在PHP中运行MySQL查询并将数据发送回浏览器？ [关闭]

Question

I am trying to export a MySQL database using PHP, I want the data to be saved to the users computer, I want this data to be saved as a .sql file. I am trying to make it as simple as phpmyadmin.

I have tried everything I can find on Google.

I have tried to do mysql dumps, custom scripts, but they all write the data to the server, never the client computer.

All help is appreciated!

Answer 1

You need to use header() to set an appropriate content type and output the data.

Normal output is sent to the user as Content-Type: text/html

If you want to send output as a text document, use:

header('Content-type: text/plain');
header('Content-Disposition: attachment; filename="yourfilename.sql"');
echo $your_sql_content;