22

✏️ Editing: get_if_dupl_mobile.php

<?php
// --- DB CONFIG ---
$dbHost = "localhost";
$dbUser = "balubaid_core3_leads";
$dbPass = "Vision@2050";
$dbName = "balubaid_core3_leads";
$table  = "xx_honda_leads";       // your table name
$colPhone = "mobile";    // phone column
$colCreated = "request_date"; // datetime/timestamp column
// -----------------

header("Content-Type: text/plain; charset=UTF-8");
header("Cache-Control: no-store");

// Get phone from request (accepts POST or GET)
$rawPhone = $_POST['phone'] ?? $_GET['phone'] ?? "";
$phone    = preg_replace('/\D+/', '', $rawPhone); // keep digits only

if ($phone === "") {
    echo "0"; // no phone provided
    exit;
}

try {
    $conn = new mysqli($dbHost, $dbUser, $dbPass, $dbName);
    if ($conn->connect_error) {
        throw new Exception("DB connect error: " . $conn->connect_error);
    }

$stmt = $conn->prepare("
        SELECT 1 
        FROM {$table} 
        WHERE {$colPhone} = ? 
          AND {$colCreated} >= (NOW() - INTERVAL 7 DAY)
        LIMIT 1
    ");
    $stmt->bind_param("s", $phone);
    $stmt->execute();
    $stmt->store_result();

if ($stmt->num_rows > 0) {
        echo "1"; // duplicate found
    } else {
        echo "0"; // not found
    }

$stmt->close();
    $conn->close();
} catch (Exception $e) {
    // On error, allow submission
    // error_log($e->getMessage());
    echo "0";
}

MR SKB