Append HTML Table To Json Response In Codeigniter

Question

Hi I Want to draw a table with json data which is my code I am getting correct json response but not able to draw a table in popup, Which is my Code

$(document).on('click','.details', function(){
var student_id = $(this).attr("id");
//alert(Id);
    $.ajax({
      url: "<?php echo base_url(user/details);?>",
      type: "post",
      data: {id:id},
      success: function(data)
            { 
    $.each(json, function (i,data) {
        $("#fees_table").append( "<tr><td>" + data.name + "</td><td>" + data.first_name + "</td><td>" + data.last_name + "</td><td>" + data.user_name + "</td></tr>");
    });

            }
    });
 } );

Which is my controller And My model is

public function getStudentFees($student_id)
{
    $query=$this->db->select('name,first_name,last_name,user_name')->from('users');
    $result= $query->result_array();
    //echo $this->db->last_query();die();
    return $result;
}

Rejoanul Alam · Accepted Answer · 2016-06-28 17:56:52Z

1

Change this

$.each(json, function (i,data) {
    //....
});

as

var data = $.parseJSON(data);
$.each(data, function (i) {
    $("#fees_table").append( "<tr><td>" + data[i].name + "</td><td>" + data[i].first_name + "</td><td>" + data[i].last_name + "</td><td>" + data[i].user_name + "</td></tr>");
});

If you getting correct response then it should work

edited Jun 28, 2016 at 17:56

answered Jun 28, 2016 at 16:56

Rejoanul Alam

5,4004 gold badges42 silver badges71 bronze badges

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

9 Comments

ohmygood Over a year ago

Thank you @Rejoanul Alam, But I am getting Uncaught Reference Error: json is not defined

ohmygood Over a year ago

Uncaught TypeError: Cannot use 'in' operator to search for '516' in

Rejoanul Alam Over a year ago

then you should parse your json data, as you are getting json string. check my edited answer

ohmygood Over a year ago

excellent @rejoanul, Now Table is coming but json data also showing correct in console but In table the fields are showing undefined. Anything wrong??

Rejoanul Alam Over a year ago

then show your console.log(data) values & details method code of user controller

|

FrankS101 · Accepted Answer · 2018-11-07 12:46:32Z

0

add dataType to your ajax options

 $.ajax({
      url: "<?php echo base_url(user/details);?>",
      type: "post",
      data: {id:id},
dataType: "json", // convert response data to json 
      success: function(data)
            { 
    $.each(json, function (i,data) {
        $("#fees_table").append( "<tr><td>" + data.name + "</td><td>" + data.first_name + "</td><td>" + data.last_name + "</td><td>" + data.user_name + "</td></tr>");
    });

            }
    });

edited Nov 7, 2018 at 12:46

FrankS101

2,1556 gold badges27 silver badges42 bronze badges

answered Nov 7, 2018 at 11:46

Phuti Semenya

142 bronze badges

Collectives™ on Stack Overflow

Append HTML Table To Json Response In Codeigniter

2 Answers 2

9 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related