VIETNAM NATIONAL UNIVERSITY, HO CHI MINH CITY
UNIVERSITY OF TECHNOLOGY
FACULTY OF COMPUTER SCIENCE AND ENGINEERING
UNIVERSITY OF TECHNOLOGY
FACULTY OF COMPUTER SCIENCE AND ENGINEERING
Database Management System / Semester 232
- Download XAMPP here.
- Download this repository, remember to put it in
C:/xampp/htdocsfolder. - Open the repository in
VSCode. Install theLive Server,Live ShareandPHP Serverextensions. - Go to XAMPP localhost, then import the
btl_draft.phpfile to initialize the database. - Click the
Go Livebutton at the bottom right corner, then copy the port to your web browser. - In your web browser, go to this directory
http://localhost/airport_management/index.php
You should be able to access the login page as below
Account for Administrator (With all permissions granted):
Username: sManagerPassword: 123456
Account for normal User (Some permissions are Restricted):
Username: rUserPassword: 123456
As the clip shows, we can perform some simple operations such as:
-
Add, Delete, Update: References to
INSERT,DELETE, andUPDATEoperations in MySQL. -
Viewing: Listing out values in the table, references
SELECToperation in MySQL. -
Handling Errors: As users may make mistakes, we provide a mechanism to prevent so the database remains stable.