芝麻web文件管理V1.00

编辑当前文件:/home/krishnamexports/public_html/search.php

<?php include("common/header.php");

if(isset($_GET['search']))

{

$categoryList    = array();

$subcategoryList = array();

$sqlCategory     = mysqli_query($cn, "select * from `tbl_category` where `name` LIKE '%".$_GET['search']."%'");

while($sqlCategoryData = mysqli_fetch_array($sqlCategory))

{

array_push($categoryList,$sqlCategoryData['id']);

}

$sqlSubCategory      = mysqli_query($cn, "select * from `tbl_category` where `name` LIKE '%".$_GET['search']."%'");

while($sqlSubCategoryData = mysqli_fetch_array($sqlSubCategory))

{

array_push($subcategoryList,$sqlSubCategoryData['id']);

}

$qry = "";

$categoryListData    = implode(',',$categoryList);

if(!empty($categoryListData))

{

$qry = " or `category_id` IN($categoryListData) ";

}

$subcategoryListData = implode(',',$subcategoryList);

if(!empty($subcategoryListData))

{

$qry .= " or `subcategory_id` IN($subcategoryListData) ";

}

$sqlProduct  = mysqli_query($cn, "select * from `tbl_product` where (`name` LIKE '%".$_GET['search']."%' or `skucode` LIKE '".$_GET['search']."%' $qry ) and `status`=1");

$count       = mysqli_num_rows($sqlProduct);

}

<main>

<h5 class="sidebar-title">categories</h5>

<?php

$sqlCategory           = mysqli_query($cn,"select * from `tbl_category` where `status`=1 order by `sort_order`");

while($sqlCategoryData = mysqli_fetch_array($sqlCategory))

{

$sqlsubCategory    = mysqli_query($cn,"select * from `tbl_subcategory` where `category_id`='".$sqlCategoryData['id']."' and `status`=1 order by `sort_order`");

if(mysqli_num_rows($sqlsubCategory)>0){?>

<?php

while($sqlsubCategoryData = mysqli_fetch_array($sqlsubCategory)){?>

<?php }?>

</ul>

</li>

<?php

}else{?>

<?php }

}?>

</ul>

</div>

<!--<div class="sidebar-single">

<h5 class="sidebar-title">price</h5>

<label for="amount">Price: </label>

</div>

<button class="filter-btn">filter</button>

</form>

</div>

</div>-->

</aside>

</div>

<p>Showing 1 – <span id="count"><?php echo $count;?></span> of <?php echo $count;?> Designs</p>

</div>

<?php

while($sqlProductData = mysqli_fetch_array($sqlProduct))

{

$ProductImg = explode("$",$sqlProductData['image']);

<?php

if(count($ProductImg)>1)

{?>

<img class="pri-img" src="<?php echo DEFAULT_URL."products/".$ProductImg[0];?>" alt="product">

<img class="sec-img" src="<?php echo DEFAULT_URL."products/".$ProductImg[1];?>" alt="product">

<?php }else{?>

<img class="pri-img" src="<?php echo DEFAULT_URL."products/".$ProductImg[0];?>" alt="product">

<img class="sec-img" src="<?php echo DEFAULT_URL."products/".$ProductImg[0];?>" alt="product">

<?php }?>

</a>

<!--<div class="product-badge">

</div>

</div> -->

</figure>

</h6>

<!--<div class="price-box">

</div>-->

</div>

<?php }?>

</div>

</div>

</main>

<?php include("popup/loginsignup.php");?>

<?php include("common/footer.php");?>

<?php include("popup/mini-cart.php");?>

$(document).ready(function(){

$("#signup").click(function(){

$(".log-in").css("display", "none");

$(".sign-up").css("display", "block");

});

$(document).ready(function(){

$("#login").click(function(){

$(".log-in").css("display", "block");

$(".sign-up").css("display", "none");

});

</script>

</body>

</html>