profile.php 7.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202
  1. <?php
  2. session_start();
  3. if (!isset($_SESSION['loggedin'])) {
  4. header('Location: Login.html');
  5. exit;
  6. }
  7. $DATABASE_HOST = 'localhost:8080';
  8. $DATABASE_USER = 'maabim';
  9. $DATABASE_PASS = 'maabim001';
  10. $DATABASE_NAME = 'phplogin';
  11. $con = mysqli_connect($DATABASE_HOST, $DATABASE_USER, $DATABASE_PASS, $DATABASE_NAME);
  12. if (mysqli_connect_errno()) {
  13. exit('Failed to connect to MySQL: ' . mysqli_connect_error());
  14. }
  15. $stmt = $con->prepare('SELECT password, email FROM accounts WHERE id = ?');
  16. $stmt->bind_param('i', $_SESSION['id']);
  17. $stmt->execute();
  18. $stmt->bind_result($password, $email);
  19. $stmt->fetch();
  20. $stmt->close();
  21. ?>
  22. <!DOCTYPE html>
  23. <html lang="en">
  24. <head>
  25. <meta charset="utf-8">
  26. <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  27. <title>Unity WebGL Player | C3</title>
  28. <link rel="shortcut icon" href="TemplateData/favicon.ico">
  29. <link rel="stylesheet" href="./script/css/styles.css">
  30. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
  31. <link href="../css/sb-admin-2.min.css" rel="stylesheet">
  32. <link href="https://fonts.googleapis.com/css?family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i" rel="stylesheet">
  33. <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
  34. <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
  35. <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
  36. <script src="https://cdn.jsdelivr.net/npm/chart.js@2.8.0"></script>
  37. </head>
  38. <body>
  39. <div id="wrapper">
  40. <!-- Sidebar -->
  41. <ul class="navbar-nav bg-gradient-primary sidebar sidebar-dark accordion" id="accordionSidebar">
  42. <!-- Sidebar - Brand -->
  43. <a class="sidebar-brand d-flex align-items-center justify-content-center" href="homepage.php">
  44. <div class="sidebar-brand-icon rotate-n-15">
  45. <i class="fas fa-laugh-wink"></i>
  46. </div>
  47. <div class="sidebar-brand-text mx-3">MAA</div>
  48. </a>
  49. <!-- Divider -->
  50. <hr class="sidebar-divider my-0">
  51. <!-- Nav Item - Dashboard -->
  52. <li class="nav-item active">
  53. <a class="nav-link" href="../../homepage.php">
  54. <i class="fas fa-fw fa-tachometer-alt"></i>
  55. <span>首頁</span></a>
  56. </li>
  57. <!-- Nav Item - Dashboard -->
  58. <li class="nav-item active accordion accordion-flush list-group list-group-root well" id="accordionFlushExample">
  59. <a class="nav-link " href="#C3Equipment" data-toggle="collapse">
  60. <i class="fas fa-fw fa-tachometer-alt"></i>
  61. <span>C3監測儀器</span></a>
  62. <div class="list-group collapse" id="C3Equipment">
  63. <a class="nav-link " href="index.php" onclick="passString('ELP')">
  64. <i class="fas fa-fw fa-tachometer-alt"></i>
  65. <span>水壓計</span></a>
  66. <a class="nav-link " href="index.php" onclick="passString('OW')">
  67. <i class="fas fa-fw fa-tachometer-alt"></i>
  68. <span>水位觀測井</span></a>
  69. <a class="nav-link " href="index.php" onclick="passString('SIS')">
  70. <i class="fas fa-fw fa-tachometer-alt"></i>
  71. <span>傾度管(壁外)</span></a>
  72. <a class="nav-link " href="index.php" onclick="passString('SID')">
  73. <i class="fas fa-fw fa-tachometer-alt"></i>
  74. <span>傾度管(壁中)</span></a>
  75. <a class="nav-link " href="index.php" onclick="passString('TI')">
  76. <i class="fas fa-fw fa-tachometer-alt"></i>
  77. <span>建物傾斜計</span></a>
  78. <a class="nav-link " href="index.php" onclick="passString('RS')">
  79. <i class="fas fa-fw fa-tachometer-alt"></i>
  80. <span>鋼筋應力計</span></a>
  81. <a class="nav-link " href="index.php" onclick="passString('SM')">
  82. <i class="fas fa-fw fa-tachometer-alt"></i>
  83. <span>地表沉陷觀測釘</span></a>
  84. <a class="nav-link " href="index.php" onclick="passString('SB')">
  85. <i class="fas fa-fw fa-tachometer-alt"></i>
  86. <span>建物沉陷點</span></a>
  87. <a class="nav-link " href="index.php" onclick="passString('SBM')">
  88. <i class="fas fa-fw fa-tachometer-alt"></i>
  89. <span>墩柱水平位移點</span></a>
  90. <a class="nav-link " href="index.php" onclick="passString('HM')">
  91. <i class="fas fa-fw fa-tachometer-alt"></i>
  92. <span>逆打鋼柱沉陷隆起點</span></a>
  93. <a class="nav-link " href="index.php" onclick="passString('VG')">
  94. <i class="fas fa-fw fa-tachometer-alt"></i>
  95. <span>支撐應變計</span></a>
  96. </div>
  97. </li>
  98. <!-- Nav Item - Charts -->
  99. <li class="nav-item">
  100. <a class="nav-link" href="../../warning.php">
  101. <i class="fas fa-fw fa-chart-area"></i>
  102. <span>異常監測儀器</span></a>
  103. </li>
  104. <!-- Nav Item - Charts -->
  105. <li class="nav-item">
  106. <a class="nav-link" href="../../uploadCSV.php">
  107. <i class="fas fa-fw fa-chart-area"></i>
  108. <span>上傳CSV</span></a>
  109. </li>
  110. <!-- Divider -->
  111. <hr class="sidebar-divider d-none d-md-block">
  112. </ul>
  113. <!-- End of Sidebar -->
  114. <div id="content-wrapper" class="d-flex flex-column">
  115. <!-- Main Content -->
  116. <div id="content">
  117. <!-- Topbar -->
  118. <nav class="navbar navbar-expand navbar-light bg-white topbar mb-4 static-top shadow">
  119. <!-- Topbar Navbar -->
  120. <ul class="navbar-nav ml-auto">
  121. <!-- Nav Item - User Information -->
  122. <li class="nav-item dropdown no-arrow">
  123. <a class="nav-link dropdown-toggle" href="#" id="userDropdown" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
  124. <span class="mr-2 d-none d-lg-inline text-gray-600 small"><?php echo $_SESSION['name']; ?></span>
  125. </a>
  126. <!-- Dropdown - User Information -->
  127. <div class="dropdown-menu dropdown-menu-right shadow animated--grow-in" aria-labelledby="userDropdown">
  128. <a class="dropdown-item" href="./profile.php">
  129. <i class="fas fa-user fa-sm fa-fw mr-2 text-gray-400"></i>
  130. Profile
  131. </a>
  132. <div class="dropdown-divider"></div>
  133. <a class="dropdown-item" href="./Logout.php">
  134. <i class="fas fa-sign-out-alt fa-sm fa-fw mr-2 text-gray-400"></i>
  135. Logout
  136. </a>
  137. </div>
  138. </li>
  139. </ul>
  140. </nav>
  141. <!-- End of Topbar -->
  142. <!-- Begin Page Content -->
  143. <div class="container-fluid">
  144. <!-- Page Heading -->
  145. <div class="d-sm-flex align-items-center justify-content-between mb-4">
  146. <h1 class="h3 mb-0 text-gray-800">Profile Page</h1>
  147. </div>
  148. <div>
  149. <p>Your account details are below:</p>
  150. <table>
  151. <tr>
  152. <td>Username:</td>
  153. <td><?= $_SESSION['name'] ?></td>
  154. </tr>
  155. <tr>
  156. <td>Email:</td>
  157. <td><?= $email ?></td>
  158. </tr>
  159. </table>
  160. </div>
  161. </div>
  162. <!-- /.container-fluid -->
  163. </div>
  164. <!-- End of Main Content -->
  165. <script>
  166. //Pass monitor equipment's name to index.php select form
  167. function passString(option) {
  168. window.localStorage.setItem("option", option);
  169. }
  170. </script>
  171. </body>
  172. </html>