html端代码
<!DOCTYPE html>
<html lang="en">
<head>
<!--第一步:引入Javascript / CSS (CDN)-->
<!-- DataTables CSS -->
<link rel="stylesheet" type="text/css" href="http://cdn.datatables.net/1.10.15/css/jquery.dataTables.css">
<!-- jQuery -->
<script type="text/javascript" charset="utf8" src="http://code.jquery.com/jquery-1.10.2.min.js"></script>
<!-- DataTables -->
<script type="text/javascript" charset="utf8" src="http://cdn.datatables.net/1.10.15/js/jquery.dataTables.js"></script>
<meta charset="UTF-8">
<title>Document</title>
</head>
<body>
<table id="table_id_example" class="display">
<thead>
<tr>
<th>users</th>
<th>nickname</th>
<th>phonenumber</th>
</tr>
</thead>
<tbody align="center">
</tbody>
</table>
</body>
<script>
$(document).ready(function(){
$.ajax({
type:'get',
dataType:'json',
url:"./datatables.php",
success:function(data){ //接收结果后用datatables自带的DataTable函数向表格体填充数据
$('#table_id_example').DataTable({
data: data,
columns: [
{ data: 'id' }, //为每一列表格应该填充的内容指明json的标题,否则datatables找不到这一列要加载的内容
{ data: 'nickname' },
{ data: 'phonenumber' }
]
});
}
})
});
</script>
</html>
php端代码
<?php
header("content-type:text/html;charset=utf-8");
// 执行添加并返回结果
require './config.php';//数据库配置
require './Model.class.php';//Model类文件
$model = new Model('users');
echo json_encode($model->select());//用json_encode函数将查询结果以json格式返回