Jump to content

Archived

This topic is now archived and is closed to further replies.

jamesnkk

How to create an Invoice

Recommended Posts

Hi, How can I create an Invoice entry using PHP, I know it involve with table, but I have no idea, Or is it possible to create using PHP, I know MS Access can be easily done.

The Invoice columns have a product Item, desp qty, cost and Total Amount.
It can allow me to select from the drop down menu to select the product item store in my table and then dispay the price on the 2nd column, while it compute the Total amount on the last column. It allow me to increment a new row for another new item or I can return to the previous row to edit.

I have trying searching the web, could't find any information about invoice. Is there such a script nor any expert out here, can give advise on how to construct an Invoice Entry.

Thanks for your patience reading my post.

Share this post


Link to post
Share on other sites
are you goping to be useing a mysql or some other database

Share this post


Link to post
Share on other sites
[!--quoteo(post=358608:date=Mar 27 2006, 03:10 AM:name=shortj75)--][div class=\'quotetop\']QUOTE(shortj75 @ Mar 27 2006, 03:10 AM) [snapback]358608[/snapback][/div][div class=\'quotemain\'][!--quotec--]
are you goping to be useing a mysql or some other database
[/quote]

Yes, I am using MySQL

[!--quoteo(post=358610:date=Mar 27 2006, 03:13 AM:name=AV1611)--][div class=\'quotetop\']QUOTE(AV1611 @ Mar 27 2006, 03:13 AM) [snapback]358610[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Is this for an online store, or for an intranet app?
[/quote]

An intranet Application

Share this post


Link to post
Share on other sites
Invoicing systems I have used have had two tables viz. invoice and invoice_item

invoice

[code]invoice_number(PK) | invoice_date | cust_id(FK) |[/code]

invoice_item

[code]invoice_number(FK) | item_id(PK) | prod_id(FK) |  qty |  price |[/code]

Produce the invoice by joining these table and also joining with customer and product tables

Share this post


Link to post
Share on other sites
[!--quoteo(post=358628:date=Mar 27 2006, 04:03 AM:name=Barand)--][div class=\'quotetop\']QUOTE(Barand @ Mar 27 2006, 04:03 AM) [snapback]358628[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Invoicing systems I have used have had two tables viz. invoice and invoice_item

invoice

[code]invoice_number(PK) | invoice_date | cust_id(FK) |[/code]

invoice_item

[code]invoice_number(FK) | item_id(PK) | prod_id(FK) |  qty |  price |[/code]

Produce the invoice by joining these table and also joining with customer and product tables
[/quote]

How do I construct an Invoice Entry ?

Share this post


Link to post
Share on other sites
are you asking how to input the data into the data base if so
[code]
$item=$_POST['item'];
$price=$_POST['price'];
$quantity=$_POST['quantity'];
mysql_query("insert into your_table(item,price,quantity)values('$item','$price'.'$quantity')) or die("couldnt insert");
[/code]
have you form point to the page you put this code on and change all the variables to the correct names

Share this post


Link to post
Share on other sites
[!--quoteo(post=358796:date=Mar 27 2006, 03:55 PM:name=shortj75)--][div class=\'quotetop\']QUOTE(shortj75 @ Mar 27 2006, 03:55 PM) [snapback]358796[/snapback][/div][div class=\'quotemain\'][!--quotec--]
are you asking how to input the data into the data base if so
[code]
$item=$_POST['item'];
$price=$_POST['price'];
$quantity=$_POST['quantity'];
mysql_query("insert into your_table(item,price,quantity)values('$item','$price'.'$quantity')) or die("couldnt insert");
[/code]
have you form point to the page you put this code on and change all the variables to the correct names
[/quote]

Thanks for your prompt reply, what I actually asking is how do I design the Invoice form entry using table, which can increment the row when adding a new item into it. Sorry I am just a newbies, hope you get me right.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.