以select选项为主的Ajax分页在codeigniter中不起作用

Question

这是我的选择选项：

<select id="slc_action" class="form-control" style="margin:0;">
    <option value="0"> Select Activity</option>
    <?php foreach($admin_action as $row){
        echo "<option  value='" . $row['action_id'] . "''>" . $row["event"] . "</option>";
     }?>
</select>

这是我的jquery：

<script>
$(document).ready(function() {
    $("#slc_action").change(function(){
        var action_id = $("#slc_action").val();
        jQuery.ajax({
            type: 'POST',
            url: '/ADMIN/ajax/activity_list',
            dataType: 'html',
            data: {action_id: action_id
            },
            success: function(res) {
                if (res)
                {
                    $("#activity_list").html(res);
                }
            }
        });
    });
});
</script>

这是我的ajax调用控制器：

function activity_list(){

    $action_id = $this->input->get("action_id");
    $config = array();
    $config["base_url"] = "/ADMIN/Account/admin_activity/";
    $config["total_rows"] = $this->Ajax_m->m_count_activity($action_id);
    $config["per_page"] = 10;
    $config["uri_segment"] = 5;

    //config for bootstrap pagination class integration
    $config['full_tag_open'] = '<ul class="pagination">';
    $config['full_tag_close'] = '</ul>';
    $config['first_link'] = false;
    $config['last_link'] = false;
    $config['first_tag_open'] = '<li>';
    $config['first_tag_close'] = '</li>';
    $config['prev_link'] = '&laquo';
    $config['prev_tag_open'] = '<li class="prev">';
    $config['prev_tag_close'] = '</li>';
    $config['next_link'] = '&raquo';
    $config['next_tag_open'] = '<li>';
    $config['next_tag_close'] = '</li>';
    $config['last_tag_open'] = '<li>';
    $config['last_tag_close'] = '</li>';
    $config['cur_tag_open'] = '<li class="active"><a href="#">';
    $config['cur_tag_close'] = '</a></li>';
    $config['num_tag_open'] = '<li>';
    $config['num_tag_close'] = '</li>';

    $config['num_links'] = 10;

    $this->pagination->initialize($config);
    $page = ($this->uri->segment(5)) ? $this->uri->segment(5) : 0;
    $data["no"]=$page;
    $data["activity_list"] = $this->Ajax_m->m_get_activity($action_id,$config["per_page"], $page);
    $data["links"] = $this->pagination->create_links();
    $this->load->view("/ADMIN/".country_code."/Admin_activity_list",$data);
}

这对于ajax模型：

function m_get_activity($action_id,$limit,$start){
    $this->db->limit($limit,$start);
    $this->db->select("admin_name,action_id,querylog,time,");
    $this->db->from("uhd_admin_activity");
    $this->db->where("action_id=",$action_id);
    $query = $this->db->get();
    return $query->result_array();
}

function m_count_activity($action_id){
    if($action_id != null) $this->db->where("action_id = '$action_id'" , NULL, FALSE);

    $this->db->from("uhd_admin_activity");

    return $this->db->count_all_results();
}

在我的第一个视图中，如果我选择该选项，它将显示基于所选选项的活动列表。

我把分页的ajaxurl，比如果我点击分页，我所有的activity_list将消失，选择的选项将返回到选择活动。

伙计们，你们知道怎么解决这个问题吗？

Answer 1

试试下面的方法。

在控制器中，使用活动id创建分页基本url

$action_id = $this->input->post("action_id"); //please use post method as your are posting data using POST in your ajax call
 $config = array();
 $config["base_url"] = "/ADMIN/Account/admin_activity/".$action_id;

现在，在admin_activity函数中添加接收操作id的参数

function admin_activity($activity_id,$offset) {
    //here $offset will be your page segment no.
   //pass the activity argument along with your view data
   $data['post_activity_id] = $activity_id;
   $this->load->view('view_name',$data);
}

进入你的视野

<select id="slc_action" class="form-control" style="margin:0;">
    <option value="0"> Select Activity</option>
    <?php foreach($admin_action as $row){
        if(isset($post_activity_id) && $post_activity_id == $row['action_id']) {
            echo "<option selected="selected" value='". $row['action_id'] . "''>" . $row["event"] . "</option>";
        } else {
            echo "<option value='" . $row['action_id'] . "''>" . $row["event"] . "</option>";
        }
     }?>
</select>

所以，基本上你只需要创建你的分页与action_id，并在控制器函数中接收到该id后，将其与视图数据一起发送回来，并检查输入控制器是否设置，而不是选择该值。