How can multiple columns be checked for duplicate entries in PHP before inserting data into a database?

To check for duplicate entries in multiple columns before inserting data into a database in PHP, you can use a SELECT query to search for existing records that match the values being inserted. If any matching records are found, you can prevent the insertion of duplicate data by either displaying an error message or updating the existing record instead. 

// Assume $conn is the database connection object

// Values to be inserted
$value1 = "value1";
$value2 = "value2";

// Check for duplicate entries
$query = "SELECT * FROM table_name WHERE column1 = '$value1' AND column2 = '$value2'";
$result = mysqli_query($conn, $query);

if(mysqli_num_rows($result) > 0){
    // Duplicate entry found, display error message or update existing record
    echo "Duplicate entry found.";
} else {
    // Insert data into the database
    $insert_query = "INSERT INTO table_name (column1, column2) VALUES ('$value1', '$value2')";
    mysqli_query($conn, $insert_query);
    echo "Data inserted successfully.";
}

Keywords

PHP database duplicate entries validation columns

Related Questions