Posts

Showing posts from February, 2018

ratiing

<?php require_once('config.php'); if($_SERVER['REQUEST_METHOD'] == "POST") { //Get the coupon parameters $user_id = mysqli_real_escape_string($conn,$_POST['user_id']); $coupon_id      = mysqli_real_escape_string($conn,$_POST['coupon_id']); $rating    = mysqli_real_escape_string($conn,$_POST['rating']); $getRating="SELECT meta_value FROM wp_postmeta WHERE post_id='$coupon_id' AND meta_key='ratings_average'"; $cpnReatingqry=$conn->query($getRating); $cpnRatingRes=$cpnReatingqry->fetch_assoc(); $couponRat=$cpnRatingRes["meta_value"]; if(!empty($couponRat)) { $prevRating=$couponRat; $currentRating=$rating; $getRatingUser="SELECT meta_value FROM wp_postmeta WHERE post_id='$coupon_id' AND meta_key='ratings_users'"; $cpnReatinguserqry=$conn->query($getRatingUser); $cpnRatinguserRes=$cpnReatinguserqry-...

Newarby cpn

<?php require_once('config.php'); if($_SERVER['REQUEST_METHOD'] == "POST") { $cur_lat       =  mysqli_real_escape_string($conn,$_POST['current_lat']); $cur_long      =  mysqli_real_escape_string($conn,$_POST['current_long']); // $distance    =  $_POST['distance']; $restaurant    =  mysqli_real_escape_string($conn,$_POST['restaurant_id']); $category      =  mysqli_real_escape_string($conn,$_POST['category_id']); $topcpn        =  mysqli_real_escape_string($conn,$_POST['top_coupons']); $newcpn        =  mysqli_real_escape_string($conn,$_POST['new_coupons']); $expiringcpn   =  mysqli_real_escape_string($conn,$_POST['expiring_coupons']); $featured_cpn  =  mysqli_real_escape_string($conn,$_POST['featured_coupons']); $user_id      ...