How can unique constraints in a database table be utilized to prevent duplicate entries when inserting data using PHP?

To prevent duplicate entries when inserting data into a database table using PHP, you can utilize unique constraints on the relevant columns. Unique constraints ensure that each value in the specified column(s) is unique, thus preventing duplicate entries from being inserted. 

// Assuming $pdo is your database connection object

$stmt = $pdo->prepare("INSERT INTO your_table_name (column1, column2) VALUES (:value1, :value2)");

$value1 = 'some_value';
$value2 = 'some_other_value';

try {
    $stmt->execute(['value1' => $value1, 'value2' => $value2]);
    echo "Data inserted successfully!";
} catch (PDOException $e) {
    if ($e->errorInfo[1] == 1062) { // MySQL error code for duplicate entry
        echo "Duplicate entry found. Cannot insert duplicate data.";
    } else {
        echo "Error: " . $e->getMessage();
    }
}

Keywords

unique constraints database table prevent duplicate entries inserting data PHP

Related Questions