From the MySQL database query data, how to set a "Download" button on the Web page, and then saved to the local computer txt format?

After the real-time data transfer to the server, the user query for a certain period of time according to the data, and then can choose to download the query to the local computer designated location

Reply content:

After the real-time data transfer to the server, the user query for a certain period of time according to the data, and then can choose to download the query to the local computer designated location

It is easy to use the Blob object in JS to process the data, construct the Bolb object, and then generate the download link. But browsers require support for HTML5.

The database program in the form of TXT export saved to the server, so that after the generation of download links, users click to download

Use the into outfile of the SQL statement to export the query results to a TXT file, and then return this file to the request

