/Parking-Lot-System

Parking Lot System to track parking spaces, customers, and staff (PHP & mySQL)

Primary LanguagePHPMIT LicenseMIT


Parking Lot System 🚘

A parking lot database management system for both employees and customers. Built as a group project for UBC CPSC 304 (Relational Databases).

About Me · Report Bug · Request Feature

GitHub contributors GitHub stars GitHub forks GitHub issues GitHub license LinkedIn

Site preview

Table of Contents

Database Diagram 🗒

For the course, we designed, normalized and sketched a database diagram:

DB Diagram

Technology Stack 🛠️

Dependencies used in this project:

XAMPP | MySQL | PHP | Bootstrap

Prerequisites 🍪

You should have XAMPP v7.3.28 and Git installed on your PC.

Setup And Deployment 🔧

  1. Clone the repo using:

      git clone https://github.com/sassansh/Parking-Lot-System.git

  2. Start up XAMPP by pressing Start under General:

XAMPP General

  1. Verify that Apache and MySQL are running under Services.

XAMPP Services

  1. Enable port forwarding by clicking Enable under Network.

XAMPP Network

  1. Mount and open the XAMPP data volume by pressing Mount then Explore under Volumes:

XAMPP Volumes

  1. Copy all files in /htdocs/ of this repo to your XAMPP data volume under /htdocs/.

XAMPP Dir

  1. For database setup, browse to

      http://localhost:8080/phpmyadmin

  2. To setup a new empty database named parking_lot follow these 2 steps:

PHPMyAdmin New

PHPMyAdmin DB Name

  1. To populate the new db with the structure and data, copy the contents of /sql/create_and_insert.sql and run it using phpmyadmin:

PHPMyAdmin SQL

  1. Congrats you are now ready to browse the website. Visit:
  http://localhost:8080/

Insert New Space

Customers

Officers

Count Officers

Lot Rates

The Team 👨🏻‍💻

Sassan Shokoohi - GitHub - LinkedIn

Tony Wu - GitHub - LinkedIn

Jun Kim - GitHub

Contact 📧

Sassan Shokoohi - sassansh@student.ubc.ca

Project Link: https://github.com/sassansh/Parking-Lot-System