I can't figure out how to get my PHP page to downlaod multiple files.
Where I work the is a regular requirement to extract a load of data from an Oracle database, manipulate it and upload it to another system. Unfortunately, the second system has been designed to only do this in batches of 250 whereas the usual output from the Oracle database is in excess of 5000 records for most of our customers. This means splitting the output up in to batches of 250 records, saving each file as customerid batch x.csv and then uploading it to the second system.
So I've written a little PHP based web page - users can select the criteria from a set of pop-ups, the PHP queries the database, manipulates the data as required and then writes in to files in batches of 250 with file names as described above <customerid> batch x.csv - for example, 0000136163 batch 1.csv
And this is where my plan falls over due to me being "average" with PHP :-)
I can download one file using headers. How do I get my PHP to initiate a download for each file? Or, alternatively, how do I get PHP to put them in to one archive file such as a ZIP and download those?
Thanks for any guidance.
Steve
