
-
$pro=mysqli_query($link,"SELECT * FROM arf_product_kategori where status='yes'");
while ($cpro=mysqli_fetch_array($pro)){
?>
- echo $cpro[nama_kategori]?> } ?>
$id= $_GET['id'];
$pro2=mysqli_query($link,"SELECT * FROM arf_product_kategori where status='yes' and id='$id'");
$nmpro=mysqli_fetch_array($pro2);?>
echo $nmpro[nama_kategori];?>
$p=mysqli_query($link,"SELECT * FROM arf_product where kategori='$nmpro[nama_kategori]'");
?>
if ($_GET[id]==''){
if (isset($_GET['order']))
{
$order = $_GET['order'];
}
else
{
$order = 'id';
}
if (isset($_GET['sort']))
{
$sort = $_GET['sort'];
}
else
{
$sort= 'DESC';
}
if (isset($_GET['page']))
{
$page = $_GET['page'];
}
else
{
$page = 1;
}
//mencari data sesuai dengan kata kunci
$query = "SELECT * FROM arf_product where publish='yes' ORDER BY $order $sort";
$tmp = mysqli_query($link,$query);
$pagesize = 12;
$startrow = ($page - 1) * $pagesize;
$count = mysqli_num_rows($tmp);
$pagecount = ceil($count/$pagesize);
$query2 = $query . " limit $startrow , $pagesize";
$sql = mysqli_query($link,$query2);
while($hasil=mysqli_fetch_array($sql))
{ ?>
} ?>
$file="products.php"; include 'paging.php'; ?>
} else {
if (isset($_GET['order']))
{
$order = $_GET['order'];
}
else
{
$order = 'id';
}
if (isset($_GET['sort']))
{
$sort = $_GET['sort'];
}
else
{
$sort= 'DESC';
}
if (isset($_GET['page']))
{
$page = $_GET['page'];
}
else
{
$page = 1;
}
//mencari data sesuai dengan kata kunci
$query = "SELECT * FROM arf_product where kategori='$nmpro[nama_kategori]' and publish='yes' ORDER BY $order $sort";
$tmp = mysqli_query($link,$query);
$pagesize = 12;
$startrow = ($page - 1) * $pagesize;
$count = mysqli_num_rows($tmp);
$pagecount = ceil($count/$pagesize);
$query2 = $query . " limit $startrow , $pagesize";
$sql = mysqli_query($link,$query2);
while($hasil=mysqli_fetch_array($sql))
{ ?>
} ?>
$file="products.php?id=$_GET[id]"; include 'paging.php'; ?>
} ?>