“未定义的表数据”在codeigniter中使用datatables jquery
"Undefined table data" in codeigniter using datatables jquery
我一直在尝试使用带有codeigniter的数据表jquery插件,但仍然没有运气。我是这个 API 的新手。(请不要点燃表,只是数据表jquery插件(。
视图返回:
未定义的表数据
请参阅下面的 MVC:
视图(合并脚本的位置(
<script type="text/javascript">
$(document).ready(function() {
var oTable = $('#big_table').dataTable( {
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": "<?php echo site_url('home/calendarListAll/') ?>",
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"iDisplayStart ":20,
"fnInitComplete": function() {
//oTable.fnAdjustColumnSizing();
},
'fnServerData': function(sSource, aoData, fnCallback)
{
$.ajax
({
'dataType': 'json',
'type' : 'POST',
'url' : sSource,
'data' : aoData,
'success' : fnCallback
});
}
} );
} );
</script>
<html>
<?php echo $this->table->generate(); ?> //this returns "Undefined table data"
</html>
控制器
function __construct()
{
parent::__construct();
$this->load->library('Datatables');
$this->load->library('table');
$this->load->database();
$this->load->helper('url');
$this->load->helper('form');
$this->load->helper('html');
}
public function calendarListAll()
{
$this->load->model('counselor');
$result = $this->counselor->getCalendar();
echo $this->datatables->generate($result);
}
型
function getCalendar() // get referred_appointments
{
$counselor_id = $this->session->userdata('counselor_id');
$query = $this->db->select ('s.first_name as student_fname, s.last_name as student_lname, s.middle_name as student_mname, e.first_name, e.last_name, e.middle_name, re.*, r.student_id, i.*, e.*')
->from ('referral as r, student_course_record as scr, curriculum as c, referred_appointment as re, degree as d, course as cc, counselor as ccc, issue as i, student as s, employee as e')
->where ('r.student_id = scr.student_id')
->where ('scr.curr_id = c.curr_id')
->where ('c.degree_id = d.degree_id')
->where ('d.course_id = cc.course_id')
->where ('cc.counselor_id = ccc.counselor_id')
->where ('r.issue_id = i.issue_id')
->where ('r.student_id = s.student_id')
->where ('re.referral_id = r.referral_id')
->where ('r.employee_id = e.employee_id')
->where ('ccc.counselor_id', $counselor_id)
->where ('re.status != "C"');
$ret = $query->get()->result();
return $ret;
}
使用可能对您有所帮助 CI 帮助
$tmpl = array ('table_open' => '<table id="big_table">');
$this->table->set_template($tmpl);
忘记在生成中传递数据$this>表>生成($records(;
相关文章:
- Jquery Datatables错误:无效的JSON基元:draw
- JQuery Datatables将复选框设置为选中
- DataTables合并了两个独立表中的jQuery/Javascript函数
- jQuery Datatables:单个列搜索不起作用
- jQuery Datatables-从搜索中只返回表中的前5行
- jquery中DataTables插件中的排序不起作用
- jQuery Datatables:单击一列时对另一列进行排序
- Javascript/JQuery for Datatables
- jQuery dataTables基于类型的列筛选不起作用?Img alt过滤器/排序
- 等效于mRender,基于Jquery Datatables中的底层数据进行排序
- Jquery DataTables 不适用于使用 javascript 追加 html
- jQuery DataTables页面刷新
- jQuery DataTables排序不起作用
- Datatables, jquery, title not showing
- dataTables (jquery) 按两列搜索
- DataTables JQuery & filtering
- “未定义的表数据”在codeigniter中使用datatables jquery
- 如何使用DataTables jQuery插件从BD中读取blob
- Datatables Jquery Ajax
- 使用Datatables jQuery插件改进更新DOM的性能