function phoneFind() { $db = dbConnect(); //$db->debug=1; $phone = htmlentities($_GET['phone'], ENT_QUOTES); $query = "select * from myCustomer where phone = '{$phone}'"; $result = $db->Execute($query); if (!$result) { print "Error with result"; return; } $count = $result->RowCount(); if ($count == 0) { printOrder($phone); } else { $row = $result->FetchRow(); $name = $row['name']; $customer = $row['customerId']; $queryCO = "select * from myCustomerToMyOrder where customerId = '{$customer}'"; $resultCO = $db->Execute($queryCO); $rowCO = $resultCO->FetchRow(); $order = $rowCO['orderId']; $query1 = "Select * from myOrder where orderId='{$order}'"; $result1 = $db->Execute($query1); $row1 = $result1->FetchRow(); $toppingId = $row1['toppingsId']; $sizeId = $row1['sizeId']; printOrder($phone, $name, $toppingId, $sizeId); } }
<a href="/">Магазин</a> <p>Просмотр заказа</p> </div> <div class="row orders clearfix"> <?php if (!$flag) { echo "Такого заказа не существует"; } else { echo "<p class=info>Контактные данные</p>"; echo "<table class=customer>\n <thead><tr>\n <td>ФИО</td>\n <td>Адрес доставки</td>\n <td>Email</td>\n <td>Примечание</td>\n </tr></thead>"; echo "<tbody><tr><td>" . $order['customer_name'] . "</td>"; echo "<td>" . $order['address'] . "</td>"; echo "<td>" . $order['email'] . "</td>"; echo "<td>" . $order['addition'] . "</td><tr></tbody></table>"; echo "<p class=info>Заказанные товары</p>"; include_once "print_orders.php"; echo "<table class=products-table>\n <thead><tr>\n <td>Название товара</td>\n <td>Стоимость</td>\n <td>Количество</td>\n </tr></thead>"; $productsInOrder = \App\DB\OrdersProducts::getProductsInOrder($connection, $order['order_id']); OrderTable($productsInOrder, $connection); echo "</table>"; printOrder($order, $connection); } ?> </div> </div> </div> </div> </div> </section> <?php include_once __DIR__ . '/templates/_footer.php';