function showExactOrder($orderid)
{
$db = new SQLite3('data.db');
$query = 'select * from orders where id=(select max(id) from orders)';
$maxid = $db->query($query);
$result = $maxid->fetchArray(SQLITE3_ASSOC);
$n = $result['id'];
$query = 'select * from orders where orderid =' . $orderid;
$result = $db->query($query)->fetchArray(SQLITE3_ASSOC);
echo '<a> #: ' . $orderid . '</a><br><a> состояние: ' . $result['status'] . '</a><br>';
echo '<a> клиент: ' . $result['cus_name'] . '</a><br>';
echo '<a> номер телефона: ' . $result['cus_tel'] . '</a><br>';
echo '<a> адрес: ' . $result['cus_addr'] . '</a><br>';
echo '<a> комментарий: ' . $result['comment'] . '</a><br>';
echo '<table border=1>';
for ($i = 1; $i <= $n; $i++) {
$query = 'select * from orders where id =' . $i;
$result = $db->query($query)->fetchArray(SQLITE3_ASSOC);
if ($result['orderid'] == $orderid) {
echo '<tr>';
echo '<td>' . $result['item'] . '</td>';
echo '<td>' . $result['price'] . '</td>';
echo '<td>' . $result['quan'] . '</td>';
echo '</tr>';
}
}
echo '</table>';
echo 'Сумма заказа: ' . orderCost($orderid);
$db->close();
}
ob_start();
use Respect\Validation\Validator as v;
error_reporting(E_ALL & ~E_WARNING);
function orderCost($connection)
{
$orderCost = 0;
$productsInCart = $_COOKIE['products'];
foreach ($productsInCart as $id => $value) {
$product = \App\DB\Products::get($id, $connection);
$totalPrice = $product['price'] * $value;
$orderCost += $totalPrice;
}
return $orderCost;
}
if (empty($_POST) && isset($_COOKIE['products']) && !empty($_COOKIE['products'])) {
$orderCost = orderCost($connection);
echo "<div class=order-cost> Общая стоимость заказа: <span>{$orderCost}</span> рублей</div>";
include_once "templates/_create-order-form.php";
} elseif (empty($_COOKIE['products'])) {
echo "Ваша корзина пуста";
}
if (!empty($_POST) && isset($_COOKIE['products']) && !empty($_COOKIE['products'])) {
include_once "order_data-validate.php";
// Data sanitising and validation
$errors = [];
$name = nameValidate($errors, $_POST['name']);
$address = addressValidate($errors, $_POST['address']);
$email = emailValidate($errors, $_POST['email']);
$addition = "";
if (v::string()->notEmpty()->validate(filter_var(trim($_POST['addition']), FILTER_SANITIZE_STRING))) {
$addition = filter_var(trim($_POST['addition']), FILTER_SANITIZE_STRING);
