HolidayHotelBooking

Student Holiday Hotel Booking system project made for database course. System offers 3 roles: client, manager and reception. Each role has its own functions and UIs but every of them operate on the same SQL database.

Launching

Clone repo into into

git clone https://github.com/matmarczuk/HolidayHotelBooking.git

Log in into mysql local server

mysql -u <username> -p

Create database

mysql> source <path_to_cloned_dir>\construct_db.sql;

Fill database with example records

mysql> source <path_to_cloned_dir>\insert_example_data.sql;

Insert user,socket dir and host into connect.php file

$socket = '<server_socket_dir>';
$host = "<host_name>";
$db_user = "<username>";
$db_password = "<password>";
$db_name = "mydb1";
  

Run one of the type of service using your browser

<host_name>/client  

Example screenshots

Client website Manager panel