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
- FPDF
- TCPDF
- mPDF
- 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!