pageLimit = 50; $link = ''; if (!empty($filter_keyword)) { $link .= '&query='.$filter_keyword; $sql = "(`title` LIKE '%$filter_keyword%' OR `desc` LIKE '%$filter_keyword%')"; $db->where($sql); } $sort_link = $link; $sort_array = array('DESC_i' => array('id' , 'DESC'), 'ASC_i' => array('id' , 'ASC')); if (!empty($_GET['sort']) && in_array($_GET['sort'], array_keys($sort_array))) { $link .= "&sort=".Secure($_GET['sort']); $db->orderBy($sort_array[$_GET['sort']][0],$sort_array[$_GET['sort']][1]); } else{ $_GET['sort'] = 'DESC_i'; $db->orderBy('id', 'DESC'); } $posts = $db->objectbuilder()->paginate(T_PRODUCTS, $page); if (($page > $db->totalPages) && !empty($_GET['page-id'])) { header("Location: " . LoadAdminLinkSettings('manage-products')); exit(); } ?>
ID | Link | Author | Posted | Action |
---|