[PHP-DB] Convert HTML Table to Tab Delimited .TXT file

Howdy All, I've PHP / Apache / MySQL running on a Linux machine where a GUI allows an administrator to track changes made to computers on our intranet. I've been asked to add an 'history' button so that all changes made to one or more computers can be put into a table, displayed on client

[PHP-DB] Re: Convert HTML Table to Tab Delimited .TXT file

[EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] ... Howdy All, I've PHP / Apache / MySQL running on a Linux machine where a GUI allows an administrator to track changes made to computers on our intranet. I've been asked to add an 'history' button so that all changes made to one or

Re: [PHP-DB] Re: Convert HTML Table to Tab Delimited .TXT file

Thanks for responding, Torsten. If I'm understanding your suggestion, then what happens where the data from the dB already has a ; (semi-colon) in it? Wouldn't this corrupt the import into excel? dave My question is whether there might be a more direct way to get the dB data into excel on

Re: [PHP-DB] Re: Convert HTML Table to Tab Delimited .TXT file

[EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] ... Thanks for responding, Torsten. If I'm understanding your suggestion, then what happens where the data from the dB already has a ; (semi-colon) in it? Wouldn't this corrupt the import into excel? This might cause a problem because

RE: [PHP-DB] Re: Convert HTML Table to Tab Delimited .TXT file

You could just use MysqlODBC, and import the data right into the excel sheet. Just setup a DNS that points to your Mysql server, on the windows box, then select Data-Get External data-New Database Query within Excel... I'm not sure what the data is, or why you need the data, or what your

Re: [PHP-DB] Re: Convert HTML Table to Tab Delimited .TXT file

[EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] ... Thanks for responding, Torsten. If I'm understanding your suggestion, then what happens where the data from the dB already has a ; (semi-colon) in it? Wouldn't this corrupt the import into excel? Please take a look at PEAR's

Re: [PHP-DB] Re: Convert HTML Table to Tab Delimited .TXT file

There definitely are colons, and there is a 'comments' field and semi-colons may appear there. However I think I will include a note in the help file for the admin to avoid using semi-colons in this field. Seems the best solution. And you are right: A .csv is seen as an excel file, so opening

[PHP-DB] Re: Convert HTML Table to Tab Delimited .TXT file

An easy way to do it (work around) is to dump it as csv or html. If your form can output an html table to the browser to show results then all you need is to include a short instruction on the html form that has all results in html table that would say something like Save with your browser's

Re: [PHP-DB] Re: Convert HTML Table to Tab Delimited .TXT file

Thanks, Christian, and all who responded. I think this is almost exactly as it will work. The problem with using some kind of MySQL frontend is that this would involve some knowledge of dB's and SQL (can't be certain of this), and that it would be additional steps. For example, the GUI already

[PHP-DB] Simple Question... Complex Answer?

Dear All, How do I pass an ADO Recordset by reference to a COM object function in PHP v4.3.4? Cheers, Keith. ps. I posted a much more long-winded version of this earlier but it was screwed up in the Newsgroup somehow, (probably my fault). eg. My best guess... dies horribly :( $AComObject =

Re: [PHP-DB] Convert HTML Table to Tab Delimited .TXT file

--- [EMAIL PROTECTED] wrote: Howdy All, I've PHP / Apache / MySQL running on a Linux machine where a GUI allows an administrator to track changes made to computers on our intranet. I've been asked to add an 'history' button so that all changes made to one or more computers can be put

RE: [PHP-DB] undefined function

OK, I added it!! But it still does work. BTW, I have four different PHP.ini files in my system, where I can see which one is using it? I added it to all of them!! IIS PHP 4.x SQL Server Miguel Guirao Servicios Datacard www.SIASA.com.mx -Mensaje original- De: Bruno Ferreira

Re: [PHP-DB] undefined function

From: Miguel Guirao [EMAIL PROTECTED] BTW, I have four different PHP.ini files in my system, where I can see which one is using it? I added it to all of them!! phpinfo() will product a page that shows you what php.ini file PHP is using. It's in the first block. ---John Holmes... -- PHP

Re: [PHP-DB] Convert HTML Table to Tab Delimited .TXT file

Wow, thanks. I'm gonna give this a try right now. dave Mark Weinstock at [EMAIL PROTECTED] recently wrote... Maybe I'm missing something (quite possible), but you can make the work happen autogically by using http headers. header(Content-type: application/octet-stream);

Re: [PHP-DB] Convert HTML Table to Tab Delimited .TXT file

I've used the header function before for redirection with success, but in the current situation I'm not sure where to put the 2 calls to it. I'm making the web page on the fly -- querying the dB, writing out the string including html tags and the query result, using fopen to create the file,

RE: [PHP-DB] undefined function

Thank you everybody!! I was missing that bloody dll. Is working now!!! Best Regards, and thanks again Miguel Guirao Servicios Datacard www.SIASA.com.mx -Mensaje original- De: John W. Holmes [mailto:[EMAIL PROTECTED] Enviado el: Lunes, 24 de Mayo de 2004 01:06 p.m. Para: Miguel

Re: [PHP-DB] Upload and Display images with Mysql

--- Kpromos [EMAIL PROTECTED] wrote: Dears All, I'm looking for a simple script that will permitme to upload images in a mysql database, calling out the images with a function from a mysql database (calling them from an id variable). I have just tried this tutorial

Re: [PHP-DB] Convert HTML Table to Tab Delimited .TXT file

--- [EMAIL PROTECTED] wrote: I've used the header function before for redirection with success, but in the current situation I'm not sure where to put the 2 calls to it. I'm making the web page on the fly -- querying the dB, writing out the string including html tags and the query