Edit file File name : search_product.php Content :<?php session_start(); include("../include/config.php"); include("../include/functions.php"); include("../include/simpleimage.php"); validate_admin(); if(!empty($_POST["keyword"])) { // $search_id =$_POST['search_id']; $storeWhare = ""; $storesearcharr = array(); // $zipstore = $obj->query("select stores.storeid from tbl_store_zip left join stores on tbl_store_zip.storeid=stores.storeid where stores.sectionid like '%1%' // and tbl_store_zip.zone_status=1 and tbl_store_zip=.store_status=1 and tbl_store_zip.status=1 and stores.status=1"); // // echo $zipstore; // $record = $obj->numRows($zipstore); // if ($record > 0) { // while ($storeresult = $obj->fetchNextObject($zipstore)) { // array_push($storesearcharr, $storeresult->storeid); // }//while loop // $storesearcharr = implode(',', $storesearcharr); // $storeWhare = "and tbl_product.storeid in ($storesearcharr) "; // }//$r // $query = $obj->query("SELECT * FROM $tbl_product WHERE product_name like // '" . $_POST["keyword"] . "%' AND status = '1' $storeWhare ORDER BY product_name LIMIT 0,10"); $query = $obj->query("select storeid,product_name,product_id,photo,in_stock,tbl_productprice.id, mrp_price,sell_price,size,size_type from tbl_product join tbl_productprice on tbl_product.id=tbl_productprice.product_id where tbl_product.status=1 and tbl_productprice.status=1 and product_name like '%" . $_POST["keyword"] . "%' group BY product_name LIMIT 0,15"); ?> <input type="button" class="saveBtn" value="Save Selected values"/> <?php while ($country = $obj->fetchNextObject($query)) { ?> <input type="checkbox" name="multi[]" id="multi" class="multiSelect" value="<?php echo $country->product_id;?>" data-name="<?php echo $country->product_name ; ?>"> <?php echo $country->product_name ; ?> <br/> <?php }} ?> Save