CodeIgniter中多选下拉框在编辑页面的数据回显实现指南

// application/models/Your_model.php

public function addClientDetails() {
    // 1. 插入主表数据 (user_table)
    $data = array(
        'business_name' => html_escape($this->input->post('business_name')),
        'legal_name'    => html_escape($this->input->post('legal_name')),
        'status'        => html_escape($this->input->post('status')),
        'rating'        => html_escape($this->input->post('rating')),
        'SU_id'         => html_escape($this->input->post('admin_id')), // Assuming this is for a single admin_id, if any
        'created_at'    => date('Y-m-d H:i:s'), // 使用大写H表示24小时制
        'created_by'    => $this->session->userdata('admin_id')
    );
    $this->db->insert('user_table', $data);
    $insertId = $this->db->insert_id(); // 获取新插入的user_table记录的ID

    // 2. 处理多选的 assignuserstable 数据
    $admin_idds = $this->input->post('admin_idd'); // 这是一个包含多个admin_id的数组
    $assign_data = array();

    if (!empty($admin_idds) && is_array($admin_idds)) {
        foreach ($admin_idds as $admin_id) {
            $assign_data[] = array(
                'user_id'   => $insertId,
                'admin_id'  => html_escape($admin_id), // 对每个admin_id进行安全转义
                'user_type' => html_escape($this->input->post('user_type')),
            );
        }
        // 批量插入到 assignuserstable 表
        $this->db->insert_batch('assignuserstable', $assign_data);
    }

    return $insertId; // 返回主表插入的ID
}

// application/models/Your_model.php

public function getAssignedAdminIds($user_id) {
    $this->db->select('admin_id');
    $this->db->where('user_id', $user_id);
    $query = $this->db->get('assignuserstable');

    $assigned_admin_ids = array();
    foreach ($query->result_array() as $row) {
        $assigned_admin_ids[] = $row['admin_id'];
    }
    return $assigned_admin_ids;
}

// 假设还有一个方法获取所有可选的用户
public function getAllSystemUsers() {
    return $this->db->get('system_usertable')->result_array();
}

// application/controllers/Your_controller.php

public function editClient($user_id) {
    // 加载模型
    $this->load->model('Your_model'); 

    // 获取当前用户的主表信息 (如果需要)
    $data['client_details'] = $this->db->get_where('user_table', array('id' => $user_id))->row_array();

    // 获取所有已分配给该用户的 admin_id 列表
    $data['selected_admin_ids'] = $this->Your_model->getAssignedAdminIds($user_id);

    // 获取所有可供选择的系统用户
    $data['system_users'] = $this->Your_model->getAllSystemUsers();

    // 加载视图
    $this->load->view('your_edit_view', $data);
}

<!-- application/views/your_edit_view.php -->

<div class="form-group col-md-6">
    <label for="admin_id"><?php echo get_phrase('Assign User'); ?>
        <span class="text-danger">*</span></label>
    <select class="form-control selectpicker" name="admin_idd[]" id="admin_id"
        placeholder="Assign User" required multiple>

        <option value="" hidden><?php echo get_phrase('Select User'); ?></option>
        <?php
        // $system_users 包含所有可用的系统用户 (来自控制器传递的 $data['system_users'])
        // $selected_admin_ids 包含当前记录已选的 admin_id 数组 (来自控制器传递的 $data['selected_admin_ids'])

        foreach($system_users as $row2):
            // 检查当前选项的 admin_id 是否在已选列表中
            $isSelected = in_array($row2['admin_id'], $selected_admin_ids);
        ?>
            <option value="<?php echo $row2['admin_id'];?>" <?php echo $isSelected ? 'selected' : ''; ?>>
                <?php echo $row2['first_name'];?>
            </option>
        <?php
        endforeach;
        ?>
    </select>
</div>