Posted by J.O. Aho on 10/13/60 11:41

David Quinton wrote:
> On Sun, 05 Mar 2006 02:13:18 +0100, "J.O. Aho" <user@example.net>
> wrote:
>
>> AK wrote:
>>
>>> Question - Is there some utility/widard that folks use on the web server end
>>> to get data out of the My SQL and onto a pdf , which I would then send by
>>> email?
>> As people has different needs, it's difficult to make a script that will
>> generate a pdf on a result from a sql query.
>>
>> It's really better to write that yourself, you know how you want your pages to
>> look, if you just fetch rows with X columns, the method to get it appear on
>> your HTML page wouldn't be so much different that the one needed for pdf.
>
> The way that I've done it (and I'm not saying is the best / the only
> way) if to write out on server as an html file, then exec() html2ps
> and then ghostscript it to a PDF.
>
> But our App needs the PS and html files too, so there's probably a
> quicker way around it without my intermediate stages!

If you use PDFlib, then you can generate pdf files without using html2ps and
ghostscript and you will gain quite much speed in the process too. You may
want a license to use it, www.pdflib.com www.php.net/manual/en/ref.pdf.php


//Aho

[Back to original message]