Database, PHP and PDF

A great example of creating tools to manage inventory. This project was developed using Open Source Software.

Code

We developed a custom application for a client that had very specific needs. We created a database system that was accessible from a web browser. The end user would enter data and the software would create a label on 8.5x11 sized paper. Once the information was entered into the database, an employee could look up an item and modify the item count, weight and finished label size. A label would then be created using the information and barcodes would also be generated. Once the label is created, it is automatically transformed into a PDF in which the user can save, print or email.
There are several advantages to creating a PDF. A PDF is a fixed document, web browsers can change the layout of the page so by saving the information as a PDF, you will know exactly how it will look regardless of the user's web browser or screen resolution.
Several improvements can be made such as setting up paper options that match Avery’s custom labels, or changing fonts, font size or color.

  • Skills : HTML5, PHP, MySQL
  • Client: Confidential