include('header.php'); $namaPage = 'product.php'; $namaTableDatabase = 'class'; $namaTableDatabase1 = 'category'; $namaTableDatabase2 = 'brand'; $namaTableDatabase3 = 'product'; $namaTableDatabase4 = 'imageproduct'; $currentRowNumber = 1; $search = pb_escape($_REQUEST[search]); $page = $_GET[page]; if($page == '' || $page == 0 || $page == NULL) $page = 1; $productPerPage = 8; /* Start Filter */ if($_GET['id']!=''){ $src = " AND a.category_id='".pb_escape($_GET[id])."'"; } if($_GET['search']!=''){ $src.= " AND (c.category_name LIKE '%".pb_escape($_GET[search])."%' OR b.brand_name LIKE '%".pb_escape($_GET[search])."%' OR a.product_name LIKE '%".$_GET[search]."%' )"; } /* End Filter */ $mainQueryString1 = "SELECT a.*, c.category_name, b.brand_name, d.imageproduct_name FROM $namaTableDatabase3 a LEFT JOIN $namaTableDatabase1 c on a.category_id = c.category_id LEFT JOIN $namaTableDatabase2 b on a.brand_id = b.brand_id LEFT JOIN $namaTableDatabase4 d on a.product_id = d.product_id WHERE ".$namaTableDatabase3."_enabled='e' AND ".$namaTableDatabase4."_default='1' $src GROUP BY a.product_id "; //For Page System $result = pb_query($mainQueryString1); @ $productListNumTotal = mysqli_num_rows($result); $index = ($page-1)*$productPerPage; $mainQueryString1.=" LIMIT $index,$productPerPage"; ?>