})->bind('b_catalog'); $silex_app->get('/catalog/{page}', function ($page) use($silex_app, $products, $categories, $images) { //пагинация $pagination = new Pagination($products, 9, $page); $products_on_page = $pagination->getProductsOnPage(); $pages_info = $pagination->getPagesInfo(); return $silex_app['twig']->render('catalog/main.twig', ['twig_products' => $products_on_page, 'twig_categories' => $categories, 'twig_images' => $images, 'twig_pages_info' => $pages_info]); }); $silex_app->get('/catalog/category/{cat_slug}/{page}', function ($cat_slug, $page) use($silex_app, $categories, $images) { $sql = "SELECT `id` FROM `categories` WHERE `slug` = :cat_slug"; $cat_id = $silex_app['db']->fetchAssoc($sql, ['cat_slug' => $cat_slug])['id']; $sql = "SELECT * FROM `products` WHERE `category_id` = :cat_id"; $products = $silex_app['db']->fetchAll($sql, ['cat_id' => $cat_id]); //пагинация $pagination = new Pagination($products, 9, $page, $cat_id); $products_on_page = $pagination->getProductsOnPage(); $pages_info = $pagination->getPagesInfo(); return $silex_app['twig']->render('catalog/category.twig', ['twig_products' => $products_on_page, 'twig_categories' => $categories, 'twig_images' => $images, 'twig_pages_info' => $pages_info]); })->bind('b_category'); $silex_app->get('/catalog/product/{product_id}', function ($product_id) use($silex_app, $categories, $images) { $sql = "SELECT * FROM `products` WHERE `id` = :product_id"; $product = $silex_app['db']->fetchAssoc($sql, ['product_id' => $product_id]); $sql = "SELECT * FROM `images` WHERE `product_id` = :product_id"; $product_images = $silex_app['db']->fetchAll($sql, ['product_id' => $product_id]); return $silex_app['twig']->render('product/main.twig', ['twig_product' => $product, 'twig_product_images' => $product_images, 'twig_categories' => $categories]); })->bind('b_product'); //админочка //авторизация $silex_app->get('/admin', function () use($silex_app) { $login = $silex_app['request']->server->get('PHP_AUTH_USER', false); $password = $silex_app['request']->server->get('PHP_AUTH_PW');