File manager - Edit - /home/custbahd/irungikitchen.com/admin/orders/history/modal.php
Back
<?php $sql = "SELECT order_code, fname, lname, quantity, SUM(quantity), name, price, subtotal, SUM(subtotal), total, timestamp FROM checkout WHERE month='$month' AND YEAR(timestamp)='$year' GROUP BY order_code ORDER BY timestamp DESC"; //use for MySQLi-OOP $query = $conn->query($sql); while($row = $query->fetch_assoc()){ echo '<tr>'; echo '<td>'.number_format($top_count++).'</td>'; echo '<td>#'.$row['order_code'].'</td>'; echo '<td>'.$row['fname'].' '.$row['lname'].'</td>'; echo '<td>'; echo ''.$row["SUM(quantity)"].''; if ($row["SUM(quantity)"]==1) { echo ' item'; } else { echo ' items'; } echo '</td>'; echo '<td>UGX '.number_format($row["SUM(subtotal)"]).'</td>'; echo '<td>'.date("D, jS M Y", strtotime($row["timestamp"])).'</td>'; echo '<td class="text-center"><a href="../../invoices/invoice/?i='.$row['order_code'].'"><i class="fa fa-caret-right"></i></a></td>'; echo '</tr>'; } ?>
| ver. 1.4 |
Github
|
.
| PHP 8.1.33 | Generation time: 2.01 |
proxy
|
phpinfo
|
Settings