function ifCatExists(\App\DB\Connection $connection, $catName) { $catArray = \App\DB\Categories::getAll($connection); $flag = false; foreach ($catArray as $cat) { if ($cat['title'] == $catName) { $flag = true; break; } } return $flag; }
if (!$flag) { echo "<h2>Такой категории не существует"; } else { include_once 'templates/_edit_category.php'; } } else { $errors = []; $catName = catNameValidate($errors, $_POST['category']); if (!v::arr()->notEmpty()->validate($errors)) { // Check if this category already exists $flag = ifCatExists($connection, $catName); if ($flag) { include_once "templates/_edit_category.php"; echo "<p>Такая категория уже существует</p>"; } else { $newCategory = \App\DB\Categories::update($id, $catName, $connection); header('Refresh: 0; url=/edit-cat-all'); } } else { include_once "templates/_edit_category.php"; include_once "templates/_form-errors.php"; } } ?> </div> </div> </div> </div> </div> </section> <?php
<?php require_once __DIR__ . '/../vendor/autoload.php'; $src_path = __DIR__ . '/../src/'; include_once $src_path . 'autoload.php'; session_start(); $connection = new \App\DB\Connection('root', ''); $urler = new \App\Utilities\Url(); $view = $urler->getPage(); $categories = \App\DB\Categories::getAll($connection); switch ($view) { case 'main': include_once $src_path . 'main.php'; break; case 'company': include_once $src_path . 'company.php'; break; case 'contacts': include_once $src_path . 'contacts.php'; break; case 'exit': if (isset($_SESSION['user_id'])) { include_once $src_path . 'exit.php'; } else { echo "<h1>404 Not Found</h1>"; } break; case 'edit': if (isset($_SESSION['user_id'])) { include_once $src_path . 'edit.php'; } else {
<?php include_once __DIR__ . '/templates/_header.php'; include_once __DIR__ . '/templates/_top_menu.php'; if (!empty($_GET['id']) && is_numeric($_GET['id'])) { $id = $_GET['id']; $product = \App\DB\Products::get($id, $connection); if (!$product) { die("Такой утки не обнаружено"); } //получаем текущую категорию по id товара $category_by_prod = \App\DB\Categories::get($product['id_cat'], $connection); include_once __DIR__ . '/templates/_single_item.php'; include_once __DIR__ . '/templates/_footer.php'; } else { die("Такой утки не обнаружено"); }
<?php $flag = false; $products = []; if (isset($_GET['id']) && is_numeric($_GET['id'])) { $id = $_GET['id']; $category = \App\DB\Categories::get($id, $connection); if (!$category) { $flag = true; $category['title'] = "Неизвестная категория"; } if (!$flag) { $products = \App\DB\Products::getByCategory($category['id'], $connection); } } else { $flag = true; $category['title'] = "Неизвестная категория"; } include_once __DIR__ . '/templates/_header.php'; include_once __DIR__ . '/templates/_top_menu.php'; ?> <section> <div class="container"> <div class="row clearfix"> <!-- боковое меню --> <?php include_once 'templates/_menu.php'; ?> <div class="column column9"> <div class="catalog"> <!-- хлебные крошки -->
<?php if (isset($_GET['id'])) { $id = $_GET["id"]; } include_once $src_path . 'autoload.php'; $getCatId = \App\DB\Categories::get($id, $connection); ?> <form action="<?php echo App\Utilities\Options::URL; ?> /edit-cat/?id=<?php echo $getCatId['id']; ?> " method="post"> <p style="margin-bottom:5px;">Введите название категории:</p> <input style="width: 50%;margin-bottom:5px;" type="text" name="category" value="<?php echo $getCatId['title']; ?> " required> <input type="submit" value="Отправить"> </form> <?php if (!empty($getCatId['updated_at']) && $getCatId['updated_at'] != "0000-00-00 00:00:00") { echo "<p style='margin-bottom: 5px, margin-top: 10px;'>Название категории изменено: " . $getCatId['updated_at'] . "</p>"; }
<?php use Respect\Validation\Validator as v; $category = \App\DB\Categories::get($products[$i]['category_id'], $connection); ?> <table class="table-products"> <tbody> <tr> <td><?php echo $products[$i]['id']; ?> </td> <td><?php echo $products[$i]['title']; ?> </td> <td><?php if (v::arr()->notEmpty()->validate($category)) { echo $category['title']; } else { echo "Не указана"; } ?> </td> <td><a href="<?php echo \App\Utilities\Options::URL; ?> /edit/?id=<?php echo $products[$i]['id']; ?> " class='edit adm-btn'>Изменить</a></td>
<div class="row clearfix"> <?php use Respect\Validation\Validator as v; include_once $src_path . 'autoload.php'; $connection = new \App\DB\Connection('root', ''); if (isset($_GET['id'])) { $id = $_GET['id']; } else { $id = 'error'; } $category = \App\DB\Categories::get($id, $connection); $flag = v::arr()->notEmpty()->validate($category); if (!$flag) { echo "Такой категории не существует"; } else { $deleteCategory = \App\DB\Categories::deleteCategory($id, $connection); if ($deleteCategory) { $deleteCategoryId = \App\DB\Products::deleteCategoryId($id, $connection); } // Back to previous page header('Location: ' . \App\Utilities\Options::URL . '/edit-cat-all'); } ?> </div> </div> </div> </div> </div> </section> <?php include_once __DIR__ . '/templates/_footer.php';