Last Updated | | Ratings | | Unique User Downloads | | Download Rankings |
2023-05-20 (8 months ago) | | Not yet rated by the users | | Total: 77 | | All time: 10,094 This week: 104 |
|
Description | | Author |
This package can download results for a large MySQL query in CSV.
It can take a given SQL query and connects to a given MySQL database server to generate a raw SQL query by replacing prepared parameters using PDO.
The package can execute the mysql command line program to execute the prepare query and output the results to a CSV file in a server directory.
It can also serve the generated CSV file for download. | |
|
|
Innovation award
Nominee: 2x
Winner: 1x |
|
Details
phpDownloadCsv
PHP Download CSV up to millions of records
To enable compression for downloading dynamically generated CSV files in NGINX if the browser supports compression, you can use the gzip_types directive in the NGINX configuration file. The gzip_types directive is used to specify which MIME types should be compressed.
Here's an example of how you can enable compression for downloading dynamically generated CSV files in NGINX:
<code>http {
gzip on;
gzip_types text/plain text/csv;
}</code>
In this example, we have enabled gzip compression and specified that text/plain and text/csv MIME types should be compressed. You can also use the text/* wildcard to include all text-based MIME types.
This configuration will automatically compress the content of dynamically generated CSV files if the browser supports compression, which can significantly reduce the size of the files and speed up their download time.
|
Applications that use this package |
|
No pages of applications that use this class were specified.
If you know an application of this package, send a message to the author to add a link here.