[PHP] Report generator for Linux
I use Interbase on the Linux and NT servers and I would like to have a report generator that can take the results of a query and produce that can be converted into a PDF file. Does anyone have some suggestions on how I can best achieve this goal? Todd -- Dr. Todd Cary Ariste Software 707-773-4523 [EMAIL PROTECTED] "It is a worthy thing to fight for one's freedom; it is another sight finer to fight for another man's" Mark Twain -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] "report" generation with PHP
Hello: I wrote an small web application that interfaces a Microsoft Access database. The database is fairly small and simple: it is a listing of employees, their phone number(s) and their department. My interface allows folks to view the phone list, search for a name, list by department, etc., and allows certain users to update the phone book (add employees, change phone numbers, etc). It's a fairly "typical" phonebook application. The Access database has a macro in it that allows for the generation of a report. The report is a nicely formatted listing of all the employees and their phone numbers, grouped by department. Everybody fits on one page. The whole purpose of this report is to be printable, and so that the one page phone list can be distributed throughout the factory. Now I want to be able to generate this report from the web. It doesn't have to use Access (and I would prefer that it didn't, so I can convert to MySQL). But I don't know of a nice (and easy!) way to generate such a report. Using HTML tables isn't acceptable---when you print, you still get the header and footer that the browser adds (and it's unacceptable to have everyone modify their browser's setup). Furthermore, the printable list has to look as close as possible to the original, because if I start changing formats, people will get upset. So I'm not really too sure where to start on this one. If anyone could offer some suggestions, and point me in the right direction, it would be sincerely appreciated! Thanks, Matt -- Matt Garman, [EMAIL PROTECTED] "I'll tip my hat to the new constitution, Take a bow for the new revolution Smile and grin at the change all around, Pick up my guitar and play Just like yesterday, Then I'll get on my knees and pray..." -- Pete Townshend/The Who, "Won't Get Fooled Again" -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] "report" generation with PHP
Hi Matthew, MG> Now I want to be able to generate this report from the web. It doesn't MG> have to use Access (and I would prefer that it didn't, so I can convert to MG> MySQL). But I don't know of a nice (and easy!) way to generate such a MG> report. Using HTML tables isn't acceptable---when you print, you still MG> get the header and footer that the browser adds (and it's unacceptable to MG> have everyone modify their browser's setup). Furthermore, the printable MG> list has to look as close as possible to the original, because if I start MG> changing formats, people will get upset. Try PHP's PDF extension. That way you can create neat documents. -- Kind regards, Mortenmailto:[EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] "report" generation with PHP
>= Original Message From Morten Winkler Jørgensen <[EMAIL PROTECTED]> = >Hi Matthew, > >MG> Now I want to be able to generate this report from the web. It doesn't >MG> have to use Access (and I would prefer that it didn't, so I can convert to >MG> MySQL). But I don't know of a nice (and easy!) way to generate such a >MG> report. Using HTML tables isn't acceptable---when you print, you still >MG> get the header and footer that the browser adds (and it's unacceptable to >MG> have everyone modify their browser's setup). Furthermore, the printable >MG> list has to look as close as possible to the original, because if I start >MG> changing formats, people will get upset. > >Try PHP's PDF extension. That way you can create neat documents. I forgot to mention that I already looked into the PDF extensions. Although it looks like it would do exactly what I want, the PDFLib isn't free for commercial use. As an intern, I'm not in a position to make purchase decisions (and I'm pretty sure my supervisor won't pay for it either!). Thanks anyway, Matt -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] "report" generation with PHP
În 16 Jul 2001 09:07:17 -0500 garman a scris: > I forgot to mention that I already looked into the PDF extensions. Although > it looks like it would do exactly what I want, the PDFLib isn't free for You can generate xml in php, write xsl to convert xml in xml-fo and then use fop to generate pdf, it really works :) http://xml.apache.org/fop/index.html Marius Andreiana -- You don't have to go to jail for helping your neighbour http://www.gnu.org/philosophy/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] "report" generation with PHP
On Mon, Jul 16, 2001 at 05:19:41PM +0300, Marius Andreiana wrote: > În 16 Jul 2001 09:07:17 -0500 garman a scris: > > I forgot to mention that I already looked into the PDF extensions. > > Although > > it looks like it would do exactly what I want, the PDFLib isn't free for > You can generate xml in php, write xsl to convert xml in xml-fo > and then use fop to generate pdf, it really works :) > http://xml.apache.org/fop/index.html Does all that work under Windows? Fop looked like it was part of the Apache project, and we're running IIS 5.0 on Windows 2000 Pro (not my decision!). Thanks again! Matt -- Matt Garman, [EMAIL PROTECTED] "I'll tip my hat to the new constitution, Take a bow for the new revolution Smile and grin at the change all around, Pick up my guitar and play Just like yesterday, Then I'll get on my knees and pray..." -- Pete Townshend/The Who, "Won't Get Fooled Again" -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] "report" generation with PHP
În 16 Jul 2001 17:17:57 -0500 Matthew Garman a scris: > Does all that work under Windows? don't know, but you can setup a linux box only for fop, leave the php site on windows as it is now (ouch!) > Fop looked like it was part of the > Apache project, and we're running IIS 5.0 on Windows 2000 Pro (not my > decision!). not my problem :) Marius Andreiana -- You don't have to go to jail for helping your neighbour http://www.gnu.org/philosophy/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] "report" generation with PHP
What about using a Windows COM object? There should be one for Access and if not you can use the Word one and generate word documents. It's pretty easy to use and there's lots of (ASP) documentation, but you can translate that to PHP no probs. I myself have done this to create a (VERY) quick (as in development time) SOAP client using the MSSOAP.SoapClient COM object. - -- - - - Philip Murray - [EMAIL PROTECTED] http://www.open2view.com - Open2View.com - - -- - - - Original Message - From: "Marius Andreiana" <[EMAIL PROTECTED]> To: "Matt Garman" <[EMAIL PROTECTED]> Cc: "PHP General List" <[EMAIL PROTECTED]> Sent: Tuesday, July 17, 2001 7:23 PM Subject: Re: [PHP] "report" generation with PHP > În 16 Jul 2001 17:17:57 -0500 Matthew Garman a scris: > > > Does all that work under Windows? > don't know, but you can setup a linux box only for fop, leave > the php site on windows as it is now (ouch!) > > > Fop looked like it was part of the > > Apache project, and we're running IIS 5.0 on Windows 2000 Pro (not my > > decision!). > not my problem :) > > > Marius Andreiana > -- > You don't have to go to jail for helping your neighbour > http://www.gnu.org/philosophy/ > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] "report" generation with PHP
> On Mon, Jul 16, 2001 at 05:19:41PM +0300, Marius Andreiana wrote: > > În 16 Jul 2001 09:07:17 -0500 garman a scris: > > > I forgot to mention that I already looked into the PDF extensions. > > > Although > > > it looks like it would do exactly what I want, the PDFLib > isn't free for > > You can generate xml in php, write xsl to convert xml in xml-fo > > and then use fop to generate pdf, it really works :) > > http://xml.apache.org/fop/index.html > > Does all that work under Windows? Fop looked like it was part of the > Apache project, and we're running IIS 5.0 on Windows 2000 Pro (not my > decision!). > Answer: Yes, all that stuff runs under Win2K. It's java-based and needs JDK 1.3 from Sun. You'll be able to call this from command windows. Question: PHP has Java-Support build in, has anybody checked out this with a tool like FOP (calling Java program from PHP)? Is it stable, good for production environment? Joerg www.php.comzept.de -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] "report" generation with PHP
În 17 Jul 2001 19:47:23 +1200 Philip Murray a scris: > What about using a Windows COM object? There should be one for Access and if > not you can use the Word one and generate word documents Don't use Words for that... We've had to generate invoices to be snail-mailed, imagine if the address in the invoiced didn't matched the envelope's transparent area... (don't think a word document can handle 6000 invoices anyway) Marius Andreiana -- You don't have to go to jail for helping your neighbour http://www.gnu.org/philosophy/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] "report" generation with PHP
În 17 Jul 2001 09:56:23 +0200 Jörg Krause a scris: > PHP has Java-Support build in, has anybody checked out this with a tool > like FOP (calling Java program from PHP)? Is it stable, good for > production environment? Yes, I'd like an answer to this too. Right now I can only call it with system calls from PHP, but with a native function would be much nicer (could show the progress too) Marius Andreiana -- You don't have to go to jail for helping your neighbour http://www.gnu.org/philosophy/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] "report" generation with PHP
> În 17 Jul 2001 19:47:23 +1200 Philip Murray a scris: > > What about using a Windows COM object? There should be one for Access and if > > not you can use the Word one and generate word documents > Don't use Words for that... We've had to generate invoices to be snail-mailed, I've also done the same thing. Approximately 400 invoices a day all from a backend administration website. However, we forked out a license to use the PDF library. > imagine if the address in the invoiced didn't matched the envelope's transparent > area... (don't think a word document can handle 6000 invoices anyway) Yes, well true. But, the point was there is the facility to use a COM object instead of some multi-server or java kludge. If you can find a COM object to do the task (Matt: you talked about using Access for your needs) then that'll probably be the easiest/fasted solution on Win32 (short of paying for PDF). On a side note, is there some Adobe license which prevents people writing Free for use PDF libraries? Or is it just by chance that the 2 that exist require you to purchase a license? Philip Murray -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] "report" generation with PHP
În 17 Jul 2001 20:41:59 +1200 Philip Murray a scris: > On a side note, is there some Adobe license which prevents people writing > Free for use PDF libraries? don't think so; fop is free Marius Andreiana -- You don't have to go to jail for helping your neighbour http://www.gnu.org/philosophy/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]