</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-->