bnmbnmbnmnbmbio;io;irererereeo;o;oi;;oi;oioi;oi;oio;;oovn

hjkhhjhjol;io;ioio;ioiio;ioreererereio;;iooi;i;o;oii;o;ioo;iio;oi; bnmbnmbnmnbmbio;io;irererereeo;o;oi;;oi;oioi;oi;oio;;oovn

<?php
include("include/config.php");

date_default_timezone_set('Asia/Kolkata');
$date = date('Y-m-d');
$code = $_POST['code'];
$amount = round($_POST['amount']);

$sql1 = "SELECT * FROM bookings WHERE coupon='$code'";
$total=$db->query($sql1);
$count = $total->num_rows;

$q = "SELECT * FROM coupons WHERE code='$code' AND start_date<='$date' AND end_date>='$date'";
	$res=$db->query($q);
	if ($res->num_rows > 0) {
	while($rows = $res->fetch_assoc()) {

$max_discount = $rows['max_discount'];
		}
	}else{
		echo 0;
		exit();
	}

$q = "SELECT * FROM coupons WHERE code='$code' AND start_date<='$date' AND end_date>='$date' AND max_discount<='$amount'";
	$result=$db->query($q);
	if ($result->num_rows > 0) {
	$sql = "SELECT * FROM coupons WHERE code='$code' AND start_date<='$date' AND end_date>='$date' AND max_discount<='$amount' AND percustomer>$count";
	$result=$db->query($sql);
	if ($result->num_rows > 0) {

while($row = $result->fetch_assoc()) {

echo $row['coupon_discount'];

} 
	}else {
		echo 0;
	}
	}else {
		echo json_encode(array(
  "max_discount"=>$max_discount,
  "status"=>1
 ));
	}