Applied Database Systems (PHP/SQL Lab 1)

IT/BIFX 530 Applied Database SystemsPHP/SQL Lab 1
Consider the banking example we used in the SQL in-class exercises:
branch (branch_name, branch_city, assets)
customer (customer_name, customer_street, customer_city)
account (account_number, branch_name, balance)
loan (loan_number, branch_name, amount)
depositor (customer_name, account_number)
borrower (customer_name, loan_number)
Write PHP code for the following problems:
1. Create a php file to display the names and cities of customers who have an account at
Downtown branch from the web.
2. Create the corresponding html and php files so that a user can insert the following customer
into the database from a web browser. After the insertion, display all the customers from the
web.
“Jane Doe”, “401 Rosemont Ave”, “Frederick”
Submission:
Submit a softcopy of the html and php files and a document containing screenshots of web
outputs with URL included for both problems on Blackboard. You may submit a ZIP folder
containing all of these files.