Re: [PHP] Exporting large data from mysql to html using php

2011-11-03 Thread Ashley Sheridan
On Wed, 2011-11-02 at 19:47 -0400, Jason Pruim wrote: Jason Pruim li...@pruimphotography.com On Oct 31, 2011, at 7:52 PM, Ashley Sheridan wrote: On Mon, 2011-10-31 at 19:29 -0400, Jason Pruim wrote: Jason Pruim li...@pruimphotography.com On Oct 31, 2011, at 7:11 PM,

Re: [PHP] Exporting large data from mysql to html using php

2011-11-02 Thread Jason Pruim
Jason Pruim li...@pruimphotography.com On Oct 31, 2011, at 7:52 PM, Ashley Sheridan wrote: On Mon, 2011-10-31 at 19:29 -0400, Jason Pruim wrote: Jason Pruim li...@pruimphotography.com On Oct 31, 2011, at 7:11 PM, Jim Lucas wrote: On 10/24/2011 5:50 PM, Jason Pruim wrote: Now

Re: [PHP] Exporting large data from mysql to html using php

2011-10-31 Thread Jim Lucas
On 10/24/2011 5:50 PM, Jason Pruim wrote: Now that I've managed to list 3 separate programming languages and somewhat tie it back into php here's the question... I have about 89 million records in mysql... the initial load of the page takes 2 to 3 minutes, I am using pagination, so I have

Re: [PHP] Exporting large data from mysql to html using php

2011-10-31 Thread Jason Pruim
Jason Pruim li...@pruimphotography.com On Oct 31, 2011, at 7:11 PM, Jim Lucas wrote: On 10/24/2011 5:50 PM, Jason Pruim wrote: Now that I've managed to list 3 separate programming languages and somewhat tie it back into php here's the question... I have about 89 million records in

Re: [PHP] Exporting large data from mysql to html using php

2011-10-31 Thread Ashley Sheridan
On Mon, 2011-10-31 at 19:29 -0400, Jason Pruim wrote: Jason Pruim li...@pruimphotography.com On Oct 31, 2011, at 7:11 PM, Jim Lucas wrote: On 10/24/2011 5:50 PM, Jason Pruim wrote: Now that I've managed to list 3 separate programming languages and somewhat tie it back into php

Re: [PHP] Exporting large data from mysql to html using php

2011-10-27 Thread Lester Caine
Jim Giner wrote: Your boss wants to give access to phone numbers to the public in general? Then what? Glad mine's unlisted. Is it? Does it start 518248 ? I often forget to get a phone number when a parcel has to go by carrier, and paypal does not include that info, but only rarely does one

Re: [PHP] Exporting large data from mysql to html using php

2011-10-27 Thread David Robley
Jim Giner wrote: David Robley robl...@aapt.net.au wrote in message news:49.50.34068.1b567...@pb1.pair.com... Consider running EXPLAIN on all your queries to see if there is something Mysql thinks could be done to improve performance. Why do so many responders seem to think the problem

Re: [PHP] Exporting large data from mysql to html using php

2011-10-27 Thread Tommy Pham
On Wed, Oct 26, 2011 at 5:47 PM, Jason Pruim li...@pruimphotography.comwrote: Jason Pruim li...@pruimphotography.com The server that's running it is a home computer with a VPS installed... It's not my dev environment :) Home computer used for a production environment? Wow.. I'm

Re: [PHP] Exporting large data from mysql to html using php

2011-10-27 Thread Nathan Nobbe
On Mon, Oct 24, 2011 at 6:50 PM, Jason Pruim li...@pruimphotography.comwrote: Now that I've managed to list 3 separate programming languages and somewhat tie it back into php here's the question... I have about 89 million records in mysql... the initial load of the page takes 2 to 3 minutes,

Re: [PHP] Exporting large data from mysql to html using php

2011-10-27 Thread Jim Giner
Good luck, that's a LOT of reading. I'd estimate that's about 3k+ pages of reading. :) Regards, Tommy nice to see someone else is finally getting the point that I'm been making. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP] Exporting large data from mysql to html using php

