How can PHP developers effectively allow users to update database records by changing status values using buttons within a table display?

To allow users to update database records by changing status values using buttons within a table display, PHP developers can create a form within each table row that contains a hidden input field for the record's ID and buttons for each possible status value. When a user clicks on a status button, an AJAX request can be sent to a PHP script that updates the database record with the new status value. 

<?php
// Display table with records
echo "<table>";
foreach ($records as $record) {
    echo "<tr>";
    echo "<td>{$record['id']}</td>";
    echo "<td>{$record['name']}</td>";
    echo "<td>{$record['status']}</td>";
    echo "<td>
            <form method='post' action='update_status.php'>
                <input type='hidden' name='id' value='{$record['id']}'>
                <button type='submit' name='status' value='active'>Activate</button>
                <button type='submit' name='status' value='inactive'>Deactivate</button>
            </form>
          </td>";
    echo "</tr>";
}
echo "</table>";
?>

<!-- update_status.php -->
<?php
// Update record status
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $id = $_POST['id'];
    $status = $_POST['status'];
    
    // Update database record with new status
    // Add your database connection and query here
}
?>

Keywords

PHP database records status values buttons table display

Related Questions