public function prepare($db)
{
$this->paging = Paging::getFromUrl();
$this->paging->limit = $this->page_size;
Paging::$max_pages_links = $this->max_pages_links;
$this->search = isset($_GET['s']) ? $_GET['s'] : '';
// add filtering logic here
$this->data = ModelBase::select($db, $this->name, $this->where, $this->bindings, $this->types, $this->paging, $this->orderby);
}
<?php
require_once $home_dir . 'classes/paging.php';
require_once $home_dir . 'models/product.m.php';
global $db, $data;
$page_title = t('Search Results');
$search = _g('search');
$paging = Paging::getFromUrl();
if (isset($search)) {
$search_results = Product::select($db, 'viewProducts', 'product_name LIKE ?', ['%' . $search . '%'], 's', $paging, 'product_name');
$data['search_results'] = $search_results;
}
$data['paging'] = $paging;
<?php
global $home_dir, $db, $data;
require_once $home_dir . 'classes/paging.php';
require_once $home_dir . 'models/category.m.php';
require_once $home_dir . 'models/product.m.php';
$categories_tree = Category::getCategoryTree($db);
$category = $categories_tree->findInChildren(intval($path[1]));
if (!isset($category)) {
redirect('notfound');
}
$data['category'] = $category;
$page_title = $category->val('category_name');
$paging = Paging::getFromUrl(Product::getSortingItems());
$ids = $category->getSubTreeIDs();
$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, $paging->getOrderBy());
$data['products'] = $products;
$data['paging'] = $paging;
$data['ids'] = $ids;
