API tools faq
paste
Advertisement
Guest User

users.php

a guest
May 24th, 2018
85
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.02 KB | None | 0 0
raw download clone embed print report
  1. <!DOCTYPE html>
  2. <html lang="en">
  3.  
  4. <head>
  5.  
  6. <meta charset="utf-8">
  7. <meta http-equiv="X-UA-Compatible" content="IE=edge">
  8. <meta name="viewport" content="width=device-width, initial-scale=1">
  9. <meta name="description" content="">
  10. <meta name="author" content="">
  11.  
  12. <title>SB Admin 2 - Bootstrap Admin Theme</title>
  13.  
  14. <!-- Bootstrap Core CSS -->
  15. <link href="../vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
  16.  
  17. <!-- MetisMenu CSS -->
  18. <link href="../vendor/metisMenu/metisMenu.min.css" rel="stylesheet">
  19.  
  20. <!-- DataTables CSS -->
  21. <link href="../vendor/datatables-plugins/dataTables.bootstrap.css" rel="stylesheet">
  22.  
  23. <!-- DataTables Responsive CSS -->
  24. <link href="../vendor/datatables-responsive/dataTables.responsive.css" rel="stylesheet">
  25.  
  26. <!-- Custom CSS -->
  27. <link href="../dist/css/sb-admin-2.css" rel="stylesheet">
  28.  
  29. <!-- Custom Fonts -->
  30. <link href="../vendor/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">
  31.  
  32. <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
  33. <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
  34. <!--[if lt IE 9]>
  35. <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
  36. <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
  37. <![endif]-->
  38.  
  39. </head>
  40.  
  41. <body>
  42.  
  43. <div id="wrapper">
  44.  
  45. <!-- Navigation -->
  46. <?php
  47. include_once "../components/navbars.php";
  48. ?>
  49.  
  50. <div id="page-wrapper">
  51. <div class="row">
  52. <div class="col-lg-12">
  53. <h1 class="page-header">Gestão de utilizadores</h1>
  54. </div>
  55. <!-- /.col-lg-12 -->
  56. </div>
  57. <!-- /.row -->
  58. <div class="row">
  59. <div class="col-lg-12">
  60. <div class="panel panel-default">
  61. <div class="panel-heading">
  62. Utilizadores registados
  63. </div>
  64. <form action="#" method="get">
  65. <input type="text" placeholder="Search users..." name="search_users">
  66. <input type="submit" value="Pesquisar">
  67. </form>
  68. <div class="table-responsive">
  69. <table class="table table-striped">
  70. <thead>
  71. <tr>
  72. <th>Id</th>
  73. <th><a href="users.php?sort=u">Username</a></th>
  74. <th><a href="users.php?sort=e">Email</a></th>
  75. <th><a href="users.php?sort=d">Data Criação</a></th>
  76. <th><a href="users.php?sort=r">Perfil</a></th>
  77. <th>Operações</th>
  78. </tr>
  79. </thead>
  80. <tbody>
  81. <?php
  82. if (!isset($_GET['search_users'])) {
  83. $search_users = "%";
  84. } else {
  85. $search_users = $_GET['search_users'] . "%";
  86. }
  87.  
  88. if (isset($_GET['sort'])) {
  89. if ($_GET['sort'] == "u") {
  90. $sort = "username";
  91. } else if ($_GET['sort'] == "e") {
  92. $sort = "email";
  93. } else if ($_GET['sort'] == "d") {
  94. $sort = "date_creation";
  95. } else if ($_GET['sort'] == "r") {
  96. $sort = "roles_descricao";
  97. }
  98. } else {
  99. $sort = "username";
  100. }
  101.  
  102. // Start a BD Connection
  103. require_once "../connections/connection.php";
  104.  
  105. // Create a new DB connection
  106. $link = new_db_connection();
  107.  
  108. $stmt = mysqli_stmt_init($link);
  109. $query = "SELECT id_users, username, date_creation, email, roles_descricao, active
  110. FROM users INNER JOIN roles ON ref_id_roles = id_roles WHERE username LIKE ? ORDER BY $sort";
  111. if (mysqli_stmt_prepare($stmt, $query)) {
  112.  
  113. mysqli_stmt_bind_param($stmt, "s", $search_users);
  114.  
  115. mysqli_stmt_execute($stmt);
  116. mysqli_stmt_bind_result($stmt, $id_user, $username, $date_creation, $email, $roles_descricao, $active);
  117.  
  118. while (mysqli_stmt_fetch($stmt)) {
  119. echo "<tr>";
  120. echo "<td>$id_user</td>";
  121. if ($active == 0) {
  122. echo "<td>$username<i class='fa fa-lock fa-fw'></i></td>";
  123. } else {
  124. echo "<td>$username</td>";
  125. }
  126. echo "<td>$email</td>";
  127. echo "<td>$date_creation</td>";
  128. echo "<td>$roles_descricao</td>";
  129. echo "<td><a href = 'users_edit.php?id=$id_user'><i class='fa fa-edit fa-fw'></i></a></td></tr>";
  130. }
  131. }
  132.  
  133. mysqli_close($link);
  134. ?>
  135. </tbody>
  136. </table>
  137. </div>
  138. <!-- /.table - responsive-->
  139. </div>
  140. <!-- /.panel - body-->
  141. </div>
  142. <!-- /.panel-->
  143. </div>
  144.  
  145. </div>
  146. <!-- /.row-->
  147. </div>
  148. <!-- /#page-wrapper -->
  149.  
  150. </div>
  151. <!-- /#wrapper -->
  152.  
  153. <!--jQuery -->
  154. <script src="../vendor/jquery/jquery.min.js"></script>
  155.  
  156. <!--Bootstrap Core JavaScript-->
  157. <script src="../vendor/bootstrap/js/bootstrap.min.js"></script>
  158.  
  159. <!--Metis Menu Plugin JavaScript-->
  160. <script src="../vendor/metisMenu/metisMenu.min.js"></script>
  161.  
  162. <!--DataTables JavaScript-->
  163. <script src="../vendor/datatables/js/jquery.dataTables.min.js"></script>
  164. <script src="../vendor/datatables-plugins/dataTables.bootstrap.min.js"></script>
  165. <script src="../vendor/datatables-responsive/dataTables.responsive.js"></script>
  166.  
  167. <!--Custom Theme JavaScript-->
  168. <script src="../dist/js/sb-admin-2.js"></script>
  169.  
  170. <!--Page-Level Demo Scripts - Tables - Use for reference-->
  171. <script>
  172. $(document).ready(function () {
  173. $('#dataTables-example').DataTable({
  174. responsive: true
  175. });
  176. });
  177. </script>
  178.  
  179. </body>
  180.  
  181. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!