2011-10-27 Thread Jason Pruim
Jason Pruim li...@pruimphotography.com On Oct 27, 2011, at 2:44 PM, Tommy Pham wrote: On Wed, Oct 26, 2011 at 5:47 PM, Jason Pruim li...@pruimphotography.com wrote: Jason Pruim li...@pruimphotography.com The server that's running it is a home computer with a VPS installed... It's

Re: [PHP] Exporting large data from mysql to html using php

2011-10-27 Thread Jason Pruim
Jason Pruim li...@pruimphotography.com On Oct 27, 2011, at 4:08 PM, Nathan Nobbe wrote: On Mon, Oct 24, 2011 at 6:50 PM, Jason Pruim li...@pruimphotography.com wrote: Now that I've managed to list 3 separate programming languages and somewhat tie it back into php here's the question...

Re: [PHP] Exporting large data from mysql to html using php

2011-10-26 Thread Lester Caine
Tommy Pham wrote: It turns out the issue was actually in the pagination... I'm reworking the whole thing and stream lining it... But in the pagination that I found on the internet it used a SELECT COUNT(*) WHERE state='{$state}'; and the COUNT was killing the time... Once that was removed,

Re: [PHP] Exporting large data from mysql to html using php

2011-10-26 Thread Tommy Pham
On Wed, Oct 26, 2011 at 12:52 AM, Lester Caine les...@lsces.co.uk wrote: Tommy Pham wrote: It turns out the issue was actually in the pagination... I'm reworking the whole thing and stream lining it... But in the pagination that I found on the internet it used a SELECT COUNT(*) WHERE

Re: [PHP] Exporting large data from mysql to html using php

2011-10-26 Thread Lester Caine
Tommy Pham wrote: I wonder ... The real question is what's the purpose of the DB? Is it for OLAP or OLTP? ;) As for dealing with DB having millions of rows, you're crossing over into DBA area. Many of my customers have coming up on 20 years of data available. There has been a debate on

Re: [PHP] Exporting large data from mysql to html using php

2011-10-26 Thread Tommy Pham
On Wed, Oct 26, 2011 at 1:40 AM, Lester Caine les...@lsces.co.uk wrote: Tommy Pham wrote: I wonder ... The real question is what's the purpose of the DB? Is it for OLAP or OLTP? ;) As for dealing with DB having millions of rows, you're crossing over into DBA area. Many of my customers

Re: [PHP] Exporting large data from mysql to html using php

2011-10-26 Thread Lester Caine
Tommy Pham wrote: Many of my customers have coming up on 20 years of data available. There has been a debate on transferring historic data to a separate database, but having it available is not causing a problem, except for some counts and larger search actions, and being able

Re: [PHP] Exporting large data from mysql to html using php

2011-10-26 Thread Tommy Pham
On Wed, Oct 26, 2011 at 4:14 AM, Lester Caine les...@lsces.co.uk wrote: Tommy Pham wrote: Many of my customers have coming up on 20 years of data available. There has been a debate on transferring historic data to a separate database, but having it available is not causing a

Re: [PHP] Exporting large data from mysql to html using php

2011-10-26 Thread Jason Pruim
Jason Pruim li...@pruimphotography.com On Oct 26, 2011, at 6:23 AM, Tommy Pham wrote: On Wed, Oct 26, 2011 at 1:40 AM, Lester Caine les...@lsces.co.uk wrote: Tommy Pham wrote: I wonder ... The real question is what's the purpose of the DB? Is it for OLAP or OLTP? ;) As for dealing

Re: [PHP] Exporting large data from mysql to html using php

2011-10-26 Thread Jim Giner
Your boss wants to give access to phone numbers to the public in general? Then what? Glad mine's unlisted. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Exporting large data from mysql to html using php

2011-10-26 Thread Jason Pruim
Jason Pruim li...@pruimphotography.com On Oct 26, 2011, at 9:09 PM, Jim Giner wrote: Your boss wants to give access to phone numbers to the public in general? Then what? Glad mine's unlisted. There's no identifying information on the phone numbers... Simply just the phone number...

