PHP Data Objects

Due: 11:00pm, Thursday, November 17, 2022

Assignment Description

The assignment7 directory contains an incomplete multiple page CRUD application. There is a a SQLite database file named user.db with the following table schema:

CREATE TABLE user (
  name TEXT NOT NULL,
  email TEXT NOT NULL PRIMARY KEY,
  dob TEXT NOT NULL,
  password TEXT NOT NULL
);

You are to finish the implementation of the CRUD application by using a PHP Data Object to connect to the database and execute the appropriate SQL statements. Prepared statements must be used for statements that use form data. The sections of code that you need to implement are in the index.php and search.php files and are denoted with comments containing the text TODO.

The user.db file needs to have write permissions in order for the PHP programs to write to the file. To enable write permissions, execute the following two commands from within the project8-handout directory:

    chmod ugo+w user.db
    chmod ugo+w .

Note: in this assignment we are storing passwords in plaintext; we should not do this in general.

Instructions

To start the assignment, login to your university Linux account and copy the assignment code to a location somewhere under your public_html directory. The assignment code is located at:

/export/home/public/schwesin/csc242/projects/project8-handout

You need to edit the index.php and search.php files. Do not change the names of any of the files.

To submit your assignment, execute the following command from within your project8-handout directory:

    ~schwesin/bin/submit csc242 project8

Grading Criteria

Note: If the code has syntax errors or does not execute properly (this includes warnings from PHP interpreter), you will receive a failing grade for this assignment. If the submission includes material that was not covered in class and the material is not properly cited, then you will receive a failing grade for this assignment.