Are there best practices for implementing a time-based restriction in a PHP script to prevent double counting of visitors with changing IPs?

To prevent double counting of visitors with changing IPs, you can implement a time-based restriction in your PHP script. This involves storing the visitor's IP address along with a timestamp in a database or file. When a new visit occurs, you can check if the IP address has been recorded within a certain time frame (e.g., 1 hour) to determine if it should be counted as a unique visit. 

// Connect to database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "visitors";

$conn = new mysqli($servername, $username, $password, $dbname);

// Get visitor's IP address
$ip = $_SERVER['REMOTE_ADDR'];

// Check if IP address has visited within the last hour
$sql = "SELECT COUNT(*) FROM visits WHERE ip_address = '$ip' AND visit_time > DATE_SUB(NOW(), INTERVAL 1 HOUR)";
$result = $conn->query($sql);
$row = $result->fetch_assoc();

if ($row['COUNT(*)'] == 0) {
    // Record new visit
    $sql = "INSERT INTO visits (ip_address, visit_time) VALUES ('$ip', NOW())";
    $conn->query($sql);

    // Increment visitor count
    $sql = "UPDATE stats SET visitor_count = visitor_count + 1";
    $conn->query($sql);
}

// Close database connection
$conn->close();

Keywords

PHP time-based restriction double counting visitors changing IPs

Related Questions