Search Cerebrotech Blog

Saturday, 24 June 2017

PHP, MySQL and PDF

After about a year of perfecting the invoicing process of Cerebro Technologies, we decided to automate it. Some people might ask, why not automate it from the onset? The answer is quite technical. When you have a bad process and you automate it, you invariably have a bad automated process and that can spell Disaster!

After getting the MySQL tables (entities) and their relationships, we wanted to export the report/invoice in PDF. There are about four PDF libraries that can work with PHP


  1. FPDF
  2. TCPDF
  3. mPDF
  4. DOMPDF
After reviewing these libraries, we opted for FPDF. Due to the fact that there were lots of tables relating with each other, we had to develop very complex MySQL queries to interact with the database and output the results in a neat format. The FPDF has a lot of useful functions that can help with this task. 

With patience and tenacity, the project was completed in 2 days!
Posted by at
Labels: , , , , ,

12 comments:

  1. The India22 October 2019 at 02:18

    Rice Bags Manufacturers
    Pouch Manufacturers
    fertilizer bag manufacturers
    Lyrics with music

    ReplyDelete
    Replies
    1. Unknown12 February 2021 at 19:17

      Great Article Cloud Computing Projects

      Networking Projects

      Final Year Projects for CSE

      JavaScript Training in Chennai

      JavaScript Training in Chennai

      The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

      Delete
  2. The India22 October 2019 at 02:20

    iso certification in noida
    iso certification in delhi
    ce certification in delhi
    iso 14001 certification in delhi
    iso 22000 certification cost
    iso consultants in noida

    ReplyDelete
  3. The India22 October 2019 at 02:20

    iso 9001 certification in Delhi
    iso 27001 certification services
    ISO 9001 Certification in Noida
    iso 22000 certification in Delhi

    ReplyDelete
  4. The India22 October 2019 at 02:21

    we have provide the best fridge repair service.
    Washing Machine Repair In Faridabad
    LG Washing Machine Repair In Faridabad
    Bosch Washing Machine Repair In Faridabad
    Whirlpool Washing Machine Repair In Faridabad
    Samsung Washing Machine Repair In Faridabad
    Washing Machine Repair in Noida
    godrej washing machine repair in noida
    whirlpool Washing Machine Repair in Noida
    IFB washing Machine Repair in Noida
    LG Washing Machine Repair in Noida

    ReplyDelete
  5. Shweta gaur makeup artist6 January 2020 at 21:41

    Shweta gaur is one of the famous makeup artist in all over India. We are providing the best makeup artist courses and more other courses in over branches in Delhi.

    Makeup Artist in Delhi
    Makeup Artist
    Best Makeup Artist in Delhi
    Best Makeup Artist in East Delhi
    Top Makeup Artist in Delhi
    Top Makeup Artist in India
    Bridal Makeup
    Best Bridal Makeup Artist in Delhi
    Bridal Makeup Artist in Delhi with Price
    Bridal Makeup Artist in Delhi NCR
    Top Bridal Makeup Artist in Delhi
    Bridal Makeup in Delhi
    Bridal Makeup Charges in Delhi
    Bridal Makeup Packages Prices
    Freelance Makeup Artist
    Bridal Makeup Charges in Delhi
    Freelance Bridal Makeup Artist in Delhi
    Reception Makeup
    Party makeup
    Wedding makeup artist
    Makeup Artist in Noida

    ReplyDelete
  6. E-services and Details 7 May 2020 at 08:30

    Moi Qatar and all this type of information you can check form the giving article link.

    ReplyDelete
  7. Qater10 January 2021 at 03:26

    here you can get more info about
    Allama iqbal open university

    ReplyDelete
  8. km34614 January 2021 at 04:12

    Hi I am from Join Pak Navy I and I really like your work thanks for this information and keep it up you are doing good

    ReplyDelete
  9. Health Lobby26 January 2021 at 10:44

    Your Blog is incredible with unique content. Please visit Sindh High Court to get latest Daily Cause List, Memorandum Civil, Criminal, Court Writ, Latest Jobs and Electronic Case Management System in Sindh High Court.

    ReplyDelete
  10. vé máy bay đi Canada20 April 2021 at 01:52

    Aivivu - đại lý chuyên vé máy bay trong nước và quốc tế

    vé máy bay đi Mỹ bao nhiêu

    vé máy bay hà nội sài gòn tháng 11

    vé máy bay cần thơ hà nội

    ve may bay di nha trang

    vé máy bay đi đà lạt

    taxi sân bay nội bài hà nội

    combo du lịch nha trang đà lạt

    ReplyDelete
  11. Anonymous4 December 2022 at 19:15

    This has actually unlocked a door to the future of ahead for} sports gambling and the recognition of online gambling apps. There is hope that online and mobile gambling could quickly see the same kind of expansion that legal online sports betting has enjoyed. Six extra states are currently seeking to add legal mobile on line casino gaming. The submit COVID-19 period will supply exciting opportunities for mobile gambling. 솔 카지노 As mobile devices help advances options and are simple to function, mobile gambling is an enticing choice for avid gamers.

    ReplyDelete

Subscribe to: Post Comments (Atom)