Re: generate xls file on fly

On Fri, 8 Feb 2008, Per Jessen wrote:

Hiep Nguyen wrote:

is there anyway to generate this into xls file w/o using fopen & fwrite to the server? my goal is to have a link after the table and user can click on that link and a save window pop up to allow user to save to local disk.

Yes - have a link like this: <a href="<yourscript.php?parameters>">Get XLS file</a> in yourscript.php, you evaluate the parameters given and build the XSL file as output: header("Content-Type: application/excel"); header("Content-Disposition: attachment; filename=\"filename\""); print . . . . . done.

i already got this method, but the problem that i have is the parameters is mysql statement and it's very long. i don't think a good idea to pass this in the url. also, the page that i'm working on is a search page, therefore the mysql statement is very complicate and long. that's why i don't want to pass via url. is there way to do within this page??? t. hiep