What are the best practices for implementing a "soft delete" functionality in PHP?

Implementing a "soft delete" functionality in PHP involves updating a database record's status to indicate that it has been deleted without actually removing it from the database. This allows for easy recovery of deleted data if needed. 

// Example code for implementing soft delete functionality in PHP
// Assume we have a database table called 'users' with a column 'is_deleted' to indicate whether a user is deleted or not

// Soft delete a user by updating the 'is_deleted' column to 1
$user_id = 1;
$query = "UPDATE users SET is_deleted = 1 WHERE id = $user_id";
$result = mysqli_query($connection, $query);

if($result) {
    echo "User soft deleted successfully.";
} else {
    echo "Error soft deleting user.";
}

Keywords

soft delete functionality PHP implementation best practices

Related Questions