Lab 6 – Triggers and Introduction to PHP
This lab should get you familiarized with using files in PHP and .
Reminder At the end of the class, save the files from D:sokkit/site/ and D:\sokkit\mysql\data to your x-drive or removable media, as these are shared directories and their content is deleted when you log out.
Submission requirements: Both electronic and paper submission of Part 1, VP-5 Fund Raiser Application and Part 3, SQL queries in MySQL. Due date Wednesday, March 22 2006 before class.
Extra credit: Submit Part 2, Mortgage calculator by the same deadline. Extra credit: 15 points.
PART 1: SAMPLE APPLICATION: VP-5 Fund Raiser for MWR
Last lab we started the VP-5 Fund Raiser application. This is how the input form looks like:
Task 1: Complete previous lab: (28 February Lab)
Task 2: (Save data to file) Add code to your processorder.php file (executed by server when the previous form is submitted) to save order data from VP-5 Fund Raiser application into a file called orders.txt. Each line in the file should contain the information for one order, stored in such a way that it can be read back later. For example, each line should contain:
-shirts quantity
-caps quantity
-patches quantity
-shipping address
-total amount (computed)
separated by some special character, such as tab.
Display appropriate message in order confirmation screen. If for any reason the data cannot be saved, an error message should be displayed. This is a sample output if the order was successfully saved.
Task 3: Submit several orders, so you’ll have several orders saved in your orders file
Task 4: (Retrieve all data from file) Read back the data from saved orders file and display all orders from VP-5 Fund Raiser application. Format the output, so items which were not ordered are not displayed (with a 0 quantity). This is a sample output:
Task 5: (Retrive some data from file)
a) Create a simple input form where a user can specify one search term.
b) Process the form to display all orders from VP-5 Fund Raiser application with shipping address containing the search term. Use strstr(longString,shortString) to check if search term is in shipping address.
PART 2: SAMPLE APPICATION: Mortgage calculator
You must complete a simple “mortgage” calculator using PHP. A mortgage payment is based on the following factors:
Interest rate (rate): rate is the monthly percentage rate. Interest rates are quoted as an annual rate, thus you need to convert the annual rate to monthly rate
Principal (p): The amount being borrowed;
Number of months of the term (n): n is the number of months to pay back the mortgage. Thus a 15 year mortgage is 15 * 12 months, thus n = 180.
Payment calculation is: ( rate * p ) / (1 – (1 + rate) – n ).
1. Create a web form as shown below that will capture the amount of the mortgage and the interest rate.
[pic]
2. Create a PHP file that will take the input values from the form above, compute the payment amount for 15, 20, 25, and 30 years. Use “pow” function. Display the results to the user as shown below:
[pic]
Part 3: SQL in MySQL
To become more familiar with MySQL, write the following queries in SQL and run them using the MySQL Monitor (the command-line interface to MySQL). To start the MySQL Monitor, open a command line, change the local directory to D:\sokkit\mysql\bin and then type mysql –u root to start the MySQL Monitor as root.
The queries will refer to the following tables (you created in class)
▪ Items(ItemName, Price)
▪ Orders(OrderID, ShippingAddress)
▪ ItemsOrdered(OrderID, ItemName, Quantity)
Ex 1: Find the order id and shipping address for all orders that have to be shipped in Maryland (shipping address contains ‘MD’ or ‘Maryland’).
Ex 2: Find the order id, shipping address and total price (no taxes) for all orders with total price higher than $100.
-----------------------
VP-5 Fund Raiser Orders Search
Top of Form
|Search Term |[pic] | |
|[pic] | |
Bottom of Form
VP-5 MWR
Your order is as follows:
1 Tee Shirts
2 Ball Caps
3 Patches
Total Quantity: 6
Total Amount(with 5% sales tax): $85.05
Shipping Address: 420 Web Foot Ln, Stevensville MD 21666
Order Processed. 11:50, 7 March 2006
VP-5 MWR Orders
1 Tee Shirts
2 Ball Caps
3 Patches
Total Amount: $85.05
Shipping Address: 420 Web Foot Ln, Stevensville MD 21666
4 Tee Shirts
3 Patches
Total Amount: $94.5
Shipping Address: 1003 Constitution Av, Washington DC 34012
VP-5 MWR Fund Raiser
Top of Form
|Item |Quantity |
|Mad Fox Tee Shirts |[pic] | |
|VP-5 Ball Caps |[pic] | |
|Mad Fox Patches |[pic] | |
|Shipping Address |[pic] | |
| | | |
|[pic] | |
Bottom of Form
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.