CI框架：如何将多复选框查询结果存入数组并返回至控制器

Hey there! Let's break down how to fix your CodeIgniter issue and get those checkbox values working properly. First, let's address why only the first checkbox is returning data—chances are your view's checkboxes aren't set up to send an array of IDs, which means only the last selected ID is being passed to your model. Here's how to fix this step by step:

1. Fix the View Checkbox Markup #

First, make sure your checkboxes use an array-style name attribute so all selected IDs are sent to the controller:

<!-- In your view file -->
<input type="checkbox" name="channel_ids[]" value="1"> Channel 1
<input type="checkbox" name="channel_ids[]" value="2"> Channel 2
<!-- Add more checkboxes as needed -->

The [] after channel_ids tells PHP to collect all selected values into an array.

2. Update Your Controller to Pass the Array to the Model #

Next, modify your controller to grab the array of channel IDs and pass it to your model's get_data() method. We'll also add a check to handle cases where no checkboxes are selected:

// In your controller
public function process_channels() {
    // Get the selected channel IDs from the POST request
    $channel_ids = $this->input->post('channel_ids');
    
    // Validate we have an array of IDs
    if (!empty($channel_ids) && is_array($channel_ids)) {
        // Load your model (if not already autoloaded)
        $this->load->model('your_model_name');
        // Call the model method with the ID array
        $results = $this->your_model_name->get_data($channel_ids);
        
        // Pass results to your view (or do whatever you need with them)
        $data['channel_results'] = $results;
        $this->load->view('your_view_file', $data);
    } else {
        // Handle no checkboxes selected case
        $data['channel_results'] = [];
        $this->load->view('your_view_file', $data);
    }
}

3. Modify the Model's get_data() Method #

Now let's update the model to loop through each channel ID, run the query, and collect results. I'll show you two approaches:

Option 1: Combine All Results into a Single Array

Use this if you want all matching records from all selected channels in one flat array:

// In your model
public function get_data($channel_ids) {
    $final_results = [];
    
    // Loop through each selected channel ID
    foreach ($channel_ids as $id) {
        // Run your query (replace 'your_table' and 'channel_id' with your actual table/column names)
        $query = $this->db->get_where('your_table', ['channel_id' => $id]);
        
        // If the query returns results, add them to the final array
        if ($query->num_rows() > 0) {
            // Use result_array() for an array of rows, or row_array() for a single row
            $final_results = array_merge($final_results, $query->result_array());
        }
    }
    
    return $final_results;
}

Option 2: Store Results in a Multi-Dimensional Array (Per Channel ID)

If you want to keep results grouped by their channel ID (so you can tell which results belong to which channel), use this approach:

// In your model
public function get_data($channel_ids) {
    $final_results = [];
    
    foreach ($channel_ids as $id) {
        $query = $this->db->get_where('your_table', ['channel_id' => $id]);
        
        // Store results under the channel ID as the key
        $final_results[$id] = $query->num_rows() > 0 ? $query->result_array() : [];
    }
    
    return $final_results;
}

With this, you can access results like $channel_results[2] to get all records for channel ID 2.

Troubleshooting Tips #

• Check the POST data: Add var_dump($channel_ids); die(); in your controller to confirm you're getting an array of selected IDs. If you only see one ID, your view's checkbox names aren't using the array syntax.
• Debug the query: In the model, add echo $this->db->last_query(); die(); after running the query to see exactly what SQL is being executed—this helps confirm if the ID is being passed correctly.
• Validate IDs: You might want to sanitize the IDs (e.g., use array_map('intval', $channel_ids) to ensure they're integers) to prevent SQL injection risks.

内容的提问来源于stack exchange，提问作者Awon Ali