Assignment 10

Create a folder named assignment10 in your development environment.

Write a simple web application in PHP and MySQL using PHP Data Objects that allows a company to enter invoice items. The web application has two tables, invoiceheader and invoicedetails. The invoiceheader table has information about the invoice number and the customer name only while the invoicedetails table has information about the description, quantity and price only for multiple items related to the invoice number.

The web application should create the invoices database and the two tables mentioned above. A search web page should prompt for an invoice number. If the invoice number is found, allow for the invoice header and details to be edited with unlimited number of items. Also allow for the invoice number to be deleted if found. If the invoice number is not found allow for it to be added with unlimited number of items.
 
Powered by