How can a visitor counter be implemented using PHP and IP addresses?

To implement a visitor counter using PHP and IP addresses, you can store the unique IP addresses of visitors in a database and increment the counter whenever a new IP address is encountered. This way, you can accurately track the number of unique visitors to your website. 

<?php
// Connect to database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "visitor_counter";

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

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

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

// Check if IP address already exists in database
$sql = "SELECT * FROM visitors WHERE ip_address = '$ip_address'";
$result = $conn->query($sql);

if ($result->num_rows == 0) {
    // Insert new IP address into database
    $sql = "INSERT INTO visitors (ip_address) VALUES ('$ip_address')";
    $conn->query($sql);

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

// Display visitor count
$sql = "SELECT count FROM counter";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
echo "Total visitors: " . $row['count'];

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

Keywords

PHP visitor counter IP addresses implementation tracking

Related Questions