如何用单个PHP文件实现多按钮对数据表执行不同操作

Let's walk through how to build a data table with 4 action buttons that modify selected rows, using your existing PHP processing logic. Here's a practical, step-by-step implementation:

1. Build the HTML Form & Data Table Structure #

First, wrap your entire data table and action buttons in a single <form> tag. Each button will have a unique name attribute so your PHP script can identify which action to run. We'll also add checkboxes for each row, named as an array (selected_ids[]) to capture multiple selected row IDs.

<form method="POST" action="your-processing-script.php">
    <!-- Action Buttons -->
    <div class="action-buttons">
        <button type="submit" name="action" value="mark_sold">Add to Sold</button>
        <button type="submit" name="action" value="mark_pending">Mark as Pending</button>
        <button type="submit" name="action" value="delete">Delete Entries</button>
        <button type="submit" name="action" value="export">Export Selected</button>
    </div>

    <!-- Data Table -->
    <table>
        <thead>
            <tr>
                <th>Select</th>
                <th>Item Name</th>
                <th>Status</th>
                <!-- Add other columns as needed -->
            </tr>
        </thead>
        <tbody>
            <?php
            // Assume you're fetching rows from your database here
            $rows = [
                ['id' => 1, 'name' => 'Laptop', 'status' => 'In Stock'],
                ['id' => 2, 'name' => 'Phone', 'status' => 'In Stock'],
                // Add more sample rows or replace with your DB query
            ];

            foreach ($rows as $row) {
                echo "<tr>";
                echo "<td><input type='checkbox' name='selected_ids[]' value='{$row['id']}'></td>";
                echo "<td>{$row['name']}</td>";
                echo "<td>{$row['status']}</td>";
                echo "</tr>";
            }
            ?>
        </tbody>
    </table>
</form>

2. Update Your PHP Processing Script #

In your existing PHP file, add logic to check which button was clicked, validate the selected IDs, and run the corresponding action.

<?php
// Check if the form was submitted
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    // First, verify selected IDs exist
    if (!isset($_POST['selected_ids']) || empty($_POST['selected_ids'])) {
        echo "Please select at least one entry.";
        exit;
    }

    $selectedIds = $_POST['selected_ids'];
    $action = $_POST['action'];

    // Sanitize IDs to prevent SQL injection (critical!)
    $sanitizedIds = array_map(function($id) {
        return intval($id);
    }, $selectedIds);
    $idsString = implode(',', $sanitizedIds);

    // Connect to your database (replace with your DB credentials)
    $conn = mysqli_connect('localhost', 'username', 'password', 'your_database');

    switch ($action) {
        case 'mark_sold':
            // Your existing logic to mark entries as sold
            $query = "UPDATE your_table SET status = 'Sold' WHERE id IN ($idsString)";
            mysqli_query($conn, $query);
            echo "Selected entries marked as Sold!";
            break;

        case 'mark_pending':
            // Logic for marking as pending
            $query = "UPDATE your_table SET status = 'Pending' WHERE id IN ($idsString)";
            mysqli_query($conn, $query);
            echo "Selected entries marked as Pending!";
            break;

        case 'delete':
            // Logic for deleting entries
            $query = "DELETE FROM your_table WHERE id IN ($idsString)";
            mysqli_query($conn, $query);
            echo "Selected entries deleted!";
            break;

        case 'export':
            // Your export logic (e.g., generate CSV)
            echo "Exporting selected entries...";
            break;

        default:
            echo "Invalid action selected.";
            break;
    }

    mysqli_close($conn);

    // Optional: Redirect back to the data table page to avoid form resubmission
    // header("Location: your-data-table-page.php");
    // exit;
}
?>

Key Notes to Avoid Issues #

• SQL Injection Protection: Always sanitize user input (we used intval() here since IDs are numeric; for string values, use prepared statements instead).
• Form Resubmission: After processing, use a redirect to the data table page instead of echoing messages directly—this prevents users from accidentally re-running the action by refreshing.
• Checkbox Array: Using selected_ids[] as the checkbox name ensures all selected IDs are sent to PHP as an array, which is easy to process.
• Button Identification: Using a single action name with different values keeps the form clean and makes it simple to branch logic in PHP.

Once you've set this up, you can test each button to ensure it triggers the correct PHP logic for your selected rows.

内容的提问来源于stack exchange，提问作者Andrew Richards