Time spent: 7 hours spent in total

The following required functionality is completed:

1. Required: Public page: Territories

• Required: The page should be called "territories.php".
• Required: It displays a bulleted list of states sorted alphabetically.
• Required: There is a bulleted list of territories indented below each state.
• Required: The territories are sorted based on a custom position value.
• Required: Set territory position values such that:
  • 'Northern' always comes before 'Southern'.
  • 'Western' always comes before 'Eastern'.
  • Chicago, Las Vegas, and New York are before any "Outside" territories.
• Required: When a territory name is the same as its state name, it does not display the territory name, just the state name.
• Required: There is a list of assigned salespeople below each territory.
  • Sorted by last name then first name, unbulleted, unindented.
  • Note that New York City should have two salesperson assignments.
• Required: Each salesperson's name is a link to a page with more details (salesperson.php).

2. Required: Public page: Salesperson

• Required: The page should be called "salesperson.php".
• Required: It has a link back to the territories.php page at the top.
• Required: It displays contact information (name, phone, email) for a single salesperson.
• Required: It displays a bulleted list of the salesperson's territories.
• Required: It redirects to territories.php if the requested salesperson is not found.

3. Required: Organize code to keep functions and database credentials private. Use good code formatting and code comments to make your code clear to others.

4. Required: All dynamic content being output to HTML should be encoded using best practices.

5. Required: Use database best practices such as freeing results from memory and closing the database connection when your code is finished using them.

The following advanced user stories are optional:

• Bonus: Move the header and footer of the HTML template into separate files and use include() to load them. Make sure the HTML title is still correct for both pages.

• Bonus: Create a new file "private/initialize.php". This file should become the only required file at the top of your PHP pages. It would then require all the other PHP files that are needed as well as create a new database connection.

• Bonus: Add a countries table with a one-to-many relationship to states. Add "United States" as the only country and assign all 50 states to it. Add it to the public pages and indent the states list below it.

• Bonus: If you added a countries table, use the MySQL console to add Canada as a country and populate the database with a few provinces and territories for Canada. Pick a salesperson or two and make assignments for all of the new territories.

• Bonus: Convert all SQL queries into callable functions.

• Advanced: Create a separate set of "staff area" pages in directory called "staff" which display states, territories, and salespeople. Each one should have a list view showing all records and a detail view for examining a single record.

• Advanced: If you created "staff area" pages, nest the pages for viewing territories inside the pages for viewing states. A user would select a state in order to view a list of the territories belonging to that state only.

Here's a walkthrough of implemented user stories:

GIF created with LiceCap.

Describe any challenges encountered while building the app.

Copyright [2016] [Rene Midouin]

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

    http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.