codeigniter and JSON
- by ole
Hello all i having a problem that it only get 1 value in my database and its my title and i want to show content and username from the same table to.
here is my JSON kode
<script type="text/javascript">
$.getJSON(
'ajax/forumThreads',
function(data) {
alert(data[0].overskrift);
alert(data[0].indhold);
}
);
</script>
my controller
<?php
class ajax extends 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']);
}
}
}
my model fle
<?php
class ajax_model extends Model
{
function forumList()
{
$this->db->select('overskrift', 'indhold', 'brugernavn', 'dato');
$this->db->order_by('id', 'desc');
$this->db->limit(5);
$forum_list = $this->db->get('forum_traad');
if($forum_list->num_rows() > 0)
{
return $forum_list->result_array();
} else {
return false;
}
}
}
