Skip to content
/ c19pvs Public

COMP353 Databases by Khaled Jababo, Fall2021

Notifications You must be signed in to change notification settings

yan-ren/c19pvs

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

44 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

c19pvs

System Specification

The server used for the project runs Scientific Linux 7.9

The version of MYSQL in use this term is 8.0.22 and PHP is version 7.4.14

Setup local dev environment

Goal: setup a local dev environment which is the same as encs server

  1. Install MySQL to computer, verify installation success by entering MySQL server
$ mysql
  1. Login in to MySQL server, create a user, we will use this user later on to access the db. You can change user name and passowrd. Following command creates a user called 'test' with password 'passowrd'
mysql> CREATE USER 'test'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'
  1. Grant user privileges, so that the user can access the db
mysql> GRANT ALL PRIVILEGES ON *.* TO 'test'@'localhost';
mysql> FLUSH PRIVILEGES;
mysql> exit
  1. Create a db called 'knc353_2', which is the same as encs server
mysql> CREATE DATABASE knc353_2;
  1. In your terminal, load the db data to knc353_2 using the db dump file in /db_dump
$ cd db_dump
$ mysql knc353_2 < xxxxx.sql

Now you have the local db setup. In php/db_constant.php file, change the constant variables to use the values just created. For example, user name is 'test', password is 'passowrd'.

DEFINE('DB_USERNAME_LOCAL', 'test');
DEFINE('DB_PASSWORD_LOCAL', 'password');
DEFINE('DB_SERVER_LOCAL', '127.0.0.1:3306');
DEFINE('DB_NAME_LOCAL', 'knc353_2');

Note: because of the config.php has following

if ($_SERVER['REMOTE_ADDR']=='127.0.0.1')

If the request is from the localhost then following values will be used

DEFINE('DB_USERNAME_LOCAL', 'test');
DEFINE('DB_PASSWORD_LOCAL', 'password');
DEFINE('DB_SERVER_LOCAL', '127.0.0.1:3306');
DEFINE('DB_NAME_LOCAL', 'knc353_2');

othwerise, following values will be used

DEFINE('DB_USERNAME', 'knc353_2');
DEFINE('DB_PASSWORD', '65026502');
DEFINE('DB_SERVER', 'knc353.encs.concordia.ca:3306');
DEFINE('DB_NAME', 'knc353_2');
  1. Run php server locally
$ cd c19pvs
$ php -S 127.0.0.1:8001

Upload to encs server

rsync -avz --delete --group=knc353_2 -p --exclude .git --exclude examples/ /Users/yan.ren/github.com/yan.ren/c19pvs/ [email protected]:/www/groups/k/kn_comp353_2/

homepage url https://knc353.encs.concordia.ca/index.php

Design

Homepage

https://knc353.encs.concordia.ca/index.php

Manage

https://knc353.encs.concordia.ca/manage.php has buttons for 1-8, 10 each button leads to a seperate pages that can perform 1-8

Booking

https://knc353.encs.concordia.ca/booking.php for 9, 11, 12

Search

https://knc353.encs.concordia.ca/search.php for 13, 14, 15

Vaccine

https://knc353.encs.concordia.ca/vaccine.php for 16, 17

Report

https://knc353.encs.concordia.ca/report.php for 18, 19, 20

How To

How to get latest change in main into your feature branch using git rebase

  1. get lastest change on remote main branch to local main branch
git checkout main
git pull
  1. rebase your feature branch on main
git checkout your_feature_branch
git rebase main
  1. now your local feature branch is rebased on main, need to push local feature branch to remote
git push --force origin your_feature_branch

About

COMP353 Databases by Khaled Jababo, Fall2021

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 4

  •  
  •  
  •  
  •