Re: [PHP] Exporting large data from mysql to html using php

2011-10-25 Thread Jim Giner
I disagree. It's not about tuning the queries, it is more about the appl. design that currently thinks it SHOULD do such huge queries. My approach would be to prompt the user for filtering criteria that automatically would reduce the result set size. Although at this time I believe the OP

Re: [PHP] Exporting large data from mysql to html using php

2011-10-25 Thread Jason Pruim
Jason Pruim li...@pruimphotography.com On Oct 25, 2011, at 10:51 AM, Jim Giner wrote: I disagree. It's not about tuning the queries, it is more about the appl. design that currently thinks it SHOULD do such huge queries. My approach would be to prompt the user for filtering criteria

Re: [PHP] Exporting large data from mysql to html using php

2011-10-25 Thread Jim Giner
Again why even do a detail query? Nobody is going to examine pages and pages and etc. Do a summary qry if u just need a count - no pagination there jg On Oct 25, 2011, at 6:26 PM, Jason Pruim li...@pruimphotography.com wrote: Jason Pruim li...@pruimphotography.com On Oct 25,

Re: [PHP] Exporting large data from mysql to html using php

2011-10-25 Thread Jason Pruim
Jason Pruim li...@pruimphotography.com On Oct 25, 2011, at 6:35 PM, Jim Giner wrote: Again why even do a detail query? Nobody is going to examine pages and pages and etc. Do a summary qry if u just need a count - no pagination there jg The bosses wanted them to be able to page

Re: [PHP] Exporting large data from mysql to html using php

2011-10-25 Thread Bastien
On 2011-10-25, at 6:56 PM, Jason Pruim li...@pruimphotography.com wrote: Jason Pruim li...@pruimphotography.com On Oct 25, 2011, at 6:35 PM, Jim Giner wrote: Again why even do a detail query? Nobody is going to examine pages and pages and etc. Do a summary qry if u just

Re: [PHP] Exporting large data from mysql to html using php

2011-10-25 Thread Jim Giner
David Robley robl...@aapt.net.au wrote in message news:49.50.34068.1b567...@pb1.pair.com... Consider running EXPLAIN on all your queries to see if there is something Mysql thinks could be done to improve performance. Why do so many responders seem to think the problem here is in the

Re: [PHP] Exporting large data from mysql to html using php

2011-10-25 Thread David Robley
Jason Pruim wrote: Jason Pruim li...@pruimphotography.com On Oct 25, 2011, at 10:51 AM, Jim Giner wrote: I disagree. It's not about tuning the queries, it is more about the appl. design that currently thinks it SHOULD do such huge queries. My approach would be to prompt the

Re: [PHP] Exporting large data from mysql to html using php

2011-10-25 Thread Jason Pruim
Jason Pruim li...@pruimphotography.com On Oct 25, 2011, at 9:58 PM, Jim Giner wrote: David Robley robl...@aapt.net.au wrote in message news:49.50.34068.1b567...@pb1.pair.com... Consider running EXPLAIN on all your queries to see if there is something Mysql thinks could be done to

Re: [PHP] Exporting large data from mysql to html using php

2011-10-25 Thread Jim Giner
- Original Message - From: Jason Pruim li...@pruimphotography.com To: Jim Giner jim.gi...@albanyhandball.com Cc: php-general@lists.php.net Sent: Tuesday, October 25, 2011 10:06 PM Subject: Re: [PHP] Exporting large data from mysql to html using php It turns out the issue was actually

Re: [PHP] Exporting large data from mysql to html using php

2011-10-25 Thread Jason Pruim
: [PHP] Exporting large data from mysql to html using php It turns out the issue was actually in the pagination... I'm reworking the whole thing and stream lining it... But in the pagination that I found on the internet it used a SELECT COUNT(*) WHERE state='{$state}'; and the COUNT

Re: [PHP] Exporting large data from mysql to html using php

