Filter

query($sqlcou); $mydaracou= $myquerycou->fetchAll() ; $rows_foundcou = $myquerycou->rowCount(); 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']; $exp_date = $rowcou['exp_date']; $from_site = $rowcou['from_site']; $coupan_country_name = $rowcou['coupan_country_name']; echo '
Gearbest Coupons Of The Day
'.$short_title.'

'.$description.'

'.$coupon_code.'
Active Offer
  • Tranding
  •  100
  •  10
  • Share
  •   Verified 1 day ago
  •   Expires on '.$exp_date.'
  •   21 People Used Today
'; } ?>
    query($sqlpa); $row = $myquerypa->fetch(PDO::FETCH_BOTH); // do loop stuff $rows_foundpa = $myquerypa->rowCount(); $total_records = $row[0]; $total_pages = ceil($total_records / $limit); $k = (($pn+2>$total_pages)?$total_pages-2:(($pn-2<1)?3:$pn)); $pagLink = ""; if($pn>=2){ echo "
  • <<
    • "; echo "
  • <
    • "; } for ($i=-2; $i<=2; $i++) { if($k+$i==$pn){ $pagLink .= "
  • ".($k+$i)."
    • "; } else{ $pagLink .= "
  • ".($k+$i)."
    • "; } }; echo $pagLink; if($pn<$total_pages){ echo "
  • >
    • "; echo "
  • >>
    • "; } ?>

Subscribe