</div>
</section><br><br>
<!--<div class="container">
<div class="row">
<div class="col-md-12">
<div class="row"><?php
//require_once 'includes/breadcrumbs.php';
?>
</div>
</div>
</div>
</div> -->
<div class="container">
<?php
if (isset($_GET['ArtTitle'])) {
$ArtTitle = remove_underscore_to_str(mysql_real_escape_string(htmlentities($_GET['ArtTitle'])));
if (!empty($ArtTitle)) {
require_once 'current_project_single.php';
}
} else {
require_once 'current_project_all.php';
}
?>
</div><!--end contant_area-->
<?php
require_once 'includes/all_footer.php';
?>
$SubCatName = remove_underscore_to_str(mysql_real_escape_string(htmlentities($_GET['SubCatName'])));
} elseif (!empty($_COOKIE['_scn'])) {
$SubCatName = remove_underscore_to_str(mysql_real_escape_string(htmlentities($_COOKIE['_scn'])));
}
$query_item = $con->prepare("SELECT i.item_id, i.i_code, i.i_name, i.i_available, i.i_price, i.i_details, i.adate, ib.brand_name, iut.i_user_type, ic.i_cat_name, isc.sub_category\r\n\t\t\t\t\t\tFROM item_mst AS i\r\n\t\t\t\t\t\tINNER JOIN j_item_sub_cat AS jisc ON jisc.item_id = i.item_id\r\n\t\t\t\t\t\tINNER JOIN item_sub_category AS isc ON isc.i_sub_cat_id = jisc.i_sub_cat_id\r\n\t\t\t\t\t\tINNER JOIN item_category AS ic ON ic.i_cat_id = isc.i_cat_id\r\n\t\t\t\t\t\tLEFT JOIN item_brand AS ib ON ib.brand_id = i.brand_id\r\n\t\t\t\t\t\tLEFT JOIN item_user_type AS iut ON iut.i_user_type_id = i.i_user_type_id\r\n\t\t\t\t\t\tWHERE isc.sub_category=:sub_category AND i_available=:i_available\t\t\t\t\t\r\n\t\t\t\t\t\tORDER BY i.adate DESC\r\n\t\t\t\t\t\tLIMIT {$start_from}, {$rows_per_page}");
$query_item->execute(array(':sub_category' => $SubCatName, ':i_available' => 1));
// how many rows we have in database
$query_count = $con->prepare("SELECT COUNT(i.item_id), isc.sub_category \r\n\t\t\t\t\t\tFROM item_mst AS i\r\n\t\t\t\t\t\tINNER JOIN j_item_sub_cat AS jisc ON jisc.item_id = i.item_id\r\n\t\t\t\t\t\tINNER JOIN item_sub_category AS isc ON isc.i_sub_cat_id = jisc.i_sub_cat_id\r\n\t\t\t\t\t\tWHERE isc.sub_category=:sub_category AND i_available=:i_available");
$query_count->execute(array(':sub_category' => $SubCatName, ':i_available' => 1));
$query_count = $query_count->fetch(PDO::FETCH_NUM);
$number_row = $query_count[0];
} elseif (isset($_GET['CatName']) or isset($_COOKIE['_cn'])) {
if (!empty($_GET['CatName'])) {
$CatName = remove_underscore_to_str(mysql_real_escape_string(htmlentities($_GET['CatName'])));
} elseif (!empty($_COOKIE['_cn'])) {
$CatName = remove_underscore_to_str(mysql_real_escape_string(htmlentities($_COOKIE['_cn'])));
}
//$CatName = remove_underscore_to_str(mysql_real_escape_string($_GET['CatName']) );
$query_item = $con->prepare("SELECT i.item_id, i.i_code, i.i_name, i.i_available, i.i_price, i.i_details, i.adate, ib.brand_name, iut.i_user_type, ic.i_cat_name, isc.sub_category\r\n\t\t\t\t\t\tFROM item_mst AS i\r\n\t\t\t\t\t\tINNER JOIN j_item_sub_cat AS jisc ON jisc.item_id = i.item_id\r\n\t\t\t\t\t\tINNER JOIN item_sub_category AS isc ON isc.i_sub_cat_id = jisc.i_sub_cat_id\r\n\t\t\t\t\t\tINNER JOIN item_category AS ic ON ic.i_cat_id = isc.i_cat_id\r\n\t\t\t\t\t\tLEFT JOIN item_brand AS ib ON ib.brand_id = i.brand_id\r\n\t\t\t\t\t\tLEFT JOIN item_user_type AS iut ON iut.i_user_type_id = i.i_user_type_id\r\n\t\t\t\t\t\tWHERE ic.i_cat_name=:i_cat_name\tAND i_available=:i_available\t\t\t\t\r\n\t\t\t\t\t\tORDER BY i.adate DESC\r\n\t\t\t\t\t\tLIMIT {$start_from}, {$rows_per_page}");
$query_item->execute(array(':i_cat_name' => $CatName, ':i_available' => 1));
// how many rows we have in database
$query_count = $con->prepare("SELECT COUNT(i.item_id), ic.i_cat_name \r\n\t\t\t\t\t\tFROM item_mst AS i\r\n\t\t\t\t\t\tINNER JOIN j_item_sub_cat AS jisc ON jisc.item_id = i.item_id\r\n\t\t\t\t\t\tINNER JOIN item_sub_category AS isc ON isc.i_sub_cat_id = jisc.i_sub_cat_id\r\n\t\t\t\t\t\tINNER JOIN item_category AS ic ON ic.i_cat_id = isc.i_cat_id\r\n\t\t\t\t\t\tWHERE ic.i_cat_name=:i_cat_name AND i_available=:i_available");
$query_count->execute(array(':i_cat_name' => $CatName, ':i_available' => 1));
$query_count = $query_count->fetch(PDO::FETCH_NUM);
$number_row = $query_count[0];
} else {
$query_item = $con->prepare("SELECT i.item_id, i.i_code, i.i_name, i.i_available, i.i_price, i.i_details, i.adate, ib.brand_name, iut.i_user_type, ic.i_cat_name, isc.sub_category\r\n\t\t\t\t\t\tFROM item_mst AS i\r\n\t\t\t\t\t\tINNER JOIN j_item_sub_cat AS jisc ON jisc.item_id = i.item_id\r\n\t\t\t\t\t\tINNER JOIN item_sub_category AS isc ON isc.i_sub_cat_id = jisc.i_sub_cat_id\r\n\t\t\t\t\t\tINNER JOIN item_category AS ic ON ic.i_cat_id = isc.i_cat_id\r\n\t\t\t\t\t\tLEFT JOIN item_brand AS ib ON ib.brand_id = i.brand_id\r\n\t\t\t\t\t\tLEFT JOIN item_user_type AS iut ON iut.i_user_type_id = i.i_user_type_id\r\n\t\t\t\t\t\tWHERE i_available=1\t\t\t\t\t\r\n\t\t\t\t\t\tORDER BY i.adate DESC\r\n\t\t\t\t\t\tLIMIT {$start_from}, {$rows_per_page}");
$query_item->execute();
// how many rows we have in database
$query_count = $con->prepare("SELECT COUNT(item_id) FROM item_mst WHERE i_available=1");
$query_count->execute();
?>
<div class="container">
<div class="row">
<div class="col-md-12">
<div class="row"><?php
require_once 'includes/breadcrumbs.php';
?>
</div>
</div>
</div>
</div>
<div class="container">
<?php
if (isset($_GET['AssoName'])) {
$AssoName = remove_underscore_to_str(mysql_real_escape_string(htmlentities($_GET['AssoName'])));
if (!empty($AssoName)) {
require_once 'associate_partner_single.php';
}
} else {
require_once 'associate_partner_all.php';
}
?>
</div><!--end contant_area-->
<?php
require_once 'includes/all_footer.php';
?>
<div class="col-md-3">
<div class="row" style="background:#fff; border:1px solid rgba(223, 223, 223, 1); border-radius:5px; margin-right:1px;">
<?php
require_once 'product_filter.php';
?>
</div>
</div>
<div class="col-md-9 product_view_style">
<div class="row" >
<div class="col-md-6 col-sm-6 col-xs-6">
<?php
if (isset($_COOKIE['_cn']) or isset($_COOKIE['_scn']) or isset($_COOKIE['_cn']) and isset($_COOKIE['_scn'])) {
@($CatName = ucfirst(remove_underscore_to_str(mysql_real_escape_string(htmlentities($_COOKIE['_cn'])))));
@($SubCatName = ucfirst(remove_underscore_to_str(mysql_real_escape_string(htmlentities($_COOKIE['_scn'])))));
if (!empty($CatName) && empty($SubCatName)) {
echo '<h5>' . $CatName . '</h5>';
} elseif (!empty($CatName) && !empty($SubCatName)) {
echo '<h5>' . $CatName . ' / ' . $SubCatName . '</h5>';
}
//echo '<div class="titel_head"><h5>All Product</h5></div>';
} else {
echo '<h5>All Product</h5>';
}
?>
</div><?php
//For product category name
?>
<div class="container">
<div class="row">
<div class="col-md-12">
<div class="row"><?php
require_once 'includes/breadcrumbs.php';
?>
</div>
</div>
</div>
</div>
<div class="container">
<?php
if (isset($_GET['ItemName'])) {
//$ItemName = remove_underscore_to_str(mysql_real_escape_string(htmlentities($_GET['ItemName'])));
$ItemName = remove_underscore_to_str($_GET['ItemName']);
require_once 'product_single.php';
/*
}elseif(isset($_GET['CatName'])){
$CatName = remove_underscore_to_str(mysql_real_escape_string(htmlentities($_GET['CatName'])) );
require_once 'product_category.php';
}elseif(isset($_GET['SubCatName'])){
$SubCatName = remove_underscore_to_str(mysql_real_escape_string(htmlentities($_GET['SubCatName'])) );
require_once 'product_sub_category.php';
*/
} else {
require_once 'product_all.php';
}
?>
</div><!--end container-->
