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!

15 comments:

  1. Replies
    1. 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. Moi Qatar and all this type of information you can check form the giving article link.

    ReplyDelete
  3. 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
  4. 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
  5. AtozTopNews is a technology research and analysis company. Our goal is to help executives understand the impact of the latest technologies and their impact on the media, business and society. AtoztopNews is the ultimate guide to this ever-changing life. Technology isn't only about processors and bits. It's the car with no driver, human organs being printed in a laboratory, and slow flights into space. This is the future, and we're here to inform you of the whole story.

    ReplyDelete
  6. 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
  7. In our latest Milltronics buyer spotlight video we sit down with XL Pattern, a precision machine store based out of Orrville, Ohio. XL Pattern is a precision foundry mold store that focuses on the aerospace and Hand Held Massager firefighting industries. As a long time|a very long time} Milltronics buyer XL Pattern has continued to develop in size through the years increasing from just a couple CNC machines to properly over 10 CNC machines. Siemens’ digitalization portfolio for the machine builder ranges from the machine design to engineering through commissioning and service.

    ReplyDelete