2011-10-25 Thread Tommy Pham
On Tue, Oct 25, 2011 at 7:06 PM, Jason Pruim li...@pruimphotography.comwrote: It turns out the issue was actually in the pagination... I'm reworking the whole thing and stream lining it... But in the pagination that I found on the internet it used a SELECT COUNT(*) WHERE state='{$state}'; and

[PHP] Exporting large data from mysql to html using php

2011-10-24 Thread Jason Pruim
Now that I've managed to list 3 separate programming languages and somewhat tie it back into php here's the question... I have about 89 million records in mysql... the initial load of the page takes 2 to 3 minutes, I am using pagination, so I have LIMIT's on the SQL query's... But they just

Re: [PHP] Exporting large data from mysql to html using php

2011-10-24 Thread Shiplu Mokaddim
2-3 minutes is long enough. I think your SELECT query and MySQL schema has something that can be improved. Sent from a handheld device. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Exporting large data from mysql to html using php

2011-10-24 Thread Bastien
On 2011-10-24, at 8:50 PM, Jason Pruim li...@pruimphotography.com wrote: Now that I've managed to list 3 separate programming languages and somewhat tie it back into php here's the question... I have about 89 million records in mysql... the initial load of the page takes 2 to 3 minutes,

Re: [PHP] Exporting large data from mysql to html using php

2011-10-24 Thread Jim Giner
Why would any user need to have access to 89M records? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Exporting large data from mysql to html using php

2011-10-24 Thread Bastien
On 2011-10-24, at 10:44 PM, Jim Giner jim.gi...@albanyhandball.com wrote: Why would any user need to have access to 89M records? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php History or audit trail data? I can think of lots. I

Re: [PHP] Exporting large data from mysql to html using php

2011-10-24 Thread Jason Pruim
On Oct 24, 2011, at 10:44 PM, Jim Giner wrote: Why would any user need to have access to 89M records? They don't need access to it to edit it... Just to be able to view it... Also, it will be expanding in the future to include alot more data. Jason Pruim li...@pruimphotography.com --

Re: [PHP] Exporting large data from mysql to html using php

2011-10-24 Thread Jason Pruim
Jason Pruim li...@pruimphotography.com On Oct 24, 2011, at 9:20 PM, Bastien wrote: On 2011-10-24, at 8:50 PM, Jason Pruim li...@pruimphotography.com wrote: Now that I've managed to list 3 separate programming languages and somewhat tie it back into php here's the question... I

Re: [PHP] Exporting large data from mysql to html using php

2011-10-24 Thread Jim Giner
Yes - but - we're talking about a user-app that the OP is trying to provide 89M records to. Sure - some users might have need of looking at even as much as a million records IF they were researching something that needed it. But - for the 'general' user of an app - I cannot see a need to be

Re: [PHP] Exporting large data from mysql to html using php

2011-10-24 Thread Bastien
On 2011-10-24, at 11:26 PM, Jim Giner jim.gi...@albanyhandball.com wrote: Yes - but - we're talking about a user-app that the OP is trying to provide 89M records to. Sure - some users might have need of looking at even as much as a million records IF they were researching something that

Re: [PHP] Exporting large data from mysql to html using php

2011-10-24 Thread Bastien
On 2011-10-24, at 11:14 PM, Jason Pruim li...@pruimphotography.com wrote: Jason Pruim li...@pruimphotography.com On Oct 24, 2011, at 9:20 PM, Bastien wrote: On 2011-10-24, at 8:50 PM, Jason Pruim li...@pruimphotography.com wrote: Now that I've managed to list 3 separate

Re: [PHP] Exporting large data from mysql to html using php

2011-10-24 Thread tamouse mailing lists
On Mon, Oct 24, 2011 at 7:50 PM, Jason Pruim li...@pruimphotography.com wrote: I have about 89 million records in mysql... the initial load of the page takes 2 to 3 minutes, I am using pagination, so I have LIMIT's on the SQL query's... But they just aren't going fast enough... What I would

[PHP] Exporting text with chinese characters in CSV

