query($sqlp); $mydarap= $myqueryp->fetchAll() ; $rows_foundp = $myqueryp->rowCount(); foreach($mydarap as $row){ $short_title=$row['short_title']; $description=$row['description']; $keyword=$row['keyword']; } ?>
'; }else{ echo 'ad'; } ?>

Filter

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 = ' '; }else{ $companylogo = ' '.$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 '
    '.$companylogo.'

    '.$short_title.'

    '.$description.'

    Get Code
    Active Offer
      '.$trendings.' '.$fav.' '. $like.'
    • Share
    •   Verified 1 day ago
    •   Expires on '.$exp_date.'
    •   '.$people_used.' People Used Today
    '; } ?>
      query($sqlpa); $row = $myquerypa->fetch(PDO::FETCH_BOTH); // do loop stuff $rows_foundpa = $myquerypa->rowCount(); $total_records = $row[0]; //echo $rows_foundpa; if($total_records > 14){ $total_pages = ceil($total_records / $limit); $k = (($pn+1>$total_pages)?$total_pages-1:(($pn-1<1)?2:$pn)); $pagLink = ""; if($pn>=2){ echo "
    • <<
    • "; echo "
    • <
    • "; } for ($i=-1; $i<=1; $i++) { if($total_pages>=$k+$i && $k+$i!='0' ){ if($k+$i==$pn){ $pagLink .= "
    • ".($k+$i)."
    • "; } else{ $pagLink .= "
    • ".($k+$i)."
    • "; } } }; echo $pagLink; if($pn<$total_pages){ echo "
    • >
    • "; echo "
    • >>
    • "; } } ?>

    Subscribe