web application that connects to a database and displays the information contained in the database, and allows the user to add additional records to the database. To begin, use phpMyAdmin to create the database in the cis367_wk3midterm.sql Download cis367_wk3midterm.sql  file. Once you've created the database, you will create a web application using Object-Oriented PHP programming techniques and the MVC architecture. Note that for connecting to the database, you will find the correct User ID and Password in the provided SQL file. Detailed requirements for the application are listed below.

Specific Requirements:

• Project/folder name is YourLastName_midterm
• Web application is written using the MVC (Model, View, Controller) architecture
• Web application is written using object-oriented PHP programming, including classes for:
  • Database Connection & Information
    • Provides connection to the database
    • Provides error handling for database connection issues
    • Provides methods to get database connection information
    • Included in the namespace "Models"
  • Contacts table model
    • Model of the Contacts table
    • Included in namespace "Controllers"
  • Contacts table DB
    • Provides methods for querying the database as follows:
      • Get contact by ContactNo
      • Get all contacts
      • Add contact
      • Update contact
      • Delete contact
    • Included in the namespace "Models"
  • Contacts table controller
    • Provides methods to control the flow of information between the user interface and the database
    • Included in the namespace "Controllers"
• Web application includes a "landing page"
  • Filename: index.php
  • Title: "Your Name Midterm Practical"
  • Page Header: Your Name Midterm Practical
  • Header: Main Menu
  • Includes a link to the display contacts page
• Web application includes user interface page(s) to display, add, update, and delete contact information:
  • Filename display_contacts.php
  • Title: "Your Name Midterm Practical"
  • Page Header: My Contacts
  • Table displaying contact information from the database
    • ID column
      • Header: User ID
      • Display: ContactNo from the database
    • Name column
      • Header: Name
      • Display: ContactFirstName and ContactLastName name from the database formatted as Last, First
    • Address column
      • Header: Street Address
      • Display: ContactAddressLine1 from the database
    • Address column
      • Header: Apt/Office/Bldg
      • Display: ContactAddressLine2 from the database
    • City column
      • Header: City
      • Display: ContactCity from the database
    • State column
      • Header: State
      • Display: ContactState from the database
    • Zip column
      • Header: Zip Code
      • Display: ContactZip from the database
    • Date of Birth
      • Header: DOB
      • Display: ContactBirthdate from the database
    • E-Mail
      • Header: E-Mail Address
      • Display: ContactEMail from the database
    • Phone
      • Header: Phone Number
      • Display: ContactPhone from the database
    • Notes
      • Header: Additional Information
      • Display: ContactNotes from the database
    • Displays all rows contained in the database
  • Ability to Delete a contact from the database
  • Ability to Add or Update a contact in the database, with the following validation:
    • First Name
      • Required
      • Must contain at least 2 characters
    • Last Name
      • Required
      • Must contain at least 2 characters
    • Street Address
      • Required
      • No specific format required
    • Apt/Office/Bldg
      
      • Optional
      • No specific format required
    • City
      • Required
      • Must contain at least 2 characters
    • State
      • Required
      • 2 upper-case letters only
    • Zip
      • Required
      • 5 numbers only
    • Date of Birth
      • Required
      • Uses a Date Picker
    • E-Mail
      • Required
      • Must be a validly formatted e-mail address
    • Phone
      • Required
      • Format (XXX)XXX-XXXX
    • Notes
      • Optional
      • Up to 50 characters allowed
    • If there are validation errors:
      • An error message should be displayed next to the field with the error describing the expected input
      • The information should be retained in the entry fields
      • The information should not be saved to the database

Example of how the UI should appear: