Edit file File name : ajaxp-search.php Content :<?php include("../include/config.php"); include("../include/functions.php"); $q=mysqli_real_escape_string($GLOBALS['conn'],$_REQUEST['q']); ?> <link href="css/style.css" rel="stylesheet" type="text/css"> <?php $prodArr=$obj->query("select $tbl_product.*,$tbl_brand.brand,sell_price,product_id,size,pphoto,$tbl_productprice.id as ppid from $tbl_product left join $tbl_brand on $tbl_brand.id= $tbl_product.brand_id join $tbl_productprice on $tbl_productprice.product_id= $tbl_product.id where $tbl_product.status=1 and $tbl_productprice.status=1 and (product_name like '%".$q."%' or brand like '%".$q."%' or size like '%".$q."%' ) order by id desc limit 0,20",$debug=-1); $number_of_rec=$obj->numRows($prodArr); ?> <div id="serach_product"> <div class="search"> <div class="product-search"> <h4> <?php if( $number_of_rec==0){?> No Results found for "<?php echo $q; ?>\". <?php }else{ echo $number_of_rec." records found for '".$q."' " ;}?> </h4> <div class="scrollbar1" id="style-1"> <div class="force-overflow"> <div class="product-list"> <ul> <?php while($resultProduct=$obj->fetchNextObject($prodArr)){?> <li> <a class="uiv2-img-product-search" href="<?php echo SITE_URL;?>pd/<?php echo $resultProduct->product_id; ?>/<?php echo buildURL($resultProduct->product_name); ?>" target="_blank"><?php if(is_file("../upload_images/product/thumb/".$resultProduct->pphoto)){ ?><img width="30" height="30" alt="" id="imgsearch_<?php echo $resultProduct->ppid; ?>" src="../upload_images/product/thumb/<?php echo $resultProduct->pphoto; ?>"><?php }else{ ?> <img id="imgsearch_<?php echo $resultProduct->ppid; ?>" src="images/no-image.jpg" width="30" height="30" alt=""> <?php } ?> </a> <a class="uiv2-img-product-name" href="<?php echo SITE_URL;?>pd/<?php echo $resultProduct->product_id; ?>/<?php echo buildURL($resultProduct->product_name); ?>"><?php echo getProductListingName($resultProduct->product_name); ?></a> <div class="uiv2-product-weight"><span><?php echo stripslashes($resultProduct->size); ?></span></div><div class="uiv2-product-cost"><span><span class="WebRupee">Rs.</span> <?php echo number_format($resultProduct->sell_price,2); ?></span></div><div class="uiv2-rate-count-btn uiv2-search-qty-widget"><span class="uiv2-qty-label">Qty</span> <input type="text" maxlength="" id="qtysearch_<?php echo $resultProduct->ppid;?>" readonly="readonly" value="1" /></div><div class="uiv2-product-add-btn"> <input type="hidden" maxlength="" id="searchprodname_<?php echo $resultProduct->ppid;?>" value="<?php echo $resultProduct->product_name; ?> <?php echo stripslashes($resultProduct->size); ?>" /></div><div class="uiv2-product-add-btn"> <input type="button" id="" onClick="return addToCartSearch(<?php echo $resultProduct->product_id;?>,<?php echo $resultProduct->ppid;?>);" value="ADD" class="uiv2-a2c-autosearch"> </div></li> <?php } ?> </ul> </div> </div> </div> </div> </div> </div> Save