-
Notifications
You must be signed in to change notification settings - Fork 0
/
user.php
95 lines (88 loc) · 3.27 KB
/
user.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
<?php
session_start();
if(!isset($_SESSION['user_session'])) {
header("Location: login.php");
die();
}
require 'database.php';
require 'modules/get_user_info.php';
require 'modules/get_user_type.php';
//Allow Only System_Owner
if($user_info['type'] != 0) {
setcookie('alert', 'permission_denial');
header("Location: index.php");
die();
}
if(isset($_GET['id'])) {
$sql = mysqli_prepare($db,"SELECT u.id, u.username, u.type, t.name as type_name FROM users as u JOIN users_type as t ON u.type = t.type WHERE u.id = ?");
mysqli_stmt_bind_param($sql, 's', $_GET['id']);
mysqli_stmt_execute($sql);
$user_result = mysqli_stmt_get_result($sql);
$user_row = mysqli_fetch_array($user_result);
} else {
header("Location: users.php");
die();
}
?>
<html>
<head>
<title>Users Management | PHP-OpenTickets</title>
<?php include 'modules/head.php'; ?>
</head>
<body>
<div class="admin-container">
<?php include('modules/leftside.php'); ?>
<?php
if(isset($_POST['edit_user'])) {
$username = $_POST['username'];
$type = $_POST['type'];
$edit_user = mysqli_prepare($db, "UPDATE users SET username = ?, type = ? WHERE id = ?");
mysqli_stmt_bind_param($edit_user, 'sss', $username, $type, $user_row['id']);
if(mysqli_stmt_execute($edit_user)) {
echo "<script>
Swal.fire({
icon: 'success',
title: 'Successfully Updating Data!',
}).then((result) => {
if (result.isConfirmed) {
window.location.reload();
}
})
</script>";
} else {
echo "<script>
Swal.fire({
icoon: 'error',
title: 'There are some error..',
content: ".mysqli_connect_errno($edit_user).",
})
</script>";
}
}
?>
<div class="container white pb-50">
<h1 class="bb-blue"><i class="fa-solid fa-user mr-10"></i>Manage User: <?=htmlentities($user_row['username'])?></h1>
<form action="" method="post">
<input type="text" name="username" placeholder="Username" autocomplete="off" value="<?=$user_row['username']?>">
ประเภท:
<select name="type" id="">
<?php
while($user_type = mysqli_fetch_array($get_user_type)) {
?>
<option value="<?=$user_type['type']?>" <?php
if($user_type['type'] == $user_row['type']) {echo "Selected";}
?>><?=$user_type['name']?></option>
<?php
}
?>
</select>
<input type="submit" value="Save" name="edit_user" class="btn darkblue">
</form>
</div>
</div>
<?php include('modules/footer.php');?>
</body>
</html>
<?php
mysqli_close($db);
?>