我使用Jtable来预订活动。结合PHP, MySQL。我的问题是,有没有办法每10秒重载一个列。确切地说,是这样的:
Checkbox ID Event Reservations
+ 4 ev1 22
- 5 ev2 19
我希望每10秒重新加载一次reservation列,以便登录的用户可以看到更改。现在我得到了它的工作与重新加载整个表,但这不是我真正需要的,因为每个用户只能预订9个事件,我需要有复选框在左侧。重新加载整个表后,我的复选框没有按预期工作。那么,有没有一种方法可以只重载一个列呢?我现在的代码是:
window.setInterval(function(){
$('#Events').jtable('reload');
}, 10000);
我找到了一个解决这个问题的方法:
首先在JS中像这样创建一个新字段:
test: {
title: 'test',
display: function (data) {
var $div = $('<div id="test"">'+data.record.id+'</div>');
return $div;
}
},
然后创建一个每10秒运行一次的函数,并发出一个AJAX请求:
function UpdateRes(){
$.ajax({
url: 'Actions.php?action=update',
type: 'post',
data: '&kiu='+$kiu,
}).success(function(data) {
var jsondata = JSON.parse(data);
$.each(jsondata.Records, function(i, item) {
$('.jtable tr.jtable-data-row').each(function(){
if($(this).attr('data-record-key')==item.id){
$(this).find('div').html( item.reservations );
}
})
});
});
}
window.setInterval(function(){
UpdateRes();
}, 10000);
让你的JSON响应看起来像这样:
{"Result":"OK",
"Records":
[
{"0":"111","id":"111","1":"20","reservations":"20"},
{"0":"127","id":"127","1":"20","reservations":"20"},
{"0":"133","id":"133","1":"20","reservations":"20"},
{"0":"134","id":"134","1":"20","reservations":"20"},
{"0":"135","id":"135","1":"20","reservations":"20"},
{"0":"326","id":"326","1":"20","reservations":"20"}
]}
最后在Actions.php中执行try catch:
else if($_GET["action"] == "update")
{
//Get records from database
$result8 = mysqli_query($con,
"SELECT l.id,(l.max-l.reserviert) as reservations
FROM td_res l WHERE
l.kiu='" . mysqli_real_escape_string($con,$_POST["kiu"]) . "';");
//Add all records to an array
$rows8 = array();
while($row8 = mysqli_fetch_array($result8))
{
$rows8[] = $row8;
}
//Return result to jTable
$jTableResult = array();
$jTableResult['Result'] = "OK";
$jTableResult['Records'] = $rows8;
print json_encode($jTableResult);
}