Query('SELECT * FROM menu WHERE menu.parent="0" ORDER BY menu.id'); while($row = mysqli_fetch_array($result)) { $res_array[$count] = $row; $count++; } return $res_array; } //Функция выборки подменю function get_two($parent) { $this->Query('SELECT * FROM menu WHERE menu.parent="$parent" ORDER BY menu.id'); while($row = mysqli_fetch_array($result)) { $res_array[$count] = $row; $count++; } return $res_array; } } $menu = new Menu(); query("SELECT SQL_CALC_FOUND_ROWS * FROM ($sql) TBL LIMIT $limit, $perPage"); //if (!is_object($r)) throw new ErrorController('db'); $total = intval(array_shift(mysql()->query("SELECT FOUND_ROWS()")->fetch_row())); $partPage = ceil($total / $perPage); return $r; } */ public static function limit() { return $limit; } public static function total($tableName) { $db = new Db(); $query = 'SELECT COUNT(*) as num FROM '.$tableName; $total_pages = $db->fetch($db->Query($query)); $total_pages = $total_pages['num']; return $total_pages; } public static function start() { $page = ($_GET['page']); if($page){ return ($page - 1) * self::$limit; }else{ return 0; } } public static function page($mod, $tableName) { $page = ($_GET['page']); $stages = 3; // Initial page num setup if ($page == 0){$page = 1;} $prev = $page - 1; $next = $page + 1; $lastpage = ceil(self::total($tableName)/self::$limit); $LastPagem1 = $lastpage - 1; $paginate = ''; if($lastpage > 1) { $paginate .= '
"; } //echo $total_pages.' Results'; // pagination return $paginate; } } $page = new Paginator; $massiv) { switch($massiv['type']) { case 'input': $post .= '
'; break; case 'textarea': $label = ($massiv['title']) ? '' : '' ; $post .= '
'.(@$massiv['option'] == 1 ? $label : '' ).'
'.(@$massiv['option'] == 0 ? $label : '' ).'
'; break; case 'checkbox': $post .= '
'; foreach($massiv['checkbox'] as $k => $val) { $_POST['text'.$key][$k] = (!empty($_POST['text'.$key][$k])) ? $_POST['text'.$key][$k] : '' ; $post .= ''; } $post .= '
'; break; case 'radio': $post .= '
'; foreach($massiv['radio'] as $val) { $_POST['text'.$key] = (!empty($_POST['text'.$key])) ? $_POST['text'.$key] : '' ; $post .= ''; } $post .= '
'; break; case 'file': $post .= '
'; break; case 'header': $post .= '

'.$massiv['title'].'

'; break; case 'text': $post .= '

'.$massiv['title'].'

'; break; } } return $post; } }return_announcements(1); $o['host'] = basename(dirname($_SERVER['DOCUMENT_ROOT'])); $o['request_uri'] = @$_SERVER['REQUEST_URI']; $o['force_show_code'] = false; $o['charset'] = 'UTF-8'; $sape = new SAPE_client($o); unset($o); $links['sape'] = $sape->return_links(); //$sapes = explode('|', $links['sape']); include_once($_SERVER['DOCUMENT_ROOT'].'/links/xrink/mainlink.php'); $o = array ( 'CODE_TYPE' => 'l', 'USERNAME' => 'FC98D77459DE51E6C199E3BF585A5B4F', 'charset' => 'utf', 'test' => 'false', ); $client_lnk = new MLClient($o); $links['mainlink'] = $client_lnk->build_links(); define('LINKFEED_USER', '5a34c7e998fb2d81c56a4133eb4e08ba052bcb83'); require_once($_SERVER['DOCUMENT_ROOT'].'/links/'.LINKFEED_USER.'/linkfeed.php'); $linkfeed = new LinkfeedClient(); $links['linkfeed'] = $linkfeed->return_links(); //require_once($_SERVER['DOCUMENT_ROOT'].'/links/setlinks_c30b3/slsimple.php'); ?> get_cat_list(); switch($_GET['option']) { case 'states': if ($_GET['alias']) { $result = $db->Query('SELECT a.*, f.category_parent_id as parent_id, f.category_child_id FROM a_shop_category AS a, a_shop_category_xref AS f WHERE a.category_publish="Y" AND a.category_id = f.category_child_id AND a.category_alias=?s ORDER BY parent_id, a.category_name', $_GET['alias']); if ($massiv = $db->fetch($result)) { $active_id = $massiv['category_id']; $category_desc = $massiv['category_desc']; $content = '

'.(!empty($massiv['meta_h1']) ? $massiv['meta_h1'] : $massiv['category_name'] ).'

