Print online store orders in the admin panel on php

In the current view, you can only do this:

To get non-duplicate customers from orders , then select all orders from the orders table by orders product data. Then in a cycle run through all customers and inside already under all orders. If the customer ID matches, then we display information. And if this is the first line - then we display at the beginning of the customer information. It looks like a crutch and horrible zhuuuuuuuuuuko, but I personally with the current structure of the database could not think of anything better.

 global $link; $sql = 'SELECT DISTINCT customer FROM orders'; $customers = []; if ($result = mysqli_query($link, $sql)) { while ($row = mysqli_fetch_assoc($result)) { $customers[] = $row['customer']; } mysqli_free_result($result); /* echo '<pre>'; print_r($customers); echo '</pre>'; */ } $sql = 'SELECT * FROM orders LEFT JOIN goods USING(id_good)'; $orders = []; if ($result = mysqli_query($link, $sql)) { while ($row = mysqli_fetch_assoc($result)) { $orders[] = $row; } mysqli_free_result($result); /* echo '<pre>'; print_r($orders); echo '</pre>'; */ } foreach ($customers as $customer) { $k = 0; foreach ($orders as $order) { if ($customer == $order['customer']) { $info = ''; if ($k == 0) { $info .= '<h4>Идентификатор заказчика: '.$order['customer'] .'<br />Имя заказчика: '.$order['name_order'] .'<br />E-mail: '.$order['email'] .'<br />Телефон: '.$order['phone'] .'<br />Адрес: '.$order['address'] .'<br />Дата заказа: '.date("dmY H:i:s", $order['datetime']) .'</h4><br />'; } $info .= 'Наименование товара: '.$order['name_good'] .'<br />Количество: '.$order['quantity'] .'<br />Цена: '.$order['price_good'].' руб.' .'<br />'.($order['price_good'] * $order['quantity']).' руб.<br /><br />'; echo $info; $k++; } } echo '<hr />'; } 

You can touch it here: http://phpfiddle.org/main/code/p9dg-mqbi Clicking on Run (I added more orders from user 123)

In general, the structure of the database should be changed. For example, in the orders field customer data is superfluous. They should not be there. Must be a customer ID only. And his data should already be in the customer table for example. In general, with various improvements and restructuring of the database, it is possible to fit everything in one request and it is easier to work.

UPD (from @Mike): With the current database structure in one order physically there can not be more than one product. Since the product ID and its quantity is directly in the order table. I suggest the following changes:

1. Remove the id_good and quantity columns from the orders table

2. Create table "Products in order":

    CREATE TABLE IF NOT EXISTS `order_goods` ( `id_order` int NOT NULL, `id_good` int NOT NULL, `quantity` int NOT NULL, PRIMARY KEY (`id_order`,`id_good`), FOREIGN KEY (`id_order`) REFERENCES orders(`id_order`), FOREIGN KEY (`id_good`) REFERENCES goods(`id_good`) ) 

Then the request for receiving at the same time orders and goods in them will be:

 select O.*, T.quantity, G.price_good, G.name_good from orders O left join order_goods T on T.id_order=O.id_order left join goods G on G.id_good=T.id_good 

At the output, he will give as many lines with the order as the number of goods in the order (or 1 if there are no goods).

In this case, you repeat the whole cycle as many times as there are goods, and you need to make a cycle in the if construction. From the category: if there is an order we print out (we check the sql with the query you already have):

 `$row_order = mysqli_fetch_assoc($query_order); echo '<h4>Идентификатор заказчика: ' .$row_order['customer'].'<br />Имя заказчика: '.$row_order['name_order'].'<br />E-mail: '.$row_order['email'].'<br />Телефон: ' .$row_order['phone'].'<br />Адрес: '.$row_order['address'].'<br />Дата заказа: '.date("dmY H:i:s", $row_order['datetime']). '</h4>'; echo '<br />'; $id_good = $row_order['id_good'];` 

And then in the body of this same if we set your for cycle (with the same conditions as it is), it will already go through only commodity items, and the header will be one.