Server Side Applications and Data Management

Projects

Create a set of web pages on a central theam of your own design.  The web pages are to be a combination of HTML, PHP and MySQL.

The following base functions are required of all projects:

• A Home Page
• A Login page
  • Secure access to certain other pages
  • The Login and Home page may be the same if desired
• Multiple pages using PHP
  • Most pages will be PHP based
  • Other formats such as HTML, text, jpg, Excel are allowed if they fit the theme of the project
• Accessing a relational database using MySQL
• Retrieve information from the DB
• Update data on the DB
• Accessing and updating a text file
• Read a file
• Write to a file (clear the file)
• Append to a file
• Use a session
  • See Login
  • Other uses of sessions is encouraged
• Retrieve data from another web resource - Bonus Points

Intro

The project is to be focused on a central theme

Ideas:

• Grading system
• Admin
  • Login
  • Add/delete teachers
  • Add/delete courses
• Teacher
  • Login
  • Add students
  • Connect student to course
  • Add grades for a course
• Student
• Login
• Retrieve grades for a course
• Inventory system
  • Admin
    • Login
    • Add/delete SKUs
    • Update inventory (reconcilliation)
  • Shipping Receiving
    • Login
    • Add to inventory (incoming vendor shipments/customer returns)
    • Decrease inventory (returns/ship to customers)
  • Customer
    • Browse
      • Check availability (catalog)
    • Login
      • Check availability
      • Order item

Return to top