Example #1
0
<?php

global $home_dir, $db;
require_once $home_dir . 'models/product.m.php';
$paging = new Paging(_gi('offset'), _gi('limit'));
$sorting = _g('sorting', 'sortby_Alphabet');
$orderby = Product::getSorting($sorting);
$ids = explode(',', _g('category_ids'));
$values = [];
$types = '';
foreach ($ids as $id) {
    $values[] = '?';
    $types .= 'i';
}
$products = Product::select($db, 'viewProducts', sprintf('product_category_id IN (%s)', implode(',', $values)), $ids, $types, $paging, $orderby);
$data['products'] = $products;