<?php

                        // Create connection
                        $conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);

                        foreach ($conn->query('SELECT order_code, customer_email, order_description, order_value, order_date, order_time, order_status
                                        FROM Orders') as $row) {
                            echo '
                                        <tr>
                                            <td><span title="' . $row['order_time'] . '">' . $row['order_date'] . '</span></td>
                                            <td><a href="viewOrder.php?order_code=' . $row['order_code'] . '">' . $row['order_code'] . '</a></td>
                                            <td>' . $row['customer_email'] . '</td>
                                            <td>' . $row['order_description'] . '</td>
                                            <td>$' . $row['order_value'] . '</td>
                                            <td class="text-center">
                                                <span class="label label-table label-'.strtolower($row['order_status']).'">' . $row['order_status'] . '</span></td>
                                        </tr>
                                    ';
                        }

                        $conn->close();

                        ?>