单号提交人时间目前状态操作
$conn = mysql_connect("127.0.0.1","jxc1","jxc1_sql123");
if (!$conn) {echo "数据库链接错误".mysql_error();}
mysql_select_db("jxc1",$conn);
mysql_query("set names 'utf-8'");
$result = mysql_query("SELECT * FROM shenlingdan");
while ($row = mysql_fetch_array($result)){
?>
<?php echo $row['fid']; ?><?php echo $row['name']; ?><?php echo $row['time']; ?><?phpif ($row['status'] == 0){
echo "审 核 中";
}
elseif($row['status'] == 1){
echo "已 通 过";
}
elseif($row['status'] == 2){
echo "已 拒 绝";
}
?>
}
?>
$(document).ready(function() {
$('#jtable').dataTable({"bPaginate": false,
"oLanguage": {
"sLengthMenu": "显示 _MENU_ 条每页",
"sZeroRecords": "什么都没有找到 - 很抱歉",
"sInfo": "总共 _TOTAL_ , 显示 _START_ 至 _END_ 条",
"sSearch": "搜索",
"sInfoEmpty": "没有数据!",
"sInfoFiltered": "(过滤自 _MAX_ 条数据)"
}
});
} );