%PDF- %GIF98; %PNG;
Server : ApacheSystem : Linux sh00666.bluehost.com 5.14.0-687.26.1.el9_8.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Jul 14 16:32:02 EDT 2026 x86_64 User : ndkhermy ( 1200) PHP Version : 8.5.12 Disable Function : NONE Directory : /home1/ndkhermy/www/website_93b53270/ |
Upload File : |
<?php
include 'function.php';
$coupon_code = $_POST['coupon_code'];
$validityDate = date('Y-m-d');
$ChkQry = mysqli_query($conn, "SELECT * FROM `coupon_tbl` WHERE `coupon` = '$coupon_code' AND `expiry_date` >= '$validityDate' AND `quantity` > '0' AND status=1") or die(mysqli_error($conn));
if (mysqli_num_rows($ChkQry) > 0) {
$coupon_data = mysqli_fetch_assoc($ChkQry);
$coupon_id = $coupon_data['id'];
$ChkQry_user = mysqli_query($conn, "SELECT * FROM `user_tbl` WHERE FIND_IN_SET('$coupon_id', `coupon`) AND id='".$_SESSION['user_id']."'") or die(mysqli_error($conn));
if (mysqli_num_rows($ChkQry_user) > 0) {
$_SESSION['discount'] = $coupon_data['discount'];
$_SESSION['coupon'] = $coupon_data['coupon'];
echo json_encode(array('status'=>'success', 'message'=>'Successfully applied the coupon.'));
}else{
echo json_encode(array('status'=>'error', 'message'=>'The coupon is invalid. Please verify and try again.'));
}
} else {
echo json_encode(array('status'=>'error', 'message'=>'The coupon is invalid or has expired.'));
}
?>