-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathusers.php
129 lines (125 loc) · 6.97 KB
/
users.php
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
120
121
122
123
124
125
126
127
128
129
<?php
include("dbCon.php");
session_start();
if(!isset($_SESSION['login_user']))
{
header("Location: login.php");
die();
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no" />
<title>Data Log - Dashboard</title>
<link rel="stylesheet" href="assets/vendors/mdi/css/materialdesignicons.min.css" />
<link rel="stylesheet" href="assets/vendors/flag-icon-css/css/flag-icon.min.css" />
<link rel="stylesheet" href="assets/vendors/css/vendor.bundle.base.css" />
<link rel="stylesheet" href="assets/vendors/font-awesome/css/font-awesome.min.css" />
<link rel="stylesheet" href="assets/vendors/bootstrap-datepicker/bootstrap-datepicker.min.css" />
<link rel="stylesheet" href="assets/css/style.css" />
<link rel="shortcut icon" href="assets/images/favicon.png" />
</head>
<body>
<div class="container-scroller">
<?php
include "leftmenu.php";
?>
<div class="container-fluid page-body-wrapper">
<div id="theme-settings" class="settings-panel">
<i class="settings-close mdi mdi-close"></i>
<p class="settings-heading">SIDEBAR SKINS</p>
<div class="sidebar-bg-options selected" id="sidebar-default-theme">
<div class="img-ss rounded-circle bg-light border mr-3"></div> Default
</div>
<div class="sidebar-bg-options" id="sidebar-dark-theme">
<div class="img-ss rounded-circle bg-dark border mr-3"></div> Dark
</div>
<p class="settings-heading mt-2">HEADER SKINS</p>
<div class="color-tiles mx-0 px-4">
<div class="tiles light"></div>
<div class="tiles dark"></div>
</div>
</div>
<?php
include "header.php";
?>
<div class="main-panel">
<div class="content-wrapper pb-0">
<div class="page-header flex-wrap">
<h3 class="mb-0"> <!--Hi <?php echo $_SESSION['full_name'] ?>, welcome back! -->
</h3>
<div class="d-flex">
<a href="reports.php" class="btn btn btn-warning btn-fw border ml-3">
<i class="mdi mdi-cloud-print menu-icon"></i> REPORTS </a>
<a href="settings.php" class="btn btn-sm ml-3 btn-success">
<i class="mdi mdi-settings menu-icon"></i> SETTING </a>
</div>
</div>
<div class="col-lg-12 grid-margin stretch-card">
<div class="card" style="border-radius: 10px;">
<div class="card-body">
<h4 class="card-title">User Master <a href="userdetails.php?id=0" class="btn btn-sm ml-3 btn-success">NEW USER</a></h4>
<div class="table-responsive">
<table class="table table-striped">
<thead>
<tr>
<th>ID</th>
<th>User ID</th>
<th>Full Name</th>
<th>Mobile</th>
<th>Email</th>
<th>Rule</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$sql = "SELECT u_id, user_id, password, full_name, mobile_no, email_id, U.rule_id, R.rule_name, U.is_active FROM tb_user_master U LEFT JOIN tb_user_rule R ON U.rule_id = R.rule_id;";
$result = $conn->query($sql);
if ($result->num_rows > 0)
{
$i = 0;
while($row = $result->fetch_assoc())
{
echo '<tr class="py-1">';
echo ' <td>' . $row["u_id"] . '</td>';
echo ' <td>' . $row["user_id"] . '</td>';
echo ' <td>' . $row["full_name"] . '</td>';
echo ' <td>' . $row["mobile_no"] . '</td>';
echo ' <td>' . $row["email_id"] . '</td>';
echo ' <td>' . $row["rule_name"] . '</td>';
echo ' <td><a href="userdetails.php?id=' . $row["u_id"] . '"><img src="assets/images/edit.png"></a></td>';
echo '</tr>';
}
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<?php
include "footer.php";
?>
</div>
</div>
</div>
<script src="assets/vendors/js/vendor.bundle.base.js"></script>
<script src="assets/vendors/chart.js/Chart.min.js"></script>
<script src="assets/vendors/bootstrap-datepicker/bootstrap-datepicker.min.js"></script>
<script src="assets/vendors/flot/jquery.flot.js"></script>
<script src="assets/vendors/flot/jquery.flot.resize.js"></script>
<script src="assets/vendors/flot/jquery.flot.categories.js"></script>
<script src="assets/vendors/flot/jquery.flot.fillbetween.js"></script>
<script src="assets/vendors/flot/jquery.flot.stack.js"></script>
<script src="assets/vendors/flot/jquery.flot.pie.js"></script>
<script src="assets/js/off-canvas.js"></script>
<script src="assets/js/hoverable-collapse.js"></script>
<script src="assets/js/misc.js"></script>
<script src="assets/js/dashboard.js"></script>
</body>
</html>