What is the best approach to implementing a multiple delete function for messages in PHP?

The best approach to implementing a multiple delete function for messages in PHP is to use a form with checkboxes for each message that the user wants to delete. When the form is submitted, the PHP code should check which checkboxes are selected and then delete the corresponding messages from the database. 

<?php
// Check if the form is submitted
if(isset($_POST['delete_messages'])) {
    
    // Get the array of message IDs to delete
    $messages_to_delete = $_POST['messages'];
    
    // Connect to the database
    $conn = new mysqli('localhost', 'username', 'password', 'database');
    
    // Loop through the array and delete each message
    foreach($messages_to_delete as $message_id) {
        $sql = "DELETE FROM messages WHERE id = $message_id";
        $conn->query($sql);
    }
    
    // Close the database connection
    $conn->close();
    
    // Redirect back to the messages page
    header('Location: messages.php');
    exit;
}
?>

<form method="post" action="">
    <?php
    // Display messages with checkboxes
    $messages = // Retrieve messages from the database
    
    foreach($messages as $message) {
        echo '<input type="checkbox" name="messages[]" value="' . $message['id'] . '"> ' . $message['content'] . '<br>';
    }
    ?>
    
    <input type="submit" name="delete_messages" value="Delete Selected Messages">
</form>

Keywords

PHP multiple delete messages function implementation

Related Questions