Food-Delivery-System/myorders.php at main · udsy19/Food-Delivery-System · 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
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
<?php
session_start();
require("db_conn.php");

$fetch_order_query = "SELECT `creation_date`, `order_id`, `product_details`,`total` FROM `orders` WHERE username='".$_SESSION['user']."'";

 //Fetched Data in the array format
$product_data = mysqli_fetch_all(mysqli_query($conn,$fetch_order_query),MYSQLI_ASSOC);

?>
<!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">
    <link rel="stylesheet" href="css/style4.css">
    <title>My Orders</title>
</head>
<body>
<nav id="navbar">
            <div class="container">
                <h1 class="logo"><a>7 Maadi
        </a></h1>
        <ul>
                    <li><a href="index.php">Home</a></li>
                    <li><a href="menu.php">Menu</a></li>

                    <?php
                    if(isset($_SESSION["loggedin"]) && ($_SESSION["loggedin"]===true)){

                        if($_SESSION["user"]=='admin')
                        { ?>
                            <li><a href="feedback.php">Customer Feedback</a></li>
                            <?php
                        } else {
                            ?>
                            <li><a href="about.php">About</a></li>
                            <?php
                        }

                        ?>
                        <?php
                    }
                    else{
                        ?>
                        <?php
                    }
                    ?>


                    <!-- -------------- -->
                    <?php
                    if(isset($_SESSION["loggedin"]) && ($_SESSION["loggedin"]===true)){

                        if($_SESSION["user"]=='admin')
                        { ?>
                            <li><a href="price_change.php">Price Change</a></li>
                            <?php
                        } else {
                            ?>
                            <li><a href="contact.php">Contact</a></li>
                            <?php
                        }

                        ?>
                        <?php
                    }
                    else{
                        ?>
                        <?php
                    }
                    ?>
                    <?php
                    //Check if the user is loged in, if yes then the users will be able to items to the cart
                    if(isset($_SESSION["loggedin"]) && ($_SESSION["loggedin"]===true)){

                        if($_SESSION["user"]=='admin')
                        { ?>
                            <li><a href="admin_dashboard.php">Orders</a></li>
                            <?php
                        } else {
                            ?>
                            <li><a class="current" href="myorders.php">My Orders</a></li>
                            <?php
                        }
                        ?>
                        <li><a href="logout.php">LogOut</a></li>
                        <?php
                    }
                    else{
                        ?>

                        <li><a href="contact.php">Contact</a></li>
                        <li><a href="login.php">Login</a></li>
                        <li><a href="sign_up.php">Sign Up</a></li>
                        <?php
                    }
                    ?>
                </ul>
            </div>
        </nav>
    <div class="myorder_container"><?php
        if(count($product_data)>=1){
            ?>
        <div class="myorder_parent">
            <div class="order_id">S.No</div>
            <div class="order_id">Order ID</div>
            <div class="order_date">Order Date</div>
            <div class="products_ordered">Order Details</div>
            <div class="total">Total</div>
        </div><?php
        foreach($product_data as $key => $value){?>
            <div class="myorder_parent">
                <div class="order_id1"><?php echo $key+1;?></div>
                <div class="order_id1"><?php echo $value['order_id'];?></div>
                <div class="order_date1"><?php
                    $date=date_create($value['creation_date']);
                    echo date_format($date,"d-m-Y");
                    ?>
                </div>
                <div class="products_ordered1" ><?php
                    $product_details_array = json_decode($value['product_details']);
                    ?>
                    <table>
                    <?php
                        foreach($product_details_array as $key => $vale) {?>
                        <tr>
                            <td class="td_odd"><?php
                            $fetch_product_query = "SELECT `name` FROM `menu` WHERE prod_code='".$key."'";
                            //Fetched Data in the array format
                            $product = mysqli_fetch_array(mysqli_query($conn,$fetch_product_query),MYSQLI_ASSOC);
                            echo $product['name']; ?>
                            <td class="td_even"><?php echo ' X '.$vale; ?></td>
                        </tr>
                        <?php }
                    ?>
                    </table>
                </div>
                <div class="total1"><?php echo $value['total'];?></div>
            </div>
        <?php }}?>
    </div>
</body>
</html>