File manager - Edit - /home/autoph/public_html/api/aha/validate_promoCode.BAK
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']; if($dealID > 0){ $myDeal = "dealer_id = $dealID"; }else{ $myDeal = "dealer_id IS NULL"; } $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']; } $filter = 0; if($pbrandID == NULL){ $filter = 1; } if($pmodelID == NULL){ $filter = 1; } if($pdealID == NULL){ $filter = 1; } } $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']; } } if($brandID > 0){ $myBrand = "brand_id = $brandID"; }else{ $myBrand = "brand_id IS NULL"; } if($modelID > 0){ $myModel = "model_id = $modelID"; }else{ $myModel = "model_id IS NULL"; } $myDate = explode(" ", $myTimeStamp); $myCurrentDate = $myDate[0]; // SQL query if($filter > 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 $myDeal AND $myBrand AND $myModel"; }else{ $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