SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    May 2006
    Posts
    8
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Printed Documents from Database

    I am hoping to implement a system that allows reports to be generated on the fly from information stored in a MySQL database with product images, company logo, etc. I'm thinking it could be implemented in CSS but things like pagination would be harder to control.

    I then thought about PDF generation on the fly but have no experience of this. I found a couple of sites: http://www.fpdf.org/ and http://www.ros.co.nz/pdf/. Has anyone used either of these products and do you know if they would meet my need to pull information from the database and insert 'standard' information like company logos, address, etc and the ability to insert images from the server specific to that product. Which would be better or is there something even better that I should be considering?

    Thanks

  2. #2
    SitePoint Addict
    Join Date
    May 2005
    Location
    London, ON
    Posts
    360
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Are you looking to actually print these documents automatically, or just automatically create static copies for each product?
    Ryan Price
    Subscribe to my blog for regular tips and tricks

  3. #3
    SitePoint Member
    Join Date
    May 2006
    Posts
    8
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Create PDFs on demand that can then be printed, as required. These PDFs will replace product sheets that are currently produced manually in Publisher. The information is already there in the database to display on the website so I thought it made more sense to extract the information from the database, as required, to produce these product sheets. It will not be clients/website users that are printing these off (nor will they have access to this feature), it will be an internal thing but the final printed product sheet will be sent/given to clients.

  4. #4
    SitePoint Addict
    Join Date
    May 2005
    Location
    London, ON
    Posts
    360
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well if you can get away from having to use PDFs then you can solve the problem by creating them as static html files and printing these when needed.

    I've done something similar to this in the past. Take a look at this thread:
    http://www.sitepoint.com/forums/showthread.php?t=471646
    Ryan Price
    Subscribe to my blog for regular tips and tricks


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
  •