how to pass the database fetched values from controller to view page using ajax and json

Question

how to pass the database fetched values from controller to view page using ajax and json.i have a controller and model code but i dont know how to pass values from controller to view page

Controller

public function supplier_get_data(){


        $query = $this->Profile_model->supplier_communication();

        echo json_encode($query);

    }

model

 public function supplier_communication(){
        $sql = $this->db->get('communication');
        $sql = $sql->result_array();
        return $sql;
    }

view page

<div class="left">

                                            <div class="row">
                                                <div class="col-md-1">
                                                    <img src="<?php echo base_url(); ?>images/xxxx.jpg" class="img-circle" width="30px" height="30px"/>
                                                </div>
                                                <div class="col-md-11">

                                                    <div class="left_msg_block">



                                                        <div class="left_messagetext"><a href="#" data-toggle="tooltip" title="time">here i want to display the database values</a></div>
                                                  </div>
                                                </div>
                                            </div>

                                        </div>

Is that the pattern you need <a href="#" data-toggle="tooltip" title="time">value1</a> <a href="#" data-toggle="tooltip" title="time">value2</a> — ubm
– ubm, Commented Jun 3, 2017 at 14:13

ubm · Accepted Answer · 2017-06-05 06:16:30Z

1

This code may helps you Controller function

public function supplier_get_data(){


    $query = $this->Profile_model->supplier_communication();

    echo json_encode($query);

}

Model function

public function supplier_communication(){
    $sql = $this->db->get('communication');
    $sql = $sql->result();
    return $sql;
}

Ajax function

 function loadData()
    {
    $.ajax({
    type:"post",
    url:"<?php echo site_url('controllername/supplier_get_data')?>",
    dataType:"json",
    success:function(data){
      for(i=0;i<data.length;i++){
     alert(data[i].columnanme)
      $('<a href="#" data-toggle="tooltip" title="time">'+data[i].columnanme+'</a>').appendTo('.left_messagetext');
      }
    }

  });
 }

edited Jun 5, 2017 at 6:16

answered Jun 3, 2017 at 14:07

ubm

63611 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

siddu m Over a year ago

in view page i want to fetch the values in this line <div class="left_messagetext"><a href="#" data-toggle="tooltip" title="time">here i want to display the database values</a></div>

Collectives™ on Stack Overflow

how to pass the database fetched values from controller to view page using ajax and json

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related