false, 'message'=>'Invalid coupon']; if($code && $total > 0){ $stmt = $pdo->prepare("SELECT * FROM coupons WHERE code=? AND status=1 LIMIT 1"); $stmt->execute([$code]); $coupon = $stmt->fetch(PDO::FETCH_ASSOC); if($coupon){ if($coupon['discount_type'] == 'percent'){ $discount = ($total * $coupon['discount_value']) / 100; } else { $discount = $coupon['discount_value']; } if($discount > $total) $discount = $total; $response = [ 'success' => true, 'discount' => round($discount, 2), 'coupon' => [ 'code' => $coupon['code'], 'type' => $coupon['discount_type'], 'value'=> $coupon['discount_value'] ] ]; } else { $response['message'] = 'Coupon not valid or expired'; } } echo json_encode($response);