2009-03-27 Thread Ai Leen
Hi Everyone, I need to export data from database with UTF-8 encoding to an csv file. I am outputing html tables with the Content Type set to msexcel. The chinese texts came out as symbols. I tried using mb_convert_encoding the text from UTF-8 to UTF-16LE iconv from UTF8 to gb2312 iconv from

Re: [PHP] Exporting text with chinese characters in CSV

2009-03-27 Thread Ashley Sheridan
On Fri, 2009-03-27 at 17:40 +0800, Ai Leen wrote: Hi Everyone, I need to export data from database with UTF-8 encoding to an csv file. I am outputing html tables with the Content Type set to msexcel. The chinese texts came out as symbols. I tried using mb_convert_encoding the text from

Re: [PHP] Exporting text with chinese characters in CSV

2009-03-27 Thread Michael Shadle
The php script language has no bearing on the output unless you have characters In the php file itself. We had some issue like this at work. They found a way using iconv to to it but had to change because redhats iconv isn't updated. They do something with saving the output to a utf8

[PHP] Exporting to Excel

2008-06-18 Thread Dan Shirah
Hello all, I am trying to query an INFORMIX database, and then take the results and export them into a CSV or Excel file. I saw TONS of examples on how to do this using MySQL and tried to adpt them for ifx, but I can't get the darn thing working. My code below sets variables for values passed

Re: [PHP] Exporting to Excel

2008-06-18 Thread Daniel Brown
On Wed, Jun 18, 2008 at 5:53 PM, Dan Shirah [EMAIL PROTECTED] wrote: Hello all, [snip!] Well, when I execute the page I get the popup to save/open the output as an Excel file. When I open it, instead of getting data, it returns an error message of: PHP Warning: Wrong parameter count for

Re: [PHP] Exporting to Excel

2008-06-18 Thread Dan Shirah
Come on, Shirah. GOYA and RTFM! ;-P http://php.net/ifx_fieldtypes Drop the $i parameter below: [snip!] $query = ifx_query ($sql, $connect_id); [snip!] $head[] = ifx_fieldtypes($query, $i); [snip!] Son of a Bisquick! I'll chalk that up to looking at the Manual for like

[PHP] Exporting from Multiple mySQL Tables into One

2007-01-18 Thread Rahul S. Johari
Ave, I¹m not sure how to execute this. I can easily write a long, tedious code to handle each table separately, but I¹m sure there is an Array/For Each way to do this. I¹ve got 6 mySQL tables. I¹ve written a code that dumps data from each table into one corresponding DBF table. While writing to

Re: [PHP] Exporting from Multiple mySQL Tables into One - SOLVED!

2007-01-18 Thread Rahul S. Johari
Ave, I was fiddling my way around with foreach and found a solution to my problem. Here's my code: // define the array $tChoice = array( lodispo_osma = ATL, lodispo_osmh = HOU, lodispo_osmj = JAX, lodispo_osmt = TPA, lodispo = VB, lodispo_hfd =

Re: [PHP] Exporting to MS Word or Excel

2005-06-04 Thread Rory Browne
On 6/3/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: To export it exactly as displayed (like when you print to a virtual printer to generate a PDF) might be tricky, but you can definitely create Excel and I believe Word files without even having Excel or Word installed. If you DO have

[PHP] Exporting to MS Word or Excel

2005-06-02 Thread Miguel Guirao
Hi!!! Are there any chances that I could export a dynamic created web page into MS Word or Excel? I know this can be done with PDF!! I'm using LAMP!! --- Miguel Guirao Aguilera Logistica R8 TELCEL Tel. (999) 960.7994 Cel. 9931 600. -- PHP General Mailing List

Re: [PHP] Exporting to MS Word or Excel

2005-06-02 Thread tg-php
To export it exactly as displayed (like when you print to a virtual printer to generate a PDF) might be tricky, but you can definitely create Excel and I believe Word files without even having Excel or Word installed. If you DO have Excel or Word installed on your server, then you can always

Re: [PHP] Exporting HTML to Excel

