codeigniter JSON

Question

Hello im using codeigniter and then i echo out my output from the database in my controller and then in my view file i do this:

<script type="text/javascript">
$.getJSON('ajax/forumThreads', function(data) {          
alert(data.overskrift);
});

</script>

but it dont show anything :S

my model file

function forumList()
{
    $this->db->select('overskrift', 'indhold', 'brugernavn', 'dato');
    $this->db->order_by('id', 'desc');
    $forum_list = $this->db->get('forum_traad');

    if($forum_list->num_rows() > 0)
    {
        return $forum_list->result();
    } else {
        return false;
    }
}

my controller

function forumThreads() {

    $this->load->model('ajax_model');
    $data['forum_list'] = $this->ajax_model->forumList();

    if ($data['forum_list'] === true)
    {
        echo json_encode($data['forum_list']);
        $this->load->view('includes/footer', $data); 
    } else {
        return  false;
    }


}

a good way to test for me has been to just try and visit the controller function "in the wild" just typing it in the browser and see what the output is, just so you know you are getting the output you expect. — jondavidjohn, Jan 06 '11 at 16:17
Remove `$this->load->view('includes/footer', $data);` after the `json_encode`. JSON data cannot have anything before or after it. — gen_Eric, Jan 06 '11 at 16:19

gen_Eric · Answer 1 · 2011-01-06T16:39:58.717

3

$forum_list->result() returns an array of results.

If you only want 1 row, use $forum_list->row(), otherwise in the javascript, you'll need to loop through all the rows.

$.each(data, function(i,v){
  alert(v.overskrift);
});

EDIT: When outputting JSON, do not print anything before or after. You need to remove $this->load->view('includes/footer', $data); after the json_encode. Also, controllers don't return anything.

EDIT 2: Replace if ($data['forum_list'] === true) with if ($data['forum_list'] !== false). The === compares type, and an array is not a boolean.

edited Jan 06 '11 at 16:39

answered Jan 06 '11 at 16:12

gen_Eric

223,194
41
299
337

okay i have done all that you said and it output something if i browse to the controller, but it alert: undefined :S – ole Jan 06 '11 at 18:27
@ole: What does the controller output? – gen_Eric Jan 06 '11 at 19:06

score 0 · Answer 2 · answered Jan 06 '11 at 16:38

Model:

function forumList()
{
    $this->db->select('overskrift', 'indhold', 'brugernavn', 'dato');
    $this->db->order_by('id', 'desc');
    $forum_list = $this->db->get('forum_traad');

    if($forum_list->num_rows() > 0)
    {
        return $forum_list->result_array();
    } else {
        return false;
    }
}

Controller:

function forumThreads() {

    $this->load->model('ajax_model');
    $data['forum_list'] = $this->ajax_model->forumList();

    if ($data['forum_list'] !== false) {
        echo json_encode($data['forum_list']);
    }
}

score 0 · Answer 3 · answered Jan 06 '11 at 21:03

0

Try this:

//works only with php 5.3
echo json_encode($data['forum_list'], JSON_FORCE_OBJECT);

answered Jan 06 '11 at 21:03

Diablo

3,378
1
22
28

codeigniter JSON

3 Answers3

Linked