Home arrow PHP arrow Page 3 - Creating a Login Script for a PHP Invoicing System

Database schema - PHP

In this first part of "Building an Invoicing System," we are going to look at invoice management. Why would anyone want an online invoicing system? Well, if you are a freelance web developer like myself, you will undoubtedly need to invoice your clients so as to be able to get paid at the end of the month. This application will help you to manage your client details as well as your invoices.

TABLE OF CONTENTS:
  1. Creating a Login Script for a PHP Invoicing System
  2. What if I don't see that page?
  3. Database schema
  4. Login program
By: Leidago
Rating: starstarstarstarstar / 31
September 06, 2006

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

Because we are starting the series off with invoice management, we are going to be building the invoices table, so

CREATE TABLE `invoices` (
  `invno` int(4) unsigned zerofill NOT NULL auto_increment,
   `status` enum('Paid','Unpaid') NOT NULL default 'Unpaid',
  `VAT` decimal(9,2) NOT NULL default '0.00',
  `inv_date` date default NULL,
    `cid` int(11) NOT NULL default '0',
  `uID` int(4) NOT NULL default '0',
  PRIMARY KEY  (`invno`)
)

Let's run through the table fields:

The invno field is the primary key generator which gives a unique number to every new invoice that is created. The invoice numbers will be in the format 0001, 0002, 0003, and so on. The status field is of enumerate type and contains the values Paid and Unpaid. These values will be used to show the status of an invoice.

The Inv_date  field will show the date that the invoice was issued. VAT, by the way, will be calculated automatically. The cid is the foreign key that will help identify the client name associated with an invoice. The uID field identifies the user who created the invoice. This table is at the heart of the program; it will tell us everything we want to know about a particular invoice, such as how many invoices a particular user issued or how many invoices were made to a particular client etc.

The next table we are going to create is called "clientinv." It is going to hold specific invoice and client details, such as the description of the invoice and the total cost of a invoice:

CREATE TABLE `clientinv` (
  `invnum` int(4) unsigned zerofill NOT NULL auto_increment,
  `descr` text NOT NULL,
  `totxVAT` decimal(9,2) NOT NULL default '0.00',
  `totwVAT` decimal(9,2) NOT NULL default '0.00',
  `finv` int(11) NOT NULL default '0',
  PRIMARY KEY  (`invnum`)
)

Let's go through the table fields:

The "descr" field will hold the description of the invoice. The totxVAT and totwVAT fields will store the total cost of the product with and without VAT. The "finv" field is the foreign key that will hold the invoice number. I created this table because it will give us flexibility in terms of how we store information. Remember, one client can have many invoices and one invoice can contain information on many different products, which I could not store in either the invoices or the (soon to be created)client table.



 
 
>>> More PHP Articles          >>> More By Leidago
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

PHP ARTICLES

- Hackers Compromise PHP Sites to Launch Attac...
- Red Hat, Zend Form OpenShift PaaS Alliance
- PHP IDE News
- BCD, Zend Extend PHP Partnership
- PHP FAQ Highlight
- PHP Creator Didn't Set Out to Create a Langu...
- PHP Trends Revealed in Zend Study
- PHP: Best Methods for Running Scheduled Jobs
- PHP Array Functions: array_change_key_case
- PHP array_combine Function
- PHP array_chunk Function
- PHP Closures as View Helpers: Lazy-Loading F...
- Using PHP Closures as View Helpers
- PHP File and Operating System Program Execut...
- PHP: Effects of Wrapping Code in Class Const...

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: