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
';
}
?>
';
}
?>
