*/
$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***********************************************************************
*/
?>
