DBMS/header.php at master · Yashg2910/DBMS · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
<?php require_once 'ti.php' ?>
<?php
session_start();
include_once('connect_db.php');
if(isset($_SESSION['e_id'])){
$id=$_SESSION['e_id'];

$sql = "SELECT E.e_fname, E.e_lname, E.username, E.password, E.dept_id, E.e_bdate, E.Doj, E.permanent_address, E.present_address,E.gender , E.blood_group, E.marital_status, E.mobile, E.designation, E.reporting_manager, E.location, E.account_number, E.ctc, E.email, D.dept_name
FROM employee E, department D
WHERE E.dept_id = D.dept_id AND E.e_id='$id'";
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
    // output data of each row
    while($row = mysqli_fetch_assoc($result)) {
        $fname= $row["e_fname"];
        $lname= $row["e_lname"];
        $department= $row["dept_name"];
        $departmentid = $row["dept_id"];
        $username= $row["username"];
        $password= $row['password'];
        $bdate= $row["e_bdate"];
        $bdate = date("d-m-Y", strtotime($bdate));
        $doj = $row["Doj"];
        $permanent_address= $row["permanent_address"];
        $present_address= $row["present_address"];
        $gender= $row["gender"];
        $blood_group= $row["blood_group"];
        $marital_status = $row["marital_status"];
        $mobile= $row["mobile"];
        $designation = $row["designation"];
        $reporting_manager= $row["reporting_manager"];
        $location= $row["location"];
        $account_number = $row["account_number"];
        $ctc= $row["ctc"];
        $email = $row["email"];
    }
} else {
    echo "0 results";
}

}else{
header("location:http://".$_SERVER['HTTP_HOST'].dirname($_SERVER['PHP_SELF'])."/login.php");
exit();
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
  <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1.0"/>
  <title>HRMS</title>

  <!-- CSS  -->
  <link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet">
  <link href="css/materialize.css" type="text/css" rel="stylesheet" media="screen,projection"/>
  <link href="css/style.css" type="text/css" rel="stylesheet" media="screen,projection"/>
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
</head>
<body>
  <header>
  <nav class="light-blue lighten-1" role="navigation">
    <div class="nav-wrapper container"><a id="logo-container" href="#" class="brand-logo">HRMS</a>

      <ul class="right hide-on-med-and-down">
        <li>
        <form>
          <div class="input-field">
            <input id="search" type="search" required>
            <label class="label-icon" for="search"><i class="material-icons">search</i></label>
            <i class="material-icons">close</i>
          </div>
        </form>
        </li>
        <li><a href="logout.php">LOG OUT</a></li>
      </ul>
      <ul id="nav-mobile" class="sidenav">
        <li><a href="#">Navbar Link</a></li>
      </ul>
      <a href="#" data-target="slide-out" class="sidenav-trigger"><i class="material-icons">menu</i></a>
    </div>
  </nav>

  <!--Side Navigation bar-->
  <ul id="slide-out" class="sidenav sidenav-fixed">
    <li class="center"><div class="user-view">
      <div class="background">
        <img src="images/nav-back.jpg">
      </div>
      <a href="#user"><img class="circle" src="images/yash.jpg" style="width: 100px; height: 100px;margin: auto;"></a>
      <a href="#name"><span class="white-text name"><?php echo $fname; ?></span></a>
      <a href="#email"><span class="white-text email"><?php echo $username; ?></span></a>
    </div></li>
    <li><a class="waves-effect" href="profile.php"><i class="material-icons">person</i>My Profile</a></li>

    <li><a class="waves-effect" href="mydepartment.php"><i class="material-icons">group</i>My Department</a></li>
    <li><a class="waves-effect" href="leave_app.php"><i class="material-icons">book</i>Leave Application</a></li>
    <li><a class="waves-effect" href="profile_update.php"><i class="material-icons">edit</i>Update My Profile</a></li>
  </ul>
  </header>

  <?php startblock('body') ?>
  <?php endblock() ?>

  <footer class="page-footer orange">
    <div class="footer-copyright">
      <div class="container">
      Made by <a class="orange-text text-lighten-3" href="#">Yash & Puja</a>
      </div>
    </div>
  </footer>

  <!--  Scripts-->
  <script src="https://code.jquery.com/jquery-2.1.1.min.js"></script>
  <script src="js/materialize.js"></script>
  <script src="js/init.js"></script>

  </body>
</html>