main_employee.php

<?php
    session_start();
    if (!isset($_SESSION['loggedin']) || $_SESSION['loggedin'] != true) {
        header("location: index.php");
        exit;
    } else {
        include 'config.php';
        $username   = $_SESSION['username'];
        $query1     = "SELECT city, state, country, zipcode FROM `Address` WHERE address_id = (SELECT a.address_id FROM `Employee` AS g, `Emp_address` AS a WHERE a.emp_id=g.emp_id AND g.username='$username');";
        $query1    .= "SELECT first_name, last_name FROM `Employee` WHERE username = '$username';";
        $res1       = mysqli_multi_query($conn, $query1);
        $i          = 0;
        do {
            if ($result = mysqli_store_result($conn)) {
                while ($row = mysqli_fetch_row($result)) {
                    if ($i == 0) {
                        $city       = $row[0];
                        $state      = $row[1];
                        $country    = $row[2];
                        $zipcode    = $row[3];
                    } else if ($i == 1) {
                        $first_name = $row[0];
                        $last_name  = $row[1];
                    }
                    $i++;
                }
            }
        } while (mysqli_more_results($conn) && mysqli_next_result($conn));
        $query2     = "SELECT contact_no FROM `Emp_contact` WHERE emp_id = (SELECT g.emp_id FROM `Employee` AS g WHERE g.username = '$username');";
        $res2       = mysqli_query($conn, $query2);
        $contacts   = mysqli_num_rows($res2);
        if ($contacts == 1) {
            while($row = mysqli_fetch_assoc($res2)) {
                $contact_no1    = $row["contact_no"];
            }
        } else if ($contacts == 2) {
            $i      = 0;
            while ($row = mysqli_fetch_assoc($res2)) {
                if ($i == 0) {
                    $contact_no1 = $row["contact_no"];
                } else if ($i == 1) {
                    $contact_no2 = $row["contact_no"];
                }
                $i++;
            }
        }
        $query3     = "SELECT email_id FROM `Emp_email` WHERE emp_id = (SELECT g.emp_id FROM `Employee` AS g WHERE g.username = '$username');";
        $res3       = mysqli_query($conn, $query3);
        $emails     = mysqli_num_rows($res3);
        if ($emails == 1) {
            while($row = mysqli_fetch_assoc($res3)) {
                $email1    = $row["email_id"];
            }
        } else if ($emails == 2) {
            $i      = 0;
            while ($row = mysqli_fetch_assoc($res3)) {
                if ($i == 0) {
                    $email1 = $row["email_id"];
                } else if ($i == 1) {
                    $email2 = $row["email_id"];
                }
                $i++;
            }
        }
        $name        = $first_name." ".$last_name;
        $address     = $city.", ".$state.", ".$country.", ".$zipcode;
        if ($contacts == 1) {
            $contact = $contact_no1;
        } else {
            $contact = $contact_no1.", ".$contact_no2;
        }
        if ($emails == 1) {
            $email   = $email1;
        } else {
            $email   = $email1.", ".$email2;
        }
        // code for department part
        // dept_ids : (hard-coded, can be altered later)
        // waiter               = 0
        // room_service         = 1
        // manager              = 2
        // bartender            = 3
        $servs = [
            'waiter' => 0,
            'room_service' => 1,
            'manager' => 2,
            'bartender' => 3
        ];
        if ($_SERVER["REQUEST_METHOD"] == "POST") {
            if (!empty($_POST['serv']) && is_array($_POST['serv'])) {
                $services_selected  = $_POST['serv'];
                $service            = $services_selected[0];
                $n                  = count($services_selected);
                $sql                = "INSERT INTO `Emp_dept` (`emp_id`, `dept_id`) VALUES ((SELECT g.emp_id FROM `Employee` AS g WHERE g.username='$username'), '$servs[$service]');";
                for ($i = 1; $i < $n; $i++) {
                    $service        = $services_selected[$i];
                    $sql           .= "INSERT INTO `Emp_dept` (`emp_id`, `dept_id`) VALUES ((SELECT g.emp_id FROM `Employee` AS g WHERE g.username='$username'), '$servs[$service]');";
                }
                $res                = mysqli_multi_query($conn, $sql);
            }
        }
    }
?>
<!DOCTYPE html>
<html lang="en" style="height: 100%;">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link rel="stylesheet" href="main.css">
    <title>Main</title>
</head>
<body style="background-color: rgb(0, 0, 0); height: 100%;">
    <div class="container" style="height: 100%;">
        <div class="profile">
            <h3>Profile Information - <?php echo $_SESSION['user']; ?></h3>
            <hr/>

            <div class="col-25">
                <h4>Name</h4>
            </div>
            <div class="col-75">
                <h4><?php echo $name; ?></h4>
            </div>
            
            <div class="col-25">
                <h4>Contact</h4>
            </div>
            <div class="col-75">
                <h4><?php echo $contact; ?></h4>
            </div>

            <div class="col-25">
                <h4>Email-Id</h4>
            </div>
            <div class="col-75">
                <h4><?php echo $email; ?></h4>
            </div>

            <div class="col-25">
                <h4>Address</h4>
            </div>
            <div class="col-75">
                <h4><?php echo $address; ?></h4>
            </div>
        </div>

        <div class="foot">

            <div class="dept">
                <div class="service">
                    <form action="main_employee.php" method="post">
                        <h3>Choose your department</h3>
                        <input type="checkbox" name="serv[]" value="waiter">
                        <label>Waiter</label><br>
                        <input type="checkbox" name="serv[]" value="room_service">
                        <label>Room service</label><br>
                        <input type="checkbox" name="serv[]" value="manager">
                        <label>Manager</label><br>
                        <input type="checkbox" name="serv[]" value="bartender">
                        <label>Bartender</label><br>
                        <input type="submit" name="create" value="Submit" class="serv_book">
                    </form>
                </div>
            </div>

            <div class="buttons" style="margin-left: 700px;">
                <div class="form1">
                    <div class="update_bt">
                        <button onclick="location.href = 'update_profile.php';" class="update">Update profile</button>
                    </div>
                </div>
                <div class="form3">
                    <div class="logout_bt">
                        <button onclick="location.href = 'logout.php';" class="logout">Logout</button>
                    </div>
                </div>
            </div>
        </div>
    </div>
</body>
</html>