-
Notifications
You must be signed in to change notification settings - Fork 0
/
user_home.php
71 lines (65 loc) · 2.59 KB
/
user_home.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
<?php
include("header.php");
include("connect.php");
$id = $_GET["id"];
?>
<body>
<div class="container">
<div id="loginbox" style="margin-top:50px;" class="mainbox col-md-12">
<div class="panel panel-info" >
<div class="panel-heading">
<div class="panel-title">User Dashboard
<a href='http://localhost/mynet/'><button style="float: right;" type='button'>Logout</button></a>
</div>
</div>
<div style="padding-top:30px" class="panel-body" >
<div style="display:none" id="login-alert" class="alert alert-danger col-sm-12"></div>
<table border="1">
<thead>
<tr>
<th>ID</th>
<th>Name</th>
<th>Username</th>
<th>IC Number</th>
<th>Email</th>
<th>Date Created</th>
<th>Date Modified</th>
<th>User Level</th>
<th>Edit</th>
</tr>
</thead>
<tbody>
<form action="delete_action.php" method="POST">
<?php
$sql = mysqli_query($dbhandle,"SELECT a.id,a.name,a.username,a.ic_no,a.email,a.created,a.modified,b.description FROM users a, user_levels b WHERE a.user_level = b.id and a.id = $id");
while ($data = mysqli_fetch_array($sql)) {
?>
<tr>
<td> <?php echo $data['id']; ?> </td>
<td> <?php echo $data['name']; ?> </td>
<td> <?php echo $data['username']; ?> </td>
<td> <?php echo $data['ic_no']; ?> </td>
<td> <?php echo $data['email']; ?> </td>
<td> <?php
$created = date_format(new DateTime($data['created']),"d/m/Y");
echo $created; ?> </td>
<td> <?php
if(isset($data['modified'])){
$modified = date_format(new DateTime($data['modified']),"d/m/Y");
echo $modified; }?> </td>
<td> <?php echo $data['description']; ?> </td>
<td> <a href='user_edit.php?id=<?php echo $id; ?>'><button type='button'>Edit Profile</button></a> </td>
</tr>
<?php
}
?>
</form>
</tbody>
</table>
</div>
</div>
</div>
</div> <!-- /container -->
<script src="js/ie10-viewport-bug-workaround.js"></script>
</body>
</html>