PHP App\DB Categories 예제들

예제 #1

파일: category_validate.php 프로젝트: AndrewDubovtsev/ducks-store

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;
}

예제 #2

파일: edit-cat.php 프로젝트: AndrewDubovtsev/ducks-store

    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 

예제 #3

파일: index.php 프로젝트: AndrewDubovtsev/ducks-store

<?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 {

예제 #4

파일: single-item.php 프로젝트: belkabrief/duck-store-ver2

<?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("Такой утки не обнаружено");
}

예제 #5

파일: category.php 프로젝트: AndrewDubovtsev/ducks-store

<?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">
                        <!-- хлебные крошки -->

예제 #6

파일: _edit_category.php 프로젝트: AndrewDubovtsev/ducks-store

<?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>";
}

예제 #7

파일: _shop_element_admin.php 프로젝트: AndrewDubovtsev/ducks-store

<?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>

예제 #8

파일: delete-cat.php 프로젝트: AndrewDubovtsev/ducks-store

                        <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';