Homework 09 - PHP and MySQL Databases

Last Name, First Name

Github Username

Initial Setup

• Run composer install.
• MySQL Host: "mysql-db"
• MySQL Port: 3306
• MySQL Database Name: "cs3620"
• MySQL Table Name: test
• MySQL Username: "cs3620"
• MySQL Password: "letmein"

Homework Description

In this assignment you will work on files in the src/ directory exclusively. You will need to add new code and modify existing code. This assignment will be graded manually and NOT via unit tests. You will need to create the table and seed the database with the sql files in the db/ directory. Please only use the database listed as the SQL will only work there. Here are some url's that you need to paste into your web browser.

• http://localhost/Validation.php?col_string=Two&col_number=2
• http://localhost/SQLInjection.php?col_string=%27Two%27+OR+1=1--&col_number=2

Steps

Part 1 - Data Validation

• Learn about validating input from a user or computer before persisting it. Work on the src/Validation.php.

Part 2 - SQL Injection

• See an example of SQL Injection and fix it using PHP Data Objects. Work on the src/SQLInjection.php.

Notes

• Make sure your last push is before the deadline. Your last push will be considered as your final submission.
• Post questions on Canvas.