How can PHP developers ensure data integrity and prevent duplicate entries when working with database interactions?

To ensure data integrity and prevent duplicate entries when working with database interactions in PHP, developers can use unique constraints in the database schema and handle potential duplicates through error handling in the PHP code. 

// Example code snippet to prevent duplicate entries in a MySQL database using unique constraint

// Connect to the database
$pdo = new PDO("mysql:host=localhost;dbname=mydatabase", "username", "password");

// Prepare and execute the SQL query with a unique constraint on the email column
$stmt = $pdo->prepare("INSERT INTO users (email, name) VALUES (:email, :name)");
$stmt->bindParam(':email', $email);
$stmt->bindParam(':name', $name);

try {
    $stmt->execute();
    echo "User added successfully!";
} catch (PDOException $e) {
    if ($e->errorInfo[1] == 1062) {
        // Duplicate entry error code
        echo "User with this email already exists!";
    } else {
        // Other database error
        echo "Database error: " . $e->getMessage();
    }
}

Keywords

PHP data integrity prevent duplicate entries database interactions error handling

Related Questions