What are some best practices for updating user permissions using checkboxes in PHP?

When updating user permissions using checkboxes in PHP, it is important to properly handle the form submission and update the user's permissions accordingly. One best practice is to iterate through all available permissions and check if each permission checkbox is checked or not. Based on the checkbox status, update the user's permissions accordingly in the database.

// Assuming form submission with checkboxes named 'permission_1', 'permission_2', 'permission_3', etc.
$user_id = $_POST['user_id']; // Assuming user ID is submitted via POST
$permissions = []; // Array to store user permissions

// Iterate through all available permissions
for ($i = 1; $i <= 3; $i++) {
    if (isset($_POST['permission_' . $i])) {
        // If checkbox is checked, add permission to the array
        $permissions[] = $i;
    }
}

// Update user permissions in the database
// Example SQL query:
// UPDATE users SET permissions = '1,2,3' WHERE id = $user_id