SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Member
    Join Date
    Jan 2005
    Location
    Bath, UK.
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Using PHP, MYSQL to create printed reports

    Hi,

    I'm developing a site using PHP and MySQL and there is a requirement to produce reports which will have to be highly formatted (including charts) and printed. I have searched the web and cannot find a solution. I have tried the PEAR Spreadsheet_Excel_Writer module but this only creates simple spreadsheets (no charts), JPGRAPH (have had problems with using this) and looked at using OpenOffice as a background process (I have used this technique before but with VB and Excel). Essentially what we need is a process where the user can make a selection on a WEB page which will result in php interrogate a database, creating a report, converting it to PDF and delivering it to the user. Does anyone know of such a solution?

    Thanks.

  2. #2
    ********* Callithumpian silver trophy freakysid's Avatar
    Join Date
    Jun 2000
    Location
    Sydney, Australia
    Posts
    3,798
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I am ignorant when it comes to having done any of this myself - but I would suggest you check out one of the php flash libraries available such as ming ( www.php.net/ming) or a VML library for php.

  3. #3
    Currently Occupied; Till Sunda Andrew-J2000's Avatar
    Join Date
    Aug 2001
    Location
    London
    Posts
    2,475
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Murph
    Hi,

    I'm developing a site using PHP and MySQL and there is a requirement to produce reports which will have to be highly formatted (including charts) and printed. I have searched the web and cannot find a solution. I have tried the PEAR Spreadsheet_Excel_Writer module but this only creates simple spreadsheets (no charts), JPGRAPH (have had problems with using this) and looked at using OpenOffice as a background process (I have used this technique before but with VB and Excel). Essentially what we need is a process where the user can make a selection on a WEB page which will result in php interrogate a database, creating a report, converting it to PDF and delivering it to the user. Does anyone know of such a solution?

    Thanks.
    Have a look at PHP/SWF Charts, its not quite clear on what boundaries the reports have to be generated from, i'll assume these to be relatively basic. PDF reports would most likely have to be custom built... R&OS: pdf class

  4. #4
    SitePoint Addict
    Join Date
    Sep 2004
    Location
    Camas, WA (USA)
    Posts
    228
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I've just begun reading up on this stuff...so I could be way off, but isn't this what PDFlib does? It looks like you can create PDFs on the fly and position things very accurately, or am I mistaken?

  5. #5
    SitePoint Addict kivison's Avatar
    Join Date
    Dec 2004
    Location
    Whitley Bay, Tyne & Wear, UK
    Posts
    246
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Have a look at this! I have this task on my to do list. This is a PDF creation tool in PHP which describes how to do it. I havnt started on this part of my project yet but I found this useful while I was researching.

    Keith


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •