Bingus Music Shop

A modern web application built using PHP with the MVC pattern and MySQL for a musical instrument retailer. Made for the Level 5 Web Programming Unit at Bournemouth University. The website is currently hosted on my VPS at https://bingus-music-shop.joeblakeb.com/.

The Self Reflection is in the documentation directory and the lab and tutorial tasks are available in my WebProgramming2022 repository.

SQL Database Setup

Database Structure

The database structure must be manually created before using the website. The CREATE script is in the databaseStructure.sql file in the model directory. It also incldes a command to create the admin user. The DROP commands are commented out at the bottom of the file. An entity relationship diagram for the structure is available in the documentation directory as DatabaseERD.drawio.svg.

Database Credentials

The credentials for accessing a MySQL database should be stored in a file called databaseCredentials.json in inside the model directory in the following format:

{
    "database": "",
    "hostname": "",
    "username": "",
    "password": "",
    "port":     0
}

References

• Font Awesome 6.2.0, available at FontAwesome.com, License.
• FredokaOne Font, by Milena Brandao, available at Google Fonts, License.
• Open Sans Font, by Steve Matteson, available at Google Fonts, License.
• Ubuntu Font, by Dalton Maag, available at Google Fonts, License.
• Countries Array, by html-code-generator.com, available at html-code-generator.com

Copyright (c) 2022 JoeBlakeB (Joe Baker), All Rights Reserved.