How can duplicate entry errors be avoided when inserting search results in PHP?

Duplicate entry errors can be avoided when inserting search results in PHP by checking if the entry already exists in the database before inserting it. This can be achieved by performing a SELECT query to check if the entry exists, and only inserting it if it doesn't. This way, duplicate entries are prevented from being inserted. 

// Check if the entry already exists in the database
$query = "SELECT * FROM table_name WHERE column_name = :search_term";
$stmt = $pdo->prepare($query);
$stmt->bindParam(':search_term', $search_term);
$stmt->execute();

if($stmt->rowCount() == 0) {
    // Insert the search result if it doesn't already exist
    $insert_query = "INSERT INTO table_name (column_name) VALUES (:search_term)";
    $insert_stmt = $pdo->prepare($insert_query);
    $insert_stmt->bindParam(':search_term', $search_term);
    $insert_stmt->execute();
}

Keywords

PHP MySQL INSERT IGNORE ON DUPLICATE KEY UPDATE Error handling

Related Questions