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;