The entire website was mostly coded using PHP with HTML elements for display. The functionality of the PHP was to both run SQL code, and to execute loops and functions to manage login forms, displaying of notes, and verification of login data against SQL queries.

There is also PHP code in place to prevent cross site scripting attacks, and SQL injections.

The SQL code used in this project consisted of a connection script to connect to the database, as well as selecting, updating, deleting, and inserting data from and into the database.

The insert code was executed whenever the user added a new note, or when the user signed up for the site.

Updating was done whenever there was a change in status of a note from either active, to archived, and finished with a delete command if the user wished to delete the note from the archive.

Selection was performed first when a user logs into the site. A query matches log in information and provides a contextual error if there is one, or a success message on successful login. More selection is performed immediately after by querying the user’s id against the notes in the database, and returning the information to be displayed in the PHP loop to display the user’s notes.

The layout and styling of the site was all done using basic Bootstrap for forms, headers, and grid styled layouts.