RESPONSIVE-BOOK-STORE/admin_page.php at main · Thuvaraki/RESPONSIVE-BOOK-STORE · 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
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
<?php
   include 'config.php';
   session_start();

   $admin_id= $_SESSION['admin_id'];

   if(!isset($admin_id)){
    header('location:login.php');
   }
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>admin panel</title>
    <link rel="stylesheet" href="css/admin_style.css">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.2/css/all.min.css">
</head>
<body>
    <?php
    include 'admin_header.php';
    ?>

    <!-- admin dashboard  section starts -->
         <section class="dashboard">
            <h1 class="title">dashboard</h1>
                 <div class="box-container">

                     <div class="box">
                        <?php
                          $total_pendings = 0;
                          $select_pendings = mysqli_query($conn,"SELECT total_price FROM `orders` WHERE payment_status= 'pending' ") or die('query failed');
                          if(mysqli_num_rows($select_pendings)>0){
                          while($fetch_pendings = mysqli_fetch_assoc($select_pendings)){
                             $total_price = $fetch_pendings['total_price'];
                             $total_pendings += $total_price;
                           };
                          };
                        ?>
                        <h3><?php echo $total_pendings;?></h3>
                        <p>total pendings</p>
                      </div>

                      <div class="box">
                        <?php
                          $total_completed = 0;
                          $select_completed = mysqli_query($conn,"SELECT total_price FROM `orders` WHERE payment_status='completed'") or die('query failed');
                          if(mysqli_num_rows($select_completed)>0){
                          while($fetch_completed = mysqli_fetch_assoc($select_completed)){
                             $total_price = $fetch_completed['total_price'];
                             $total_completed += $total_price;
                           };
                          };
                        ?>
                        <h3><?php echo $total_completed;?></h3>
                        <p>completed payments</p>
                      </div>

                      <div class="box">
                         <?php
                           $select_orders = mysqli_query($conn,"SELECT *FROM `ORDERS`") or die('query failed');
                           $number_of_orders = mysqli_num_rows($select_orders);
                         ?>
                         <h3><?php echo $number_of_orders;?></h3>
                         <p>order placed!</p>
                      </div>

                      <div class="box">
                         <?php
                           $select_products = mysqli_query($conn,"SELECT *FROM `PRODUCTS`") or die('query failed');
                           $number_of_products = mysqli_num_rows($select_products);
                         ?>
                         <h3><?php echo $number_of_products;?></h3>
                         <p>products added</p>
                      </div>

                      <div class="box">
                         <?php
                           $select_users = mysqli_query($conn,"SELECT *FROM `USERS` where user_type='User'") or die('query failed');
                           $number_of_users = mysqli_num_rows($select_users);
                         ?>
                         <h3><?php echo $number_of_users;?></h3>
                         <p>normal users</p>
                      </div>

                      <div class="box">
                         <?php
                           $select_admins = mysqli_query($conn,"SELECT *FROM `USERS` where user_type='Admin'") or die('query failed');
                           $number_of_admins = mysqli_num_rows($select_admins);
                         ?>
                         <h3><?php echo $number_of_admins;?></h3>
                         <p>admin users</p>
                      </div>

                      <div class="box">
                         <?php
                           $select_account = mysqli_query($conn,"SELECT *FROM `USERS`") or die('query failed');
                           $number_of_account = mysqli_num_rows($select_account);
                         ?>
                         <h3><?php echo $number_of_account;?></h3>
                         <p>total accounts</p>
                      </div>

                      <div class="box">
                         <?php
                           $select_messages = mysqli_query($conn,"SELECT *FROM `MESSAGE`") or die('query failed');
                           $number_of_messages = mysqli_num_rows($select_messages);
                         ?>
                         <h3><?php echo $number_of_messages;?></h3>
                         <p>new messages</p>
                      </div>

                 </div>
         </section>
    <!-- admin dashboard section ends -->

    <script src="js/admin_script.js"></script>
</body>
</html>