Re: [PHP] generate xls file on fly

2008-02-14 Thread Hiep Nguyen
On Fri, 8 Feb 2008, Per Jessen wrote: Hiep Nguyen wrote: let say that user searched and found 10 records, in the meantime, other users may change any of these 10 records, so if we saved mysql statement and re-run mysql statement again, the result might be different. to prevent this problem,

Re: [PHP] generate xls file on fly

2008-02-14 Thread Nirmalya Lahiri
--- Hiep Nguyen [EMAIL PROTECTED] wrote: On Fri, 8 Feb 2008, Per Jessen wrote: Hiep Nguyen wrote: let say that user searched and found 10 records, in the meantime, other users may change any of these 10 records, so if we saved mysql statement and re-run mysql statement again, the

Re: [PHP] generate xls file on fly

2008-02-14 Thread Andrew Ballard
On Thu, Feb 14, 2008 at 9:23 AM, Hiep Nguyen [EMAIL PROTECTED] wrote: On Fri, 8 Feb 2008, Per Jessen wrote: Hiep Nguyen wrote: let say that user searched and found 10 records, in the meantime, other users may change any of these 10 records, so if we saved mysql statement and re-run

Re: [PHP] generate xls file on fly

2008-02-11 Thread Daniel Brown
On Feb 11, 2008 7:41 AM, Hiep Nguyen [EMAIL PROTECTED] wrote: any suggestion for a tutorial on session in php??? thanks. http://www.google.com/search?q=working+with+php+sessions -- /Dan Daniel P. Brown Senior Unix Geek ? while(1) { $me = $mind--; sleep(86400); } ? -- PHP General

Re: [PHP] generate xls file on fly

2008-02-11 Thread Hiep Nguyen
On Fri, 8 Feb 2008, Jason Pruim wrote: On Feb 8, 2008, at 10:14 AM, Hiep Nguyen wrote: 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

Re: [PHP] generate xls file on fly

2008-02-08 Thread Hiep Nguyen
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

Re: [PHP] generate xls file on fly

2008-02-08 Thread Hiep Nguyen
On Fri, 8 Feb 2008, Jason Pruim wrote: On Feb 8, 2008, at 10:14 AM, Hiep Nguyen wrote: 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

Re: [PHP] generate xls file on fly

2008-02-08 Thread Andrew Ballard
On Feb 8, 2008 10:14 AM, Hiep Nguyen [EMAIL PROTECTED] wrote: 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

Re: [PHP] generate xls file on fly

2008-02-08 Thread Daniel Brown
On Feb 8, 2008 8:41 AM, Hiep Nguyen [EMAIL PROTECTED] wrote: hi friends, i have a php page with the following logic: html head titleDownload/title /head table trtdTitle/tdtdAuthor/td/tr ? $sql = select title,author from book where title != null and author != null; ? ? $rs =

Re: [PHP] generate xls file on fly

2008-02-08 Thread Per Jessen
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

Re: [PHP] generate xls file on fly

2008-02-08 Thread Adrian Bruce
Hiep Nguyen wrote: hi friends, i have a php page with the following logic: html head titleDownload/title /head table trtdTitle/tdtdAuthor/td/tr ? $sql = select title,author from book where title != null and author != null; ? ? $rs = mysql_query($sql) or die(mysql_error()); ? ?

Re: [PHP] generate xls file on fly

2008-02-08 Thread Jason Pruim
On Feb 8, 2008, at 10:14 AM, Hiep Nguyen wrote: 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

Re: [PHP] generate xls file on fly

2008-02-08 Thread Per Jessen
Hiep Nguyen wrote: let say that user searched and found 10 records, in the meantime, other users may change any of these 10 records, so if we saved mysql statement and re-run mysql statement again, the result might be different. to prevent this problem, i only want to download records that

RE: [PHP] Generate CSV File and force download

2005-05-12 Thread Jay Blanchard
[snip] Is it possible to create a csv file from a query and force the user to download it by outputting it to the browser, I dont want it saved on the server! [/snip] Just make sure that your mime-type is set to something like octet stream when you creat the csv file -- PHP General Mailing

Re: [PHP] Generate CSV File and force download

2005-05-12 Thread Richard Lynch
On Thu, May 12, 2005 6:54 am, Shaun said: Is it possible to create a csv file from a query and force the user to download it by outputting it to the browser, I dont want it saved on the server! fputcsv('php:/stdout', ...) should work, I think. If not, there are only a few dozen

Re: [PHP] Generate a file

2002-07-11 Thread Miguel Cruz
On Wed, 10 Jul 2002, Phillip S. Baker wrote: Okay here is what I want to do. Select the field of a database that I want. Hit submit. Execute a query of a database based on the said form. Gather all the data and rows and plug them into an excel generated file. Display a dialogue box asking

Re: [PHP] Generate a file

2002-07-10 Thread Alberto Serra
ðÒÉ×ÅÔ! Phillip S. Baker wrote: Now if that is cool, how would I get the data into the downloaded.xls file to have this work? 1) Save the data as a comma-separated list (pap.data.csv). 2) make an excel macro that will load it into a preexisting sheet and treat it 3) put the macro as the

RE: [PHP] Generate a file

2002-07-10 Thread Jay Blanchard
[snip] Select the field of a database that I want. Hit submit. Execute a query of a database based on the said form. Gather all the data and rows and plug them into an excel generated file. Display a dialogue box asking the user the save the file. The saved file being an excel file with data

Re: [PHP] Generate a file

2002-07-10 Thread Marek Kilimajer
Use BiffWriter, I don't know where it lives, you must find it yourself. Phillip S. Baker wrote: Okay here is what I want to do. Select the field of a database that I want. Hit submit. Execute a query of a database based on the said form. Gather all the data and rows and plug them into an