function OrderTable($ordersProducts, $connection)
{
foreach ($ordersProducts as $arrayNumber => $orders_data) {
echo "<tr class='product'>";
foreach ($orders_data as $data_key => $data_value) {
//echo "data-key: ".$data_key." data-value: ".$data_value."<br>";
switch ($data_key) {
case "product_id":
$product = \App\DB\Products::get($data_value, $connection);
$flag = v::arr()->notEmpty()->validate($product);
if ($flag) {
printProduct($product);
} else {
echo "<td class='deleted-product' colspan='2'>Товар удален из базы данных</td>";
}
break;
case "amount":
echo "<td data-amount='{$data_value}'>" . $data_value . "</td></tr>";
break;
default:
break;
}
}
}
}
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;
}
public function __construct(Connection $connection, $name, $address, $email, $addition)
{
parent::__construct($connection, $name, $address, $email, $addition);
$productsInCart = $_COOKIE['products'];
$cost = 0;
$this->order_id = parent::getCurrentId($connection);
foreach ($productsInCart as $id => $value) {
$product = Products::get($id, $connection);
$cost += $product['price'] * $value;
$insProd = $connection->prepare('INSERT INTO `ordersproducts`
(`order_id`, `product_id`, `amount`)
VALUES (:order_id, :product_id, :amount)');
$insProd->execute([":order_id" => $this->order_id, ":product_id" => $id, ":amount" => $value]);
}
parent::setPrice($connection, $cost, $this->order_id);
}
function showTableOrders($connection)
{
echo "Заказы в таблице Orders<br/>";
$statement = $connection->prepare("SELECT * FROM `orders`");
$statement->execute();
$statement->setFetchMode(PDO::FETCH_ASSOC);
echo "<table class='prod_tab'>\n\t\t<thead><td>Id</td><td>Номер заказа</td><td>ФИО</td><td>Адрес</td><td>E-mail</td></thead>\n\t\t<tbody>";
while ($row = $statement->fetch()) {
echo "<tr><td>" . $row['id'] . "</td><td>" . $row['num_order'] . "</td><td>" . $row['fio'] . "</td><td>" . $row['address'] . "</td><td>" . $row['email'] . "</td></tr>\n\t\t\t<tr><td><table>";
$itogo = 0;
$stmt = $connection->prepare("SELECT * FROM `order_product` WHERE `num_order` = :num_ord");
$stmt->execute(['num_ord' => $row['num_order']]);
$productsInCart = $stmt->fetchAll(\PDO::FETCH_ASSOC);
foreach ($productsInCart as $id => $prd) {
$product = \App\DB\Products::get($prd['id_prod'], $connection);
echo "<tr><td>" . $product['name'] . "</td><td>" . $prd['amount_prod'] . "</td><td>" . $product['price'] . "</td></tr>";
$itogo += $prd['amount_prod'] * $product['price'];
}
echo "<tr><td colspan='2'>Итого</td><td>" . $itogo . "</td></tr>";
echo "</table></td></tr>";
}
echo "</tbody></table>";
}
<?php
if (isset($_GET['item_id'])) {
$id = $_GET['item_id'];
$pro_info = \App\DB\Products::get($id, $connection);
}
if (isset($_GET['item_id'])) {
?>
<h2>Редактирование товара</h2>
<form class="edit-elem-form" name="edit-form" method="post" action="/admin/?to_do=edit_item_tb&item_id=<?php
echo $id;
?>
&item_act=edit">
<input name="tek_id" type="hidden" value="<?php
echo $pro_info['id'];
?>
"/>
<label>
<p>Title</p>
<input name="t_title" type="text" value="<?php
echo $pro_info['name'];
?>
" />
</label>
<label>
<p>Description</p>
<input name="t_descr" type="text" value="<?php
echo $pro_info['description'];
?>
" />
</label>
<?php
if (isset($_GET['item']) && is_numeric($_GET['item'])) {
$item = $_GET['item'];
$product = \App\DB\Products::get($item, $connection);
if ($product) {
if (isset($_COOKIE['products'][$product['id']])) {
$value = $_COOKIE['products'][$product['id']] + 1;
} else {
$value = 1;
}
setcookie("products[{$product['id']}]", $value, time() + 3 * 24 * 60 * 60, "/");
}
//получаем общее кол-во товаров в корзине для вывода в верхнем меню (+1, т.к. setcookie срабатывает только при перезагрузке страницы)
$amount = \App\Utilities\Cookie::getBascketAmount() + 1;
echo $amount;
}
<p>Изменение товара</p>
</div>
<div class="row clearfix">
<?php
use Respect\Validation\Validator as v;
// Проверяем, существует ли запрошенный ID в базе данных
if (isset($_GET['id'])) {
$id = $_GET['id'];
} else {
$id = 'error';
}
if (!is_numeric($id)) {
echo "Введите ID в корректном формате";
echo "<a href=/catalog class=btn>В каталог</a>";
} elseif (empty($_POST)) {
$isProdExists = \App\DB\Products::get($id, $connection);
if (v::arr()->notEmpty()->validate($isProdExists)) {
include_once $src_path . "templates/_edit-form.php";
} else {
echo "Такого товара нет в базе данных<br>";
echo "<a href=/catalog class=btn style='margin-top: 10px;'>В каталог</a>";
}
} elseif (!empty($_POST)) {
include_once "/product_data-validate.php";
// Data Validation
$errors = [];
$title = titleValidate($errors, $_POST['title']);
$description = descriptionValidate($errors, $_POST['description']);
$price = priceValidate($errors, $_POST['price']);
if ($_FILES['userfile']['error'] != 4) {
$userfile = fileValidate($errors, $_FILES['userfile']['name']);
