PHP Invoicing System - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

FuZion · 04-12-2009, 01:26 AM

Hi there,

I am researching the best way to implement an invoicing system in PHP and MySQL. Preset items will be stored in a db table, and each invoice will be a row in the table as well. Now, I cannot decide the best way to store the items associated with each invoice. I cannot simply link it to the invoice table (ie have a separate table invoice_items that has invoice_id and item_id columns) because the items can come and go as well as change price. My first thought is to create an xml file with the data in it and save that in a BLOB field, as well as on file somewhere else for a backup. What do you think? Is this efficient?

Do you guys have any other ideas.. right now I have nothing planned as to the layout/setup of my invoicing system so its very flexible.

Thanks in advance,

FuZion

Ronnette Petra · 06-13-2009, 03:42 AM

Hi,

Continuing with the PHP Invoicing series, we will now concentrate on how to create, view and print an invoice. Create a new PHP document and save it as main.php. Refer to fig2 to see what the main page looks like. There are essentially three pages that deal with invoices:
* Allinv.php – Lists all invoices in the database.
* Unpaid.php – Lists all unpaid invoices.
* NewInvoice.php – Enables you to generate a new invoice.
There are also related pages that handle deleting and updating invoices.