PWeb_FinalProject_Restaurant/admin-user.php at main · weynard02/PWeb_FinalProject_Restaurant · GitHub

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
<?php
    session_start();
    if (!isset($_SESSION['user_id'])){
        header('Location: login.php');
        exit;
    }
    include('config.php');
    $uid = $_SESSION['user_id'];
    $sql = mysqli_query($conn, "SELECT role from users where id='$uid'");
    $row = mysqli_fetch_assoc($sql);
    $role = $row['role'];
    if ($role != 'admin') {
        header('Location: login-form.php');
        exit;
    }

    if(isset($_GET['delete'])){
        $uid = $_GET['delete'];
        $query = "DELETE from users where id = '$uid'";
        $msg = mysqli_query($conn, $query);
        if (!$msg) {
            die("Error executing query: " . mysqli_error($conn));
        }
        header('location:admin-user.php');
     }

?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8" />
    <meta http-equiv="X-UA-Compatible" content="IE=edge" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <title>SubWey Yoraz</title>

    <!-- Fonts -->
    <link rel="preconnect" href="https://fonts.googleapis.com" />
    <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin />

    <link
    href="https://fonts.googleapis.com/css2?family=Poppins:ital,wght@0,100;0,300;0,400;0,700;1,700&display=swap"
    rel="stylesheet"
    />

    <script src="https://unpkg.com/feather-icons"></script>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js" integrity="sha384-geWF76RCwLtnZ8qwWowPQNguL3RmwHVBC9FhGdlKrxdiJJigb/j/68SIy3Te4Bkz" crossorigin="anonymous"></script>
    <script src="js/script.js"></script>

    <!-- My style -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-9ndCyUaIbzAi2FUVXJi0CjmCapSmO7SnpJef0486qhLnuZ2cdeRhO02iuK6FUUVM" crossorigin="anonymous">
    <link rel="stylesheet" href="css/style.css" />


</head>
<body>
    <?php include('admin-navbar.php')?>
    <section class="see-review">
        <div class="container">
            <?php
                if (isset($_SESSION['sukses'])) {
                    echo "<div class='alert alert-success' role='alert'>".$_SESSION['sukses']."</div>";
                    unset($_SESSION['sukses']);
                }
            ?>
        </div>
        <h1>Users</h1>

        <div class="box-container">

            <?php
            $sql = "SELECT * from users";
            $query = mysqli_query($conn, $sql);
            if (mysqli_num_rows($query) > 0) {
                while ($rev = mysqli_fetch_array($query)) {
            ?>
            <div class="box">
                <p> name : <span><?= $rev['name']; ?></span> </p>
                <p> number : <span><?= $rev['number']; ?></span> </p>
                <p> email : <span><?= $rev['email']; ?></span> </p>
                <p> password : <span><?= $rev['password']; ?></span> </p>
                <p> address : <span><?= $rev['address']; ?></span> </p>
                <a href="edit-user.php?edit=<?= $rev['id']; ?>" class="btn-submit">Edit</a>
                <a href="admin-user.php?delete=<?= $rev['id']; ?>" class="btn-delete" onclick="return confirm('delete this user?');">Delete</a>

            </div>
            <?php
                }
            }else {
                echo '<p class="empty">you have no messages</p>';
            }
        ?>

        </div>

    </section>
    <script>
      feather.replace()
    </script>
</body>