File manager - Edit - /home/autoph/public_html/api/aha/validate_PromoCode.php
Back
<?php include '../../../cfg/ahaconn.php'; $mykey = $_GET['keyID']; if($mykey =="Read6e59e008b5348b452b615a3033729daae383PromoCode"){ $userID = $_GET['userID']; $promoCode = $conn->real_escape_string($_GET['promo_code']); $dealID = $_GET['dealID']; $bookingPlate = $_GET['bookingPlate']; $pCar ="SELECT * FROM aha_promo_code where promo_code ='$promoCode' AND `enabled` = 1 AND `aha_owner_id`='$userID' AND `used_code`='NO' AND `expiry_date` > '$myTimeStamp' "; $resultP = $conn->query($pCar); if ($resultP->num_rows > 0) { while($rowC = $resultP->fetch_assoc()) { $pbrandID = $rowC['brand_id']; $pmodelID = $rowC['model_id']; $pdealID = $rowC['dealer_id']; } } $sCar ="SELECT * FROM vehicles where plate_no ='$bookingPlate'"; $resultC = $conn->query($sCar); if ($resultC->num_rows > 0) { while($rowC = $resultC->fetch_assoc()) { $brandID = $rowC['brand_id']; $modelID = $rowC['model_id']; } } $myDate = explode(" ", $myTimeStamp); $myCurrentDate = $myDate[0]; if($pmodelID > 0){ $sql = "SELECT * FROM `aha_promo_code` WHERE `promo_code`='$promoCode' AND `enabled` = 1 AND `aha_owner_id`='$userID' AND `used_code`='NO' AND `expiry_date` > '$myTimeStamp' AND `model_id`=$modelID AND `dealer_id` = $dealID"; } if($pbrandID > 0){ $sql = "SELECT * FROM `aha_promo_code` WHERE `promo_code`='$promoCode' AND `enabled` = 1 AND `aha_owner_id`='$userID' AND `used_code`='NO' AND `expiry_date` > '$myTimeStamp' AND `brand_id`=$brandID AND `dealer_id` = $dealID"; } if($dealID > 0){ $sql = "SELECT * FROM `aha_promo_code` WHERE `promo_code`='$promoCode' AND `enabled` = 1 AND `aha_owner_id`='$userID' AND `used_code`='NO' AND `expiry_date` > '$myTimeStamp' AND `brand_id`=$brandID AND `dealer_id` = $dealID"; }else{ //applicable to all $sql = "SELECT * FROM `aha_promo_code` WHERE `promo_code`='$promoCode' AND `enabled` = 1 AND `aha_owner_id`='$userID' AND `used_code`='NO' AND `expiry_date` > '$myTimeStamp'"; } $result = $conn->query($sql); if ($result->num_rows > 0) { // Array to hold the results $rows = array(); // Fetch data from each row and add it to the array while($row = $result->fetch_assoc()) { $count = $count + 1; if($count > 0){ $isVisible = 'true'; $codeStat = "Valid Promo Code"; }else{ $isVisible = ''; $codeStat = "Invalid Promo Code"; } $rows[] = $row; } // Output the result in JSON format header('Content-Type: application/json'); echo json_encode([$rows,"Count" => "$count","cssCode" => "validCode","codeStatus" => "Valid Promo Code"]); } else { echo json_encode([$rows,"Count" => "$count","cssCode" => "invalidCode","codeStatus" => "Invalid Promo Code. Click CONFIRM button to proceed without promo code"]); } } $conn->close(); ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings