Programming Languages

PHP MySQL DELETE Data

Delete records from MySQL database

MySQLi Delete (Procedural)

$sql = "DELETE FROM users WHERE id=5"; # delete query
if (mysqli_query($conn, $sql)) { # execute delete
    echo "Record deleted"; # success message
} else { # error handling
    echo "Error: " . mysqli_error($conn); # display error
}

MySQLi Delete (OOP)

$sql = "DELETE FROM orders WHERE status='cancelled'"; # delete multiple rows
if ($conn->query($sql) === TRUE) { # check success
    echo $conn->affected_rows . " deleted"; # count deleted rows
}

PDO Delete

$sql = "DELETE FROM users WHERE id = ?"; # prepared delete
$stmt = $pdo->prepare($sql); # prepare statement
$stmt->execute([15]); # execute with ID
echo $stmt->rowCount() . " deleted"; # count rows