DataTables警告:table id = big_table - 第0行请求的未知参数'0'。 [英] DataTables warning: table id=big_table - Requested unknown parameter '0' for row 0.
问题描述
在使用jquery datatables插件和代码标识符的同时,尝试遵循(大致) http://www.ahmed-samy.com/php-codeigniter-full-featrued-jquery-datatables-part-1/ 。我收到以下错误:
I'm working with the jquery datatables plugin and codeigniter , while trying to follow (roughly ) http://www.ahmed-samy.com/php-codeigniter-full-featrued-jquery-datatables-part-1/. I am getting the following error:
DataTables warning: table id=big_table - Requested unknown parameter '0' for row 0. For more information about this error, please see http://datatables.net/tn/4
在firebug没有错误,并返回以下JSON:
In firebug there are no errors and the following JSON is returned:
{"draw":0,"recordsTotal":3,"recordsFiltered":3,"data":[{"id":"2","message_id":"<047d7bf1665e40753c04fd394d72@google.com>","subject":"Delivery Status Notification (Failure)","date":"2014-07-02 19:34:17"},{"id":"3","message_id":"<ad86a2fb8673b8a6.14044068.406744.354605.en-US.b5df177c74ea@google.com>","subject":"Flying the red, white and blue on YouTube","date":"2014-07-03 19:01:21"},{"id":"4","message_id":"<047d7bf1665e04fd640c89@google.com>","subject":"Delivery Status Notification (Failure)","date":"2014-07-04 22:34:16"
我注意到,尽管记录数(3)是正确。该表本身是空的。
i notice that the draw is 0 even though the number of records (3) is correct. The table itself its empty.
我如何解决这个问题?
我的控制器:
函数index()
{
function index() {
//set table id in table open tag
$tmpl = array('table_open' => '<table id="big_table" border="1" cellpadding="2" cellspacing="1" class="mytable">');
$this->table->set_template($tmpl);
$this->table->set_heading("id,message_id,subject,date");
$this->load->view('serversidetestview');
}
//function to handle callbacks
function datatable()
{
$this->datatables->select("id,message_id,subject,date")->from('imap');
echo $this->datatables->generate();
}
我的观点:
<html>
<head>
<base href="<?=base_url();?>">
<!-- DataTables CSS -->
<link rel="stylesheet" type="text/css" href="http://cdn.datatables.net/1.10.1/css/jquery.dataTables.css">
<!-- jQuery -->
<script type="text/javascript" charset="utf8" src="http://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.8.2.min.js"></script>
<!-- DataTables -->
<script type="text/javascript" charset="utf8" src="http://cdn.datatables.net/1.10.1/js/jquery.dataTables.min.js"></script>
</head>
<body>
<h1>Subscriber management</h1>
<?php echo $this->table->generate(); ?>
</div>
<script type="text/javascript">
$(document).ready(function () {
var oTable = $('#big_table').dataTable({
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": 'datatable_controller/datatable',
"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>
</body>
</html>
推荐答案
从示例库中复制Datatables.php代码
( http://www.ahmed-samy.com/demos /sources/tutorial_datatables.zip )
到您的库目录,而不是直接下载它。我认为最新的下载中可能会出现错误。我有完全相同的问题。
Copy the Datatables.php from the libraries of the sample code (http://www.ahmed-samy.com/demos/sources/tutorial_datatables.zip) into your libraries directory instead of downloading it directly. I think there might be a bug in the latest download. I had the exact same issue.
这篇关于DataTables警告:table id = big_table - 第0行请求的未知参数'0'。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!