2004-10-13 Thread Philip Thompson
: Tuesday, October 12, 2004 2:21 PM To: [EMAIL PROTECTED] Subject: [PHP] Exporting HTML to Excel Hi all. This may not be completely a PHP question, but hopefully you will be able to provide some insight. I have a table in HTML that I want to export to an excel spreadsheet. Using PHP, I can create

Re: [PHP] Exporting HTML to Excel

2004-10-13 Thread Chris Dowell
PROTECTED] Subject: [PHP] Exporting HTML to Excel Hi all. This may not be completely a PHP question, but hopefully you will be able to provide some insight. I have a table in HTML that I want to export to an excel spreadsheet. Using PHP, I can create an excel document - however, it's empty/blank. I

Re: [PHP] Exporting HTML to Excel

2004-10-13 Thread Philip Thompson
to project.htm but continue issuing the mime headers for excel? Warren Vail -Original Message- From: Philip Thompson [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 12, 2004 2:21 PM To: [EMAIL PROTECTED] Subject: [PHP] Exporting HTML to Excel Hi all. This may not be completely a PHP question

Re: [PHP] Exporting HTML to Excel

2004-10-13 Thread Chris Dowell
PM, Vail, Warren wrote: Have you tried changing your file name to project.htm but continue issuing the mime headers for excel? Warren Vail -Original Message- From: Philip Thompson [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 12, 2004 2:21 PM To: [EMAIL PROTECTED] Subject: [PHP

Re: [PHP] Exporting HTML to Excel

2004-10-13 Thread Chris Dowell
changing your file name to project.htm but continue issuing the mime headers for excel? Warren Vail -Original Message- From: Philip Thompson [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 12, 2004 2:21 PM To: [EMAIL PROTECTED] Subject: [PHP] Exporting HTML to Excel Hi all. This may

RE: [PHP] Exporting HTML to Excel

2004-10-13 Thread Vail, Warren
often see something similar in email. HTH, Warren Vail (415) 667-0240 SF211-07-434 -Original Message- From: Philip Thompson [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 13, 2004 6:18 AM To: Vail, Warren Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Exporting HTML to Excel How

[PHP] Exporting HTML to Excel

2004-10-12 Thread Philip Thompson
Hi all. This may not be completely a PHP question, but hopefully you will be able to provide some insight. I have a table in HTML that I want to export to an excel spreadsheet. Using PHP, I can create an excel document - however, it's empty/blank. I think I am just doing it incorrectly.

RE: [PHP] Exporting HTML to Excel

2004-10-12 Thread Graham Cossey
table border=1 tr tdCell 1/td tdCell 2/td /tr /table; ? HTH Graham -Original Message- From: Philip Thompson [mailto:[EMAIL PROTECTED] Sent: 12 October 2004 22:21 To: [EMAIL PROTECTED] Subject: [PHP] Exporting HTML to Excel Hi all. This may not be completely a PHP question

RE: [PHP] Exporting HTML to Excel

2004-10-12 Thread Vail, Warren
Have you tried changing your file name to project.htm but continue issuing the mime headers for excel? Warren Vail -Original Message- From: Philip Thompson [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 12, 2004 2:21 PM To: [EMAIL PROTECTED] Subject: [PHP] Exporting HTML to Excel Hi

Re: [PHP] Exporting Dbase to CSV

2004-09-02 Thread Sam Hobbs
Jay Blanchard [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] What, exactly, do you mean? A CSV file that resembles a spreadsheet? A doc with CSV? The term CSV is very common; it means Comma Separated Values. It is the format that originally was (and is) used by the Basic language.

RE: [PHP] Exporting Dbase to CSV

2004-09-02 Thread Jay Blanchard
[snip] Jay Blanchard [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] What, exactly, do you mean? A CSV file that resembles a spreadsheet? A doc with CSV? The term CSV is very common; it means Comma Separated Values. It is the format that originally was (and is) used by the Basic

[PHP] Exporting Dbase to CSV

2004-08-26 Thread Harlequin
I've seen many different posts on this subject and try as I might I can't get my data to output to CSV for a user to save. I can output to a table, I can output to screen in CSV format but that just means massing about with copy and paste. Has anyone got any suggestions...? --

RE: [PHP] Exporting Dbase to CSV

2004-08-26 Thread Jay Blanchard
[snip] I've seen many different posts on this subject and try as I might I can't get my data to output to CSV for a user to save. I can output to a table, I can output to screen in CSV format but that just means massing about with copy and paste. Has anyone got any suggestions...? [/snip] What,

RE: [PHP] Exporting Dbase to CSV

2004-08-26 Thread Dan Joseph
Hi, Depending on which database you're using, there is the UNLOAD function. Do a google for it, should find the answers. I've seen many different posts on this subject and try as I might I can't get my data to output to CSV for a user to save. I can output to a table, I can output

Re: [PHP] Exporting Dbase to CSV

2004-08-26 Thread Harlequin
I'm using MySQL Jay I can present the results in a table easy enough and if I replace the TD TAGs with commas etc. I get a screen output that resembles a CSV file but need to go that one step further and don't know how... -- - Michael Mason Arras People

Re: [PHP] Exporting Dbase to CSV

2004-08-26 Thread Harlequin
I'm using MySQL Dan I can present the results in a table easy enough and if I replace the TD TAGs with commas etc. I get a screen output that resembles a CSV file but need to go that one step further and don't know how... -- - Michael Mason Arras People

RE: [PHP] Exporting Dbase to CSV

2004-08-26 Thread Jay Blanchard
[snip] I'm using MySQL Jay I can present the results in a table easy enough and if I replace the TD TAGs with commas etc. I get a screen output that resembles a CSV file but need to go that one step further and don't know how... [/snip] Use CSV (without the table thing) and place Excel header

Re: [PHP] Exporting Dbase to CSV

2004-08-26 Thread Torsten Roehr
Harlequin [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I'm using MySQL Jay I can present the results in a table easy enough and if I replace the TD TAGs with commas etc. I get a screen output that resembles a CSV file but need to go that one step further and don't know how...

[PHP] Exporting data from database using fopen

2004-08-13 Thread Vern
I'm trying to write data to a file from a Postgres database using the following code ?php //LOOP THROUGH RECORDSET while (!$rsITEMS-EOF) { //CREATE CSV //OPEN DUMP FILE $fp = fopen(./dump.sql, w); //WRITE DATA TO DUMP fwrite($fp,

Re: [PHP] Exporting data from database using fopen

2004-08-13 Thread riese
Hi Vern, Vern wrote: I'm trying to write data to a file from a Postgres database using the following code while (!$rsITEMS-EOF) { $fp = fopen(./dump.sql, w); fwrite($fp, $rsITEMS-Fields('item_id')\n); $rsITEMS-MoveNext(); [shortened] I wouldn't do, if I were you. It doesn't

Re: [PHP] Exporting data from database using fopen

2004-08-13 Thread Vern
Sorry the previous post got sent prematurely. It does work, however, the problem is in the fwrite($fp, $rsITEMS-Fields('item_id')\n); what gets written to the file is exactly $rsITEMS-Fields('item_id') for as many records are return when I want the value to be inserted in the file.

Re: [PHP] Exporting data from database using fopen

2004-08-13 Thread Vern
I got it. In case anyone is interested. I changed the code so that the field value was a became the variable $name and it worked. $name = $rsITEMS-Fields('item_id'); fwrite($fp, $name\n); -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Exporting data from database using fopen

2004-08-13 Thread riese
Hi Vern, Vern wrote: Sorry the previous post got sent prematurely. this one, too. # It does work, however, the problem is in the fwrite($fp, $rsITEMS-Fields('item_id')\n); I KNOW, this was the 2nd change in my code-sniplet ;o) what gets written to the file is exactly

Re: [PHP] Exporting data from database using fopen

2004-08-13 Thread Jason Wong
On Saturday 14 August 2004 00:31, Vern wrote: I got it. In case anyone is interested. I changed the code so that the field value was a became the variable $name and it worked. $name = $rsITEMS-Fields('item_id'); fwrite($fp, $name\n); But did you take the fopen() out of the while-loop? It

Re: [PHP] Exporting data from database using fopen

2004-08-13 Thread Vern
I did. ;) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Exporting data from database using fopen

2004-08-13 Thread Vern
I knew that ;) Some times it takes another set of eyes... Thanks -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Exporting Data as CSV - IE6/HTTPS Problem?

2003-12-04 Thread Geoffrey Thompson
All: I have the following php code for downloading a file to the user via the browser: // Open csv file. $fp = fopen($fileName, r); // Set file name. $dwnldName = report; // Set headers for csv download. header(Content-Type:application/csv); header(Content-Disposition:attachment;

RE: [PHP] Exporting Data as CSV - IE6/HTTPS Problem?

2003-12-04 Thread Geoffrey R. Thompson
:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 4:27 PM To: Geoffrey Thompson Subject: Re: [PHP] Exporting Data as CSV - IE6/HTTPS Problem? HTTPS is encrypting the URL -- including your file name. Geoffrey Thompson wrote: All: I have the following php code for downloading

[PHP] Exporting Data to Excel

2003-10-23 Thread Ben C.
I am using the code below to export my data into an excel file. The code is located in a password protected area which is checked against saved session variables. However when I put session_start(); the download errors out. Does any one have any suggestions? Please help. ? session_start();

Re: [PHP] Exporting Data to Excel

2003-10-23 Thread Marek Kilimajer
Damn exploder, use session_cache_limiter('private_no_expire'); before session_start() Ben C. wrote: I am using the code below to export my data into an excel file. The code is located in a password protected area which is checked against saved session variables. However when I put

Re: [PHP] Exporting mySQL Table Data to .csv

2002-07-11 Thread Richard Lynch
I use phpMyAdmin which enables me to take dump of mySQL Table Data into Comma Seperated Values file (.csv) Now, i have to create such a program that accomplishes this, without using phpMyAdmin. Can someone guide me to this procedure.. Since PHP has a fget_csv function (or something like that)

[PHP] Exporting mySQL Table Data to .csv

2002-07-09 Thread Thomas Edison Jr.
Glory, I use phpMyAdmin which enables me to take dump of mySQL Table Data into Comma Seperated Values file (.csv) Now, i have to create such a program that accomplishes this, without using phpMyAdmin. Can someone guide me to this procedure.. Thanks, T. Edison Jr.

Re: [PHP] exporting

2001-11-20 Thread Jon Farmer
hey guys.. does anyone have any ideas on how to export information from a mysql database to microsoft word, excel, access, note pad or any other such application? There is a class on http://phpclasses.upperdesign.com/ That allows you to create a excel file from php. Should be fairly

[PHP] exporting

2001-11-19 Thread Kunal Jhunjhunwala
hey guys.. does anyone have any ideas on how to export information from a mysql database to microsoft word, excel, access, note pad or any other such application? Regards, Kunal Jhunjhunwala -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

Re: [PHP] exporting

2001-11-19 Thread Kunal Jhunjhunwala
Subject: Re: [PHP] exporting You can use something like this from MySQL: SELECT * INTO OUTFILE 'data.txt' FIELDS TERMINATED BY ',' FROM ...; This will give you a comma delimited file that you can then import into Excel, Access, etc. You can find more out

RE: [PHP] exporting

2001-11-19 Thread Jason Murray
I need something that will do a direct transfer to word or excel or the others.. not something via a cvs method.. Excel loads comma separated (CSV - CVS is something else entirely) files happily. Jason -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

RE: [PHP] exporting

2001-11-19 Thread Matthew Loff
export... The best way of doing it is writing it in Perl with the SpreadSheet::WriteExcel module. Take a look at it... I was quite impressed. -Original Message- From: Kunal Jhunjhunwala [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 5:01 PM To: [EMAIL PROTECTED] Subject: [PHP