IT/BIFX 530 Applied Database Systems

Consider the banking example we used in the SQL inclass 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. From the previous PHP/SQL Lab 1, you inserted the customer, Jane Doe, into the database. She decided to move so her street and city need to be updated. Create the necessary php files to update Jane Doe’s street to “404 Error Place” and city to “Nowhere” from a web browser. After the update, display all of the customers from the web.

2. We now need to remove Jane Doe from the database. Create the corresponding html and php files so that a user can delete Jane Doe from the database from a web browser. After the deletion, display all of the customers from the web.