How can you count the number of duplicate entries for a specific column in a MySQL table using PHP?

To count the number of duplicate entries for a specific column in a MySQL table using PHP, you can write a SQL query to group by that column and count the number of occurrences. You can then fetch the result in PHP and display the count of duplicates. 

<?php
// Connect to MySQL database
$connection = mysqli_connect("localhost", "username", "password", "database");

// Check connection
if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
    exit();
}

// SQL query to count duplicates in a specific column
$query = "SELECT column_name, COUNT(column_name) as count FROM table_name GROUP BY column_name HAVING count > 1";

// Execute the query
$result = mysqli_query($connection, $query);

// Fetch and display the count of duplicates
while ($row = mysqli_fetch_assoc($result)) {
    echo "Duplicate entries for " . $row['column_name'] . ": " . $row['count'] . "<br>";
}

// Close the connection
mysqli_close($connection);
?>

Keywords

PHP MySQL count duplicate entries specific column

Related Questions