include("includefiles/sidebar_filter.php"); ?>
$search_key =$_REQUEST['search_key'];
$search_cat = $_REQUEST['search_cat'];
$search_type =$_REQUEST['search_type'];
$search_dis =$_REQUEST['search_dis'];
$search_brand=$_REQUEST['search_brand'];
$search_user =$_REQUEST['search_user'];
$coupon_country_name =$_REQUEST['coupon_country_name'];
$limit = 14;
if (isset($_GET["page"])) {
$pn = $_GET["page"];
}
else {
$pn=1;
};
$start_from = ($pn-1) * $limit;
$sqlcou = "SELECT * FROM coupon";
if(!empty($search_key)){
$sqlcou = $sqlcou." WHERE company_name='$search_key' LIMIT $start_from, $limit";
}elseif(!empty($search_cat)){
$sqlcou = $sqlcou." WHERE category='$search_cat' LIMIT $start_from, $limit";
}
elseif(!empty($search_type)){
$sqlcou = $sqlcou." WHERE type='$search_type' LIMIT $start_from, $limit";
}
elseif(!empty($search_dis)){
$sqlcou = $sqlcou." WHERE short_title LIKE '%$search_dis%' OR full_title LIKE '%$search_dis%' LIMIT $start_from, $limit";
}
elseif(!empty($search_brand)){
$sqlcou = $sqlcou." WHERE brand_store='$search_brand' LIMIT $start_from, $limit";
}
elseif(!empty($search_user)){
$sqlcou = $sqlcou." WHERE created_by='$search_user' LIMIT $start_from, $limit";
}elseif(!empty($coupon_country_name)){
$sqlcou = $sqlcou." WHERE coupon_country_name='$coupon_country_name' LIMIT $start_from, $limit";
}
else{
$sqlcou = $sqlcou." LIMIT $start_from, $limit";
}
$myquerycou=$conn->query($sqlcou);
$mydaracou= $myquerycou->fetchAll() ;
$rows_foundcou = $myquerycou->rowCount();
if($rows_foundcou=='0'){
echo'
Coupan is not available to related search.
';
}
foreach( $mydaracou as $rowcou ){
$srno = $rowcou["srno"];
$short_title = $rowcou["short_title"];
$description = $rowcou["full_title"];
$link = $rowcou["link"];
$category = $rowcou["category"];
$type = $rowcou["type"];
$coupon_code = $rowcou["coupon_code"];
$trending = $rowcou["trending"];
$exp_date = $rowcou["exp_date"];
$from_site = $rowcou["from_site"];
$total_likes = $rowcou["total_likes"];
$total_dislikes = $rowcou["total_dislikes"];
$coupan_country_name = $rowcou["coupan_country_name"];
$company_name = $rowcou["company_name"];
$people_used=rand(1,400);
$string = preg_replace('/\s+/', '', $company_name);
$exp_date =explode(" ",$exp_date);
$exp_date = $exp_date[0];
if(empty($coupon_code)){
$coupon_code='Deals';
}
if($trending=='1'){
$trendings='
Tranding';
}
$companylogo = strtolower($string);
$remoteFile = 'https://res.cloudinary.com/icouponworld/image/upload/v1622043183/company_logo/'.$companylogo.'.jpg';
// Open file
$handle = @fopen($remoteFile, 'r');
// Check if file exists
if(!$handle){
$companylogo = '
'.$company_name.'';
}else{
$companylogo = '

';
}
if($_SESSION[ADD_TAG.'_UserId_vendor']!=''){
$user_id=$_SESSION[ADD_TAG.'_UserId_vendor'];
/*for like master vendor*/
$sqlli = "SELECT * FROM like_master WHERE coupan_id='$srno' AND user_id='$user_id' AND user_type='vendor' ";
$myqueryli=$conn->query($sqlli);
$mydarali= $myqueryli->fetchAll() ;
$rows_foundli = $myqueryli->rowCount();
if($rows_foundli=='0'){
$like='
'.$total_likes.'';
}else{
$like='
'.$total_likes.'';
}
/*for like master vendor */
/*for fav master vendor*/
$sqlfav = "SELECT * FROM fav_master WHERE coupan_id='$srno' AND user_id='$user_id' AND user_type='vendor' ";
$myqueryfav=$conn->query($sqlfav);
$mydarafav= $myqueryfav->fetchAll() ;
$rows_foundfav = $myqueryfav->rowCount();
if($rows_foundfav=='0'){
$fav='
';
}else{
$fav='
';
}
/*for fav master vendor */
}
elseif($_SESSION[ADD_TAG.'_UserId_user']!=''){
$user_id=$_SESSION[ADD_TAG.'_UserId_user'];
/*for like master user*/
$sqlli = "SELECT * FROM like_master WHERE coupan_id='$srno' AND user_id='$user_id' AND user_type='user' ";
$myqueryli=$conn->query($sqlli);
$mydarali= $myqueryli->fetchAll() ;
$rows_foundli = $myqueryli->rowCount();
if($rows_foundli=='0'){
$like='
'.$total_likes.'';
}else{
$like='
'.$total_likes.'';
}
/*for like master user*/
/*for fav master user*/
$sqlfav = "SELECT * FROM fav_master WHERE coupan_id='$srno' AND user_id='$user_id' AND user_type='user' ";
$myqueryfav=$conn->query($sqlfav);
$mydarafav= $myqueryfav->fetchAll() ;
$rows_foundfav = $myqueryfav->rowCount();
if($rows_foundfav=='0'){
$fav='
';
}else{
$fav='
';
}
/*for fav master user */
}else{
$like='
'.$total_likes.'';
$fav='
';
}
echo '
'.$trendings.'
'.$fav.'
'. $like.'
- Share
- Verified 1 day ago
- Expires on '.$exp_date.'
- '.$people_used.' People Used Today
';
}
?>