*/ $title = 'ระบบจัดการร้านค้า : สินค้า'; $db = new database(); $pagination = new Zebra_Pagination(); $sql_pd = "SELECT p.id, p.name as pname, p.price, p.brandname, p.created, c.name as cname FROM products p "; $sql_pd .= "INNER JOIN product_categories c ON p.product_categorie_id = c.id WHERE 1=1 "; $sql_pd .= isset($_GET['name']) ? "AND p.name LIKE '%{$_GET['name']}%' " : ""; $sql_pd .= isset($_GET['brandname']) ? "AND p.brandname LIKE '%{$_GET['brandname']}%' " : ""; $query_pd = $db->query($sql_pd); $rows_pd = $db->rows($query_pd); $per_page = 20; $page_start = ($pagination->get_page() - 1) * $per_page; $sql_pd .= "ORDER BY id DESC LIMIT {$page_start},{$per_page} "; $pagination->records($rows_pd); $pagination->records_per_page($per_page); $pagination->base_url('', FALSE); $query_pd_page = $db->query($sql_pd); $page = $page_start != 0 ? $page_start : "1"; $pages = ceil($rows_pd / $per_page); $uri = $_SERVER['REQUEST_URI']; // url /* * php code///////////********************************************************** */ /* * header*********************************************************************** */ /* * header*********************************************************************** */ ?>