How can PHP be used to check if a specific row exists in a MySQL database before inserting a new entry?

To check if a specific row exists in a MySQL database before inserting a new entry, you can use a SELECT query to search for the row based on certain criteria. If the query returns a result, it means the row already exists. You can then use the result of this query to decide whether to proceed with the insertion or not. 

<?php
// Establish a connection to the database
$connection = mysqli_connect("localhost", "username", "password", "database");

// Check connection
if (!$connection) {
    die("Connection failed: " . mysqli_connect_error());
}

// Define the criteria for the row you want to check
$columnValue = "value";

// Check if the row already exists
$sql = "SELECT * FROM table_name WHERE column_name = '$columnValue'";
$result = mysqli_query($connection, $sql);

if (mysqli_num_rows($result) > 0) {
    echo "Row already exists in the database.";
} else {
    // Proceed with inserting a new entry
    $sql = "INSERT INTO table_name (column_name) VALUES ('$columnValue')";
    if (mysqli_query($connection, $sql)) {
        echo "New entry inserted successfully.";
    } else {
        echo "Error: " . $sql . "<br>" . mysqli_error($connection);
    }
}

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

Keywords

PHP MySQL database row existence insertion

Related Questions