How can I display only unique IP addresses from a database in PHP?

To display only unique IP addresses from a database in PHP, you can query the database for all IP addresses and then use the PHP array_unique() function to remove any duplicate entries. Finally, you can iterate through the unique IP addresses and display them as needed. 

// Connect to the database
$connection = new mysqli("localhost", "username", "password", "database");

// Query to retrieve all IP addresses
$query = "SELECT DISTINCT ip_address FROM table_name";
$result = $connection->query($query);

// Store unique IP addresses in an array
$unique_ips = array();
while ($row = $result->fetch_assoc()) {
    $unique_ips[] = $row['ip_address'];
}

// Remove duplicates
$unique_ips = array_unique($unique_ips);

// Display unique IP addresses
foreach ($unique_ips as $ip) {
    echo $ip . "<br>";
}

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

Keywords

PHP database unique IP addresses display

Related Questions