Posted by Brian on 05/26/05 23:04

"Paul" <freelance@dezignage.net> wrote in message
news:6%ole.1488412$8l.1142606@pd7tw1no...
> Brian wrote:
>> "Paul" <freelance@dezignage.net> wrote in message
>> news:Z_9le.1484742$6l.812316@pd7tw2no...
>>
>>>Brian wrote:
>>>
>>>>This site I am working on is driving me up the F*****g wall ! , sorry
>>>>just needed to get
>>>>that of my chest
>>>>
>>>>I have site that run a MySQL query, there are many permutations of this
>>>>query depending
>>>>on what the users asks for (about 50 I think).
>>>>
>>>>I also need to save the queryed results into a CSV file and zip it on
>>>>the fly. I have the
>>>>code to do this (makezip.php), first of all I tried sending the MySQL
>>>>query to makezip.php
>>>>, this didn't work (see post Re: sending a MySQL query) so I am now
>>>>trying a different way.
>>>>
>>>>search.php runs the search and displays the results on the screen. It
>>>>also creates a var called $filedata,
>>>>the var is the data to be zipped up
>>>>
>>>>makezip.php has the class to make the zip file.
>>>>
>>>>what I was trying to get the following to work........
>>>>
>>>>run the search.php, this give me the var $filedata I need. Have a link
>>>>on this page to
>>>>another file called savezip.php, this links runs another page called
>>>>savezip.php that
>>>>calls the below code.
>>>>
>>>>(the code needed to exicute making a zip file)
>>>>
>>>>include("search.php");
>>>>include("makezip.php");
>>>>
>>>>$zipfile = new zipfile();
>>>>$zipfile -> add_file($filedata, "test.csv");
>>>>header("Content-type: application/octet-stream");
>>>>header("Content-disposition: attachment; filename=newtest.zip");
>>>>echo $zipfile -> file();
>>>>
>>>>I was hopping that when the link is clicked it run, it would read the
>>>>var $filedata from the search.php
>>>>and create the zip file for downloading, instead the savezip.php is
>>>>reading in and displaying
>>>>the search.php.
>>>>
>>>>I can't past the $filedata to save.php as its way to big, How can I get
>>>>round this? How can I get the
>>>>savezip.php to read the $filedata from search.php but without including
>>>>the whole script?
>>>>
>>>>Once again thanks in advance,
>>>>
>>>>
>>>>Brian
>>>>
>>>>
>>>>
>>>
>>>Why don't you include your zipfile.php as part of search.php? then it
>>>becomes one script and then you won't need to pass it anywhere... or have
>>>your search.php at least create the zip file.. and then all you need to
>>>pass is the URL of the zip file to your other file that the user can
>>>click on and downlaod it from there...?
>>
>>
>> The problem is that I need to change the headers when the script is
>> called
>> this way a pop up window appears to download the zip file. This zip file
>> is done on the fly and no copies are made on the server so I can't put a
>> link to it (done this way so the server does not get filled up with zip
>> files)
>>
>> Brian
>>
>>
>>
> I see.. I don't know how much data it is you're trying to pass from one
> script to the other... but I would say you're best solution is to probably
> use sessions... If still too big... I would recommend this solution for
> you:
>
> #1. searc.php -> User searches for whatever it is they need... where they
> have a link to download the content... the links points to your
> zipfile.php (or whatever it was) ... which passes it the exact same search
> query. Now zipfile.php is pretty much and identical copy of search.php
> except all the output is held back and used for the zip file that will be
> created in it.
>
> #2. Script takes all the output, (maybe you can even use the output
> buffering functions in php if you don't need to change much of the output
> that will be zipped up) and zips it up into the file....
>
> #3. First output to the browser is the proper headers for the download...
> and the script sends it the zip file...
>
> I don't know if that makes sense.... but I think it could work...
>
> Take care,
>
> Paul

Hi Paul

passes the query was my first idea, but that didn't work (see my post
Re: sending a MySQL query)
I am now thinking of setting a cookie with the query in it, read it in, run
it
and the delete it.
If that doesn't work, I'm running out of ideas !!!

Thanks for your help mate

Brian

[Back to original message]