PHP Programming
This is my portfolio/landing page for this semester's CPT283 course at Greenville Technical College in Greenville, SC.
Links to the weekly Lab assignments
Exercise 2-1
Build the Product Discount application This lab introduces $_POST arrays to receive and work with user input data.
Exercise 2-2
Enhance the Future Value application This lab introduces input data validation, error messages, and the PHP date() function.
Exercise 4-1
Enhance the Product Manager Application This lab introduces the process of connecting SQL database management with the PHP backed and HTML webpage code.
Exercise 5-1
Enhance the Guitar Shop application This lab introduces the MVC pattern to organize code.
Exercise 6-1
Trace with echo statements This lab practices using 'echo' statements to trace the execution of code.
Exercise 7-1
Get input and display output This lab uses forms with a variety of controls to get and display data.
Exercise 7-2
Enhance the Future Value application This lab demonstrates the use of drop-down boxes in web forms.
Exercise 8-1
Use if and switch statements This lab uses if and switch statements with conditional expressions to calulate discount percentages.
Exercise 8-2
Use loops This lab uses for loops to calculate numbers and to populate drop-down lists.
Exercise 9-1
Write code that works with strings This lab normalizes, formats, and validates string data from user input..
Exercise 9-2
Write code that works with numbers This lab normalizes, formats, and validates numeric data from user input.
Exercise 10-1
Write code that works with dates This lab receives, formats, and calculates due dates as DateTime objects.
Exercise 11-1
Work with arrays This lab uses array creation and manipulation to set, unset, modify, and rearrange a task list.
Exercise 12-1
Modify the Shopping Cart application This lab uses $_SESSION variables and setcookie() to manage the user session.
Exercise 12-2
Improve the Task List Manager application This lab uses session variables to story user data instead of hidden fields..
Exercise 13-1
Modify the Shopping Cart application This lab uses a namespace. functions, and an array to operate the shopping cart.
Exercise 14-1
Modify the Product Manager application This lab uses classes and objects to construct the Guitar Shop catalog from Lab 5.
Exercise 15-1
Modify the Registration application This lab uses regular expressions to validate data from user input forms.
Exercise 15-2
Improve the Product Manager application This lab implements a Validate class to validate user input.
Exercise 16 1-2
SQL Database Design This lab creates UML charts for three databases.
Links to Final Project pages
Landing Page
Link to project index page.
Project Outline
Preliminary outline showing the MVC pattern planned, and the names of key pages and functions
SQL DB Dump
Preliminary setup for the MySQL database
Project Lab 2
Connect database to a PHP program. This demonstrates the database connection and pulls test data for display.
Project Lab 3
Interface to add records. This uses a text input form to add a new vehicle record to the database.
Project Lab 4
Interface to edit/update records. This queries the database for current data, and then sends an update based on user input.
Project Lab 5
Navigation and Interface Enhancements: report
Project Lab 6
Interfaces to all database tables: report.
Project Lab 7: Progress Report 1
State of the project, next steps, and future plans.
Project Lab 8: Admin Login
Added admin login (cpt283/webapps) with PHP $_SESSION variables.
Project Lab 9: Data Validation
Added custom error messages when adding or editing data for vehicles, fuel, maintenance, and maintenance types.
Project Lab 10: Admin interface to delete records
Added a delete button for each record -- with confirmation, a success alert message, and a redirect.