Skip to content
PHP Logo

When should INSERT queries be used instead of UPDATE queries in PHP?

INSERT queries should be used when you want to add new data to a database table, while UPDATE queries should be used when you want to modify existing data in a table. If you are unsure whether a record already exists in the table, you can use a SELECT query to check before deciding whether to use an INSERT or UPDATE query.

php 
// Example code snippet to demonstrate using INSERT or UPDATE queries in PHP

// Assuming $conn is the database connection object

// Check if a record already exists
$sql = "SELECT * FROM table_name WHERE id = $id";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // Record exists, use UPDATE query
    $sql = "UPDATE table_name SET column1 = value1, column2 = value2 WHERE id = $id";
} else {
    // Record does not exist, use INSERT query
    $sql = "INSERT INTO table_name (column1, column2) VALUES (value1, value2)";
}

// Execute the query
$conn->query($sql);

Related questions