Database Setup (Required)¶

Choose one of the following methods to set up your database:

Method 1: XAMPP¶

Downloading and Installing XAMPP¶

1. Visit the official XAMPP website: XAMPP
2. Download and install XAMPP for your operating system
3. Start XAMPP Control Panel
4. Start Apache and MySQL services

Configuring Database¶

1. Access phpMyAdmin: phpMyAdmin
2. Create a new database named "itp4915m_se1d_group4"
3. Import your SQL scripts to set up the database structure

Method 2: Docker¶

Downloading and Installing Docker¶

1. Visit Docker Desktop
2. Download and install Docker Desktop for your operating system
3. Start Docker Desktop

Configuring Docker for Your Database¶

1. Create a docker-compose.yml file in your project root:

version: '3'
services:
  db:
    image: mariadb:10.5
    environment:
      MYSQL_ROOT_PASSWORD: rootpassword
      MYSQL_DATABASE: itp4915m_se1d_group4
    ports:
      - "3306:3306"
    volumes:
      - ./sql-scripts:/docker-entrypoint-initdb.d
  phpmyadmin:
    image: phpmyadmin/phpmyadmin
    ports:
      - "8080:80"
    environment:
      PMA_HOST: db
      PMA_USER: root
      PMA_PASSWORD: rootpassword

1. Place your SQL scripts in a folder named sql-scripts in your project directory
2. Open a terminal/command prompt in your project directory
3. Run docker-compose up -d
4. Access phpMyAdmin at phpMyAdmin Docker to manage your database