A. Add a new folder to the DBP Web site named MDC. Create a Web page for Marcia’s Dry Cleaning in this folder, using the file name index.html. Link this page to the DBP Web page.
B. Create an appropriate ODBC data source for your database.
C. Add a new column Status to the INVOICE table. Assume that Status can have the values ['Waiting', 'In-process', 'Finished', 'Pending'].
D. Create a view called Customer Invoice View that has the columns Last Name, First Name, Phone, Invoice Number, Date In, Date Out, Total, and Status.
E. Code a PHP page to display Customer Invoice View. Using your sample database, demonstrate that your page works.
F. Code two HTML/PHP pages to receive a date value As Of Date and to display rows of Customer Invoice View for orders having Date In greater than or equal to As Of Date. Using your sample database, demonstrate that your pages work.
G. Code two HTML/PHP pages to receive customer Phone, Last Name, and First Name and to display rows for customers having that Phone, Last Name, and First Name. Using your sample database, demonstrate that your pages work.
H. Write a stored procedure that receives values for and New Status and that sets the value of Status to New Status for the row having the given value of Invoice Number. Generate an error message if no row has the given value of Invoice Number. Using your sample database, demonstrate that your stored procedure works.
I. Code two HTML/PHP pages to invoke the stored procedure created in part H. Using your sample database, demonstrate that your page works.