­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ connect_error) { die("Connection failed: " . $conn->connect_error); } // Sanitize and retrieve form data $mobile = isset($_POST['mobile']) ? $conn->real_escape_string($_POST['mobile']) : ''; if (empty($mobile)) { die("Mobile number is required."); } // Check if the mobile number has submitted a lead in the last 15 days $checkQuery = "SELECT id FROM leads WHERE mobile = '$mobile' AND created_at >= DATE_SUB(NOW(), INTERVAL 15 DAY)"; $result = $conn->query($checkQuery); if ($result->num_rows > 0) { $is_duplicate = '1'; // echo "Duplicate Lead"; // If no recent lead exists, insert the new lead $utm_source = isset($_POST['utm_source']) ? $conn->real_escape_string($_POST['utm_source']) : ''; $utm_campaign = isset($_POST['utm_campaign']) ? $conn->real_escape_string($_POST['utm_campaign']) : ''; $formtype = isset($_POST['formtype']) ? $conn->real_escape_string($_POST['formtype']) : ''; $offer_id = isset($_POST['offer_id']) ? (int)$_POST['offer_id'] : 0; $fullName = isset($_POST['fullName']) ? $conn->real_escape_string($_POST['fullName']) : ''; $email = isset($_POST['email']) ? $conn->real_escape_string($_POST['email']) : ''; $salary = isset($_POST['salary']) ? (int)$_POST['salary'] : 0; $model = isset($_POST['model']) ? $conn->real_escape_string($_POST['model']) : ''; $nationality = isset($_POST['nationality']) ? $conn->real_escape_string($_POST['nationality']) : ''; $bank = isset($_POST['bank']) ? $conn->real_escape_string($_POST['bank']) : ''; $gender = isset($_POST['gender']) ? $conn->real_escape_string($_POST['gender']) : ''; $city = isset($_POST['city']) ? $conn->real_escape_string($_POST['city']) : ''; $branch = isset($_POST['branch']) ? $conn->real_escape_string($_POST['branch']) : ''; $obligation = isset($_POST['obligation']) ? $conn->real_escape_string($_POST['obligation']) : ''; $realestateLoan = isset($_POST['realestateLoan']) ? $conn->real_escape_string($_POST['realestateLoan']) : ''; $obligationAmount = isset($_POST['obligationAmount']) ? (int)$_POST['obligationAmount'] : 0; $purchaseTime = isset($_POST['purchaseTime']) ? $conn->real_escape_string($_POST['purchaseTime']) : ''; $terms = isset($_POST['terms']) ? $conn->real_escape_string($_POST['terms']) : ''; $otp = isset($_POST['otp']) ? $conn->real_escape_string($_POST['otp']) : ''; $otpVerified = isset($_POST['otpVerified']) ? $conn->real_escape_string($_POST['otpVerified']) : ''; $created_at = date('Y-m-d H:i:s'); // Current timestamp in Riyadh timezone $sql = "INSERT INTO duplicate_leads (utm_source, utm_campaign, formtype, offer_id, fullName, email, mobile, salary, model, nationality, bank, gender, city, branch, obligation, realestateLoan, obligationAmount, purchaseTime, terms, created_at,otp,otpVerified) VALUES ('$utm_source', '$utm_campaign', '$formtype', $offer_id, '$fullName', '$email', '$mobile', $salary, '$model', '$nationality', '$bank', '$gender', '$city', '$branch', '$obligation', '$realestateLoan', $obligationAmount, '$purchaseTime', '$terms', '$created_at','$otp','$otpVerified')"; if ($conn->query($sql) === TRUE) { //echo "Data successfully inserted!"; } else { echo "Error: " . $sql . "
" . $conn->error; } }else{ // If no recent lead exists, insert the new lead $utm_source = isset($_POST['utm_source']) ? $conn->real_escape_string($_POST['utm_source']) : ''; $utm_campaign = isset($_POST['utm_campaign']) ? $conn->real_escape_string($_POST['utm_campaign']) : ''; $formtype = isset($_POST['formtype']) ? $conn->real_escape_string($_POST['formtype']) : ''; $offer_id = isset($_POST['offer_id']) ? (int)$_POST['offer_id'] : 0; $fullName = isset($_POST['fullName']) ? $conn->real_escape_string($_POST['fullName']) : ''; $email = isset($_POST['email']) ? $conn->real_escape_string($_POST['email']) : ''; $salary = isset($_POST['salary']) ? (int)$_POST['salary'] : 0; $model = isset($_POST['model']) ? $conn->real_escape_string($_POST['model']) : ''; $nationality = isset($_POST['nationality']) ? $conn->real_escape_string($_POST['nationality']) : ''; $bank = isset($_POST['bank']) ? $conn->real_escape_string($_POST['bank']) : ''; $gender = isset($_POST['gender']) ? $conn->real_escape_string($_POST['gender']) : ''; $city = isset($_POST['city']) ? $conn->real_escape_string($_POST['city']) : ''; $branch = isset($_POST['branch']) ? $conn->real_escape_string($_POST['branch']) : ''; $obligation = isset($_POST['obligation']) ? $conn->real_escape_string($_POST['obligation']) : ''; $realestateLoan = isset($_POST['realestateLoan']) ? $conn->real_escape_string($_POST['realestateLoan']) : ''; $obligationAmount = isset($_POST['obligationAmount']) ? (int)$_POST['obligationAmount'] : 0; $purchaseTime = isset($_POST['purchaseTime']) ? $conn->real_escape_string($_POST['purchaseTime']) : ''; $terms = isset($_POST['terms']) ? $conn->real_escape_string($_POST['terms']) : ''; $otp = isset($_POST['otp']) ? $conn->real_escape_string($_POST['otp']) : ''; $otpVerified = isset($_POST['otpVerified']) ? $conn->real_escape_string($_POST['otpVerified']) : ''; $created_at = date('Y-m-d H:i:s'); // Current timestamp in Riyadh timezone $sql = "INSERT INTO leads (utm_source, utm_campaign, formtype, offer_id, fullName, email, mobile, salary, model, nationality, bank, gender, city, branch, obligation, realestateLoan, obligationAmount, purchaseTime, terms, created_at,otp,otpVerified) VALUES ('$utm_source', '$utm_campaign', '$formtype', $offer_id, '$fullName', '$email', '$mobile', $salary, '$model', '$nationality', '$bank', '$gender', '$city', '$branch', '$obligation', '$realestateLoan', $obligationAmount, '$purchaseTime', '$terms', '$created_at','$otp','$otpVerified')"; if ($conn->query($sql) === TRUE) { //echo "Data successfully inserted!"; } else { // echo "Error: " . $sql . "
" . $conn->error; } function getbranchValue($lookup_value) { // Database connection parameters $servername = "localhost"; $username = "balubaid_autozoneoffers"; $password = "Vision@2050"; $dbname = "balubaid_autozoneoffers"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } // Prepare SQL query to prevent SQL injection $stmt = $conn->prepare("SELECT result_value FROM branch_lookup WHERE lookup_value = ?"); $stmt->bind_param("s", $lookup_value); // "s" means string type // Execute the query $stmt->execute(); $stmt->bind_result($result_value); // Fetch the result if ($stmt->fetch()) { $stmt->close(); $conn->close(); return $result_value; } else { $stmt->close(); $conn->close(); return null; // Return null if no match is found } } function getcityValue($lookup_value) { // Database connection parameters $servername = "localhost"; $username = "balubaid_autozoneoffers"; $password = "Vision@2050"; $dbname = "balubaid_autozoneoffers"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } // Prepare SQL query to prevent SQL injection $stmt = $conn->prepare("SELECT result_value FROM city_lookup WHERE lookup_value = ?"); $stmt->bind_param("s", $lookup_value); // "s" means string type // Execute the query $stmt->execute(); $stmt->bind_result($result_value); // Fetch the result if ($stmt->fetch()) { $stmt->close(); $conn->close(); return $result_value; } else { $stmt->close(); $conn->close(); return null; // Return null if no match is found } } function getbankValue($lookup_value) { // Database connection parameters $servername = "localhost"; $username = "balubaid_autozoneoffers"; $password = "Vision@2050"; $dbname = "balubaid_autozoneoffers"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } // Prepare SQL query to prevent SQL injection $stmt = $conn->prepare("SELECT result_value FROM bank_lookup WHERE lookup_value = ?"); $stmt->bind_param("s", $lookup_value); // "s" means string type // Execute the query $stmt->execute(); $stmt->bind_result($result_value); // Fetch the result if ($stmt->fetch()) { $stmt->close(); $conn->close(); return $result_value; } else { $stmt->close(); $conn->close(); return null; // Return null if no match is found } } if($salary > 10000){ $vsalary = 'أكثر من ١٠٠٠٠ - Above 10000'; }elseif($salary > 5000){ $vsalary = 'من ٥٠٠٠ إلى ١٠٠٠٠ - From 5000 to 10000'; }elseif($salary > 4000){ $vsalary = 'أكثر من ١٠٠٠٠ - Above 10000'; } if($gender == 'Male'){ $vgender = 'Male - ذكر'; } if($gender == 'Female'){ $vgender = 'Female - أنثى'; } $vbank = getbankValue($bank); $vbranch = getbranchValue($branch); $vcity = getcityValue($city); $data = array('your-name' => $fullName,'phonenumber' => $mobile,'your-email' => $email,'your-car' => $model,'source' => $utm_source,'campaign' => $utm_campaign, 'your-city' => $vcity,'gender' => $vgender,'salary' => $vsalary,'your-branch' => $vbranch,'your-bank' => $vbank,'formid' => $offer_id,'form-type' => $formtype); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL,"https://lp.autozone.com.sa/service_request/get_service.php?confirm=@CRM1"); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS,$data); // In real life you should use something like: // curl_setopt($ch, CURLOPT_POSTFIELDS, // http_build_query(array('postvar1' => 'value1'))); // Receive server response ... curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $server_output = curl_exec($ch); curl_close ($ch); //print_r($server_output); //print_r(json_decode(trim($server_output),true)); $oppdetail = json_decode(trim($server_output),true); //echo $oppdetail['Agent Name']; //echo "
"; //echo $oppdetail['Branch Name']; //echo "
"; //echo $oppdetail['address']; //echo "
"; //echo $oppdetail['agentnumber']; //echo "
"; //echo $oppdetail['branchurl']; } $conn->close(); ?> Your Dream Car Awaits! - <?php if($is_duplicate == '1'){echo "Duplicate Submission";}else{echo "Thank-You Submission";} ?>

You're one step closer to driving your dream car!

Congratulations!

Your application has been successfully submitted.

Your Dedicated Sales Consultant

Name:

Mobile:

Chat with Your Agent
Showroom Location


Save Contact

Stay connected with us!

If you have any questions, feel free to reach out!

customercare@autozone.com.sa

Call us at 8007606000