$active='';
$sqlcou="SELECT * FROM `coupon` WHERE `company_name`='flipkart' ORDER BY RAND() LIMIT 1";
$myquerycou=$conn->query($sqlcou);
$mydaracou= $myquerycou->fetchAll() ;
$rows_foundcou = $myquerycou->rowCount();
if($rows_foundcou=='0'){
$active='active';
}
if($rows_foundcou!='0'){
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"];
$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];
$companylogo = strtolower($string);
$remoteFile = 'https://design-collection-new.s3.us-east-2.amazonaws.com/'.$companylogo.'.jpg';
// Open file
$handle = @fopen($remoteFile, 'r');
// Check if file exists
if(!$handle){
$companylogo = '
'.$company_name.'';
}else{
$companylogo = '

';
}
if(empty($coupon_code)){
$coupon_code='Deals';
} ?>
} }
?>
$sqlcou_new="SELECT * FROM coupon WHERE short_title!='' and full_title!='' GROUP by company_name ORDER BY RAND() limit 10";
$myquerycou_new=$conn->query($sqlcou_new);
$mydaracou_new= $myquerycou_new->fetchAll() ;
$rows_foundcou_new = $myquerycou_new->rowCount();
if($rows_foundcou_new=='0'){
echo'
Coupan is not available to related search.
';
}
$i =0;
foreach( $mydaracou_new 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"];
$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];
$companylogo = strtolower($string);
$remoteFile = 'https://design-collection-new.s3.us-east-2.amazonaws.com/'.$companylogo.'.jpg';
// Open file
$handle = @fopen($remoteFile, 'r');
// Check if file exists
if(!$handle){
$companylogo = '
'.$company_name.'';
}else{
$companylogo = '

';
}
if(empty($coupon_code)){
$coupon_code='Deals';
} ?>
if($i==0){ ?>
include("includefiles/footer.php"); ?>