使用模型框编辑值

i want to edit table row using bootstrap model....when i click on edit button it open up a model box with a name of designttion which i want to edit ..but when when i click on button only modalbox show but no record is shown in it... please solve my problem

Controller

public function edit_desig(){
        $this->load->model('designation_model');
        $this->designation_model->edit_designation($id);
    }

model

public function edit_designation($id){
        $query=$this->db->get_where('designation',array('desig_id'=>$id));
        return $query->result();
    }

My view

<div id="myModal" class="modal fade" id="editdesigymodal" role="dialog">
            <div class="modal-dialog">

            <!-- Modal content-->
                <div class="modal-content">
                    <div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal">&times;</button>
                        <h4 class="modal-title">Edit Designation</h4>
                    </div>
                    <div class="modal-body">
                        <input id="editdesignnation" type="text" class="form-control" placeholder="Enter here" />
                    </div>
                    <div class="modal-footer">
                        <button type="button" onclick="edit_designation()" class="btn btn-success" data-dismiss="modal">Edit</button>
                        <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                    </div>
                </div>

            </div>
        </div>

            <div class="container">
                <div class="row">
                    <div class="col-lg-12 col-sm-12">
                        <table class="table table-bordered table-striped">
                            <thead>
                                 <tr>
                                    <th>#</th>
                                    <th>Designations</th>
                                 </tr>
                            </thead>
                            <tbody>

                                <?php  print_r($designation); $i=1;foreach($designation as $desig): ?>
                                      <tr>
                                           <td><?php echo $i; ?></td>

                                           <td><?php echo $desig['name']; ?></td>

                                            <td><a href="<?php echo base_url('index.php/designation/delete_designation/'.$desig['dkey']);?>"><input type="button" value="Delete" class="btn btn-danger"/></a>
                                            <td class="numeric"><a id= "<?php echo $desig['dkey']; ?>"  onclick="edit_designation('<?php echo  $desig['dkey']; ?>')" data-target="#myModal" data-toggle="modal" href="<?php echo base_url().'index.php/designation/edit_desig'; ?>"><button class="btn blue" type="button">Edit</button>

                                      </tr>
                            <?php $i++;endforeach;?>

You need to pass your query result to your view

Controller

public function edit_desig(){
        $this->load->model('designation_model');
        $designation=$this->designation_model->edit_designation($id);// assing your query result to your variable
        $data['designation'] = designation;// pas your variavle to data arrray
        $this->load->view('view_name', $data);// load your view with array
    }

As per your view code you need to fetch data in array form in your model

Models

public function edit_designation($id){
        $query=$this->db->get_where('designation',array('desig_id'=>$id));
        return $query->result_array();// change this to array
    }