Query database table & ZIP results to download

[djalecc]

Hi

I'm just wondering if it's possible to run a query on the table from within a PHP script, and then zip the results and then start to download the zip file.

example...

select * from table_name where userID = 'joe blogs' AND date = '11/10/2006'

The user is selecting the date of the data they want to download, and when they click 'submit' it gathers the correct info from the database, zips it, then a download box appears to the user.

It would also be good if they could select what type of file to zip, example...

Export CSV

CSV for MS Excel

Microsoft Excel 2000

Microsoft Word 2000

LaTeX

Open Document Spreadsheet

Open Document Text

PDF

SQL

XML

Any ideas 😕

[bogu]

U will need to do:

1. Create the export file.
2. Zip the file using some file arhive lib (ex. Pear File Archive)
3. and make a force download, click here