BookStore/orders.php at main · RiyaM16/BookStore · 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
122
123
124
125
<html>
<head>
<title>Current orders</title>
<!-- Bootstrap -->
<link href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-giJF6kkoqNQ00vy+HMDP7azOuL0xtbfIcaT9wjKHr8RbDVddVHyTfAAsrekwKmP1" crossorigin="anonymous">

</head>
<body>

<nav class="navbar navbar-expand-lg navbar-white bg-dark" >
  <div class="container-fluid">
  <a class="navbar-brand" href="index.php" style="margin: -14px 0px -22px -19px;"><img class="img-responsive" alt="Brand" src="img/logo.png"  style="width: 127px;margin: 0px;"></a>
    <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
      <span class="navbar-toggler-icon"></span>
    </button>
    <div class="collapse navbar-collapse" id="navbarSupportedContent">

      <ul class="navbar-nav ms-auto mb-2 mb-lg-0">
      <li class="nav-item">
          <a class="nav-link" href="admin.php" style="color: white;">View books</a>
        </li>
        <li class="nav-item">
          <a class="nav-link" href="add.php" style="color: white;">Add book</a>
        </li>

        </ul>
    </div>
  </div>
</nav>
<?php

session_start();
global $var;
include "dbconnect.php";

    $sql = "SELECT * FROM orders ORDER BY Status";
    $result = $con->query($sql);
        if(mysqli_num_rows($result) > 0)
        {

            echo '
            <h2 class="text-center p-3">Orders</h2>
            <div class="container">
            <table class="table table-bordered table-hover ">
            <thead>
                <tr>
                <th scope="col" style="text-align: center;">Order ID</th>
                <th scope="col" style="text-align: center;">Username</th>
                <th scope="col" style="text-align: center;">Product ID</th>
                <th scope="col" style="text-align: center;">Quantity</th>
                <th scope="col" style="text-align: center;">Date</th>
                <th scope="col" style="text-align: center;">Price</th>
                <th scope="col" style="text-align: center;">Status</th>
                <th scope="col" style="text-align: center;">Change Status</th>
                </tr>
            </thead>
            <tbody>
            ';
            while($row = mysqli_fetch_assoc($result))
            {

            echo'
            <tr>
              <td style="text-align: center;">' . $row["OrderID"] . '</td>
              <td style="text-align: center;">' . $row["Customer"] . '</td>
              <td style="text-align: center;">' . $row["Product"] . '</td>
              <td style="text-align: center;">' . $row["Quantity"] . '</td>
              <td style="text-align: center;">' . $row["Date"] .'</td>
              <td style="text-align: center;">' . $row["Price"] .'</td>';
              if($row["Status"]==0)
              {
                $st = 'In progress';
                // $var = $row["OrderID"];
                  echo '
                <td style="text-align: center;">' . $st .'</td>
                <td  style="text-align: center;">
                <form class="form" role="form" method="post" action="orders.php" accept-charset="UTF-8">
                <button type="submit" name="submit" value="delivered" style="border-radius: 12px; padding: 5px;">Delivered
                </button>
                </div>
                </form>
                </td>';

              }
            else{
                $st = 'Delivered';

                echo '
                <td style="text-align: center;">' . $st .'</td> ';
            }
            echo '
            </tr>';


            }
        }
    echo '</tbody>
        </table>
        </div>';

    ?>
<?php
if(isset($_POST['submit']))
{
  if($_POST['submit']=="delivered")
    {


    $sql = "SELECT * FROM orders ORDER BY Status";
    $result = $con->query($sql);
      $row = mysqli_fetch_assoc($result);
      $sql = "UPDATE orders SET Status = 1 where OrderID =".$row["OrderID"]."";
      $result = $con->query($sql);
      print'
      <script type="text/javascript">
       window.location.href = "orders.php";
      </script>
     ';
    }
}
?>

</div>
</body>
</html>