Textbook: PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (Fifth Edition) Written by Larry Ullman

Thoroughly read all of the instructions on this page before beginning your project.

See an instructor to ensure that you completely understand the Final Project for this course, and to discuss the details of the project you plan to create. Make sure to have instructor approval, then complete the project.

Kevin's note: If I had to do this project over again, I would use a loop to access the database product information, and then display that info. on the product display page. I got a 90% grade on this assignment.

The final project for this course project will consist of the design, development, testing, and debugging of a database driven web application using PHP & MySQL. Develop a simple CMS or a web application of your choice. Choose an application of personal creative or professional interest. Note: Your project must demonstrate competency with the material covered in this course and must be discussed and approved in advance by an instructor.

Examples of applications that can be built for this assignment include:

• A pizza ordering system or other site for a company where it displays its products.

• A gaming or sports tournament site, where users can see game results, aggregate scores and comment on them.

• A very simple community where users can have personal profile pages, a status line and send each other messages.

• A site for a club, a church/mosque/synagogue/temple or an association, with information about activities.

If you can't think of anything else, use the Pacific Trails site. Convert the existing reservations page to a Contact Us page and then build a new reservations page that allows customers to book one of several yurts and rooms in the lodge. Your back-end should show available rooms and which ones are already booked. You should have the customer info on file and attached to the booked room.

• Two night minimum March through October & all weekends.

• Yurts cost $180.00 per night

• There are 5 Yurts, each has 1 queen bed

• There is a weekend package for $450.00

• There is a 4 day Zen package for $600.00

• There is a 2 day Kayak package for $500.00

• There are 20 rooms in the lodge starting at $180.00

• 10 rooms have 1 queen bed

• 5 rooms have 1 king bed (add $20.00)

• 5 rooms have 2 queen beds (add $25.00)

• 1 honeymoon suite for $400.00

Your project must includes the following features:

• Demonstration of good programming practices

• Competence of database operations: Storing, retrieving, altering, and deleting information in a database

• Form handling: Retrieving submitted data, validation, usable patterns for feedback on errors

• User authentication and session management, secure handling of passwords, prevention of SQL injection attacks

• Automatic sending of email, e.g. alerting

You will need to set up your site to run on your USB drive or your ePortfolio site. When you have your site fully tested, make an appointment to review your site with an instructor. The following rubric will be used to grade your project:

https://github.com/blurred-machine/Web-Development-final-project-2017-

== We're Using GitHub Under Protest ==

This project is currently hosted on GitHub. This is not ideal; GitHub is a proprietary, trade-secret system that is not Free and Open Souce Software (FOSS). We are deeply concerned about using a proprietary system like GitHub to develop our FOSS project. I have a website where the project contributors are actively discussing how we can move away from GitHub in the long term. We urge you to read about the Give up GitHub campaign from the Software Freedom Conservancy to understand some of the reasons why GitHub is not a good place to host FOSS projects.

If you are a contributor who personally has already quit using GitHub, please email me at [email protected] for how to send us contributions without using GitHub directly.

Any use of this project's code by GitHub Copilot, past or present, is done without our permission. We do not consent to GitHub's use of this project's code in Copilot.