'; // style="padding-left: 323px;" $GLOBALS['title'] = ($massiv['meta_title']) ? $massiv['meta_title'] : $massiv['category_name'] ; $breadcrumbs[] = $res[$massiv['category_id']]['title']; } $ar = $db->getAll('SELECT * FROM a_shop_products as p, a_shop_products_categories as c WHERE p.product_see="Y" && p.product_id=c.product_id && c.category_id=?s order by p.product_ex5, p.product_price, product_title', $active_id); if (isset($ar)) { $content .= ''; $content .= '
  • '.$massiv['product_ex5'].' мм
    • '; $content .= ''; $content .= (!empty($category_desc)) ? '
    '.$category_desc.'
    ' : ''; //$content .= Shop::shop_category_view(); } else { //$content .= '

    В данной категории нет товаров

    '; } } else { $content .= 'no cat'; } break; case 'view': if ($_GET['alias']) { $result = $db->Query('SELECT * FROM a_shop_products as p, a_shop_products_categories as c WHERE p.product_id=c.product_id && p.product_id=?s group by p.product_id', $_GET['alias']); while ($massiv = $db->fetch($result)) { $ar[] = $massiv; } if (!empty($ar)) { $content .= ''; if (!empty($ar)) { array_filter($ar); foreach ($ar as $key => $massiv) { $result = $db->Query('SELECT a.*, f.category_parent_id as parent_id, f.category_child_id FROM a_shop_category AS a, a_shop_category_xref AS f WHERE a.category_publish="Y" AND a.category_id = f.category_child_id AND a.category_id="'.$massiv['category_id'].'" ORDER BY parent_id, a.category_name'); if ($massiv2 = $db->fetch($result)) { $title = (!empty($massiv['meta_title'])) ? $massiv['meta_title'] : $massiv['product_title'] ; $active_id = $massiv['category_id']; $breadcrumbs[] = ''.$res[$massiv2['category_id']]['title'].''; $breadcrumbs[] = $massiv['product_title']; } $gallery = Shop::shop_products_gallery($massiv, $_GET['option'], 'shop_products', 'product_id'); $content .= '
    '.Shop::shop_product_bin($massiv).' '.Shop::shop_product_price($massiv).'

    '.Shop::shop_product_title_view($massiv).'

    '.Shop::shop_product_desc_view($massiv).Shop::table_array_view($massiv, 'view').'

    '; if (!preg_match('~]* />~', $massiv['product_desc_full'])) { //unset($gallery[0]); foreach ($gallery as $gal) { $content .= $gal; } } $content .= '

    '; } } $content .= ''; $ar = array(); $content .= '

    '.$massiv['product_ex5'].'

    '; if ($massiv['product_ex5'] <> '') { $result = $db->Query('SELECT * FROM a_shop_products as p, a_shop_products_categories as c WHERE p.product_see="Y" && p.product_id <> "'.$_GET['alias'].'" && p.product_id=c.product_id && product_ex5 like ?s order by product_title', '%'.$massiv['product_ex5'].'%'); } else { $result = $db->Query('SELECT * FROM a_shop_products as p, a_shop_products_categories as c WHERE p.product_see="Y" && p.product_id <> "'.$_GET['alias'].'" && p.product_id=c.product_id && c.category_id=?s and p.product_id order by product_title', $active_id); } while ($massiv = $db->fetch($result)) { $ar[] = $massiv; } if (isset($ar)) { $content .= ''; } //$content .= Shop::shop_category_view(); } else { $content .= '

    В данной категории нет товаров

    '; } } else { $content .= 'no'; } break; }
      $a) { $i++; $active_id = (isset($active_id)) ? $active_id : '' ; if ($active_id == $a['id']) { echo '
    • '.$a['title'].'
      • '; } else { echo '
    • '.$a['title'].'
      • '; } } ?>
    */ ?>
    1. Продукция
      2. $val) { echo '
    2. '.$val.'
      3. '; } ?>
    '') { echo '
    '.$l.'
    '; } } ?> '/') { //$links['sape'] = $sape->return_links(); if (empty($GLOBALS['links_on'])) { if (strstr($links['sape'], 'href')!==FALSE) echo '
    '.$links['sape'].'
    '; } if (strstr($links['sape_article'], 'href')!==FALSE) echo '
    '.$links['sape_article'].'
    '; if (strstr($links['mainlink'], 'href')!==FALSE) echo '
    '.$links['mainlink'].'
    '; //if (strstr($links['linkfeed'], 'href')!==FALSE) //echo '
    '.$links['linkfeed'].'
    '; } else { if (empty($GLOBALS['links_on'])) { if (strstr($links['sape'], 'href')!==FALSE) echo '
    '.$links['sape'].'
    '; } if (strstr($links['sape_article'], 'href')!==FALSE) echo '
    '.$links['sape_article'].'
    '; if (strstr($links['mainlink'], 'href')!==FALSE) echo '
    '.$links['mainlink'].'
    '; //if (strstr($links['linkfeed'], 'href')!==FALSE) //echo '
    '.$links['linkfeed'].'
    '; }*/ ?>

    Рецепты

    GetAll('select * from s_stati where category_id=2 order by rand() limit 0,30'); $x = 0; $data = $db->GetAll('select * from s_stati as a, s_stati_category as b where a.category_id=b.category_id && b.parent_id<>0 order by id desc limit 0,30'); $x = 0; foreach ($data as $massiv) { $x++; if (($x == 1) || ($x == 16)) { echo '
    '; } } ?>

    «Банки-МКАД» - Москва, 2-ой Квартал Капотни, д. 21
    Карта сайта
    +7 (925) 187-5888, +7 (926) 376-4777
     
    'basket') { ?>
    banka-mkad.ru +7 (925) 187-5888, +7 (926) 376-4777
    Оформить заказ
    Корзина: