<?php
$con = mysqli_connect("localhost","root","","datatable");
$query = mysqli_query($con, "SELECT * FROM products");
?>
<!DOCTYPE html>
<html>
<head>
<link type="text/css" rel="stylesheet" href="media/css/jquery.dataTables.min.css">
<link type="text/css" rel="stylesheet" href="media/css/jquery.dataTables_themeroller">
<script type="text/javascript" src="media/js/jquery.js"></script>
<script type="text/javascript" src="media/js/jquery.dataTables.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$('#datatables').dataTable({
"scrollY": "300px",
"scrollCollapse": true,
"paging": false
});
});
</script>
<title>Datatable</title>
</head>
<body>
<table id="datatables" class="display">
<thead>
<tr>
<th>Description</th>
<th>Category</th>
<th>Cost</th>
<th>Price</th>
<th>Critical Level</th>
</tr>
</thead>
<tbody>
<?php
while($row = mysqli_fetch_array($query)){
?>
<tr>
<td><?php echo $row['description']; ?></td>
<td><?php echo $row['category']; ?></td>
<td><?php echo $row['cost']; ?></td>
<td><?php echo $row['price']; ?></td>
<td><?php echo $row['critical_level']; ?></td>
</tr>
<?php
}
?>
</tbody>
</table>
</body>
</html>
jQuery Datatables.zip
需积分: 5 49 浏览量
2023-11-08
19:45:57
上传
评论
收藏 257KB ZIP 举报
jQuery Datatables.zip （22个子文件） 
datatable sql 
datatable.sql 2KB media js jquery.dataTables.min.js 76KB jquery.js 94KB jquery.dataTables.js 419KB css jquery.dataTables.css 17KB jquery.dataTables_themeroller.css 12KB jquery.dataTables.min.css 15KB images 
sort_asc_disabled.png 3KB sort_desc_disabled.png 1KB forward_disabled.png 1KB back_enabled.png 1KB forward_enabled_hover.png 1KB back_disabled.png 1KB Sorting icons.psd 27KB favicon.ico 894B sort_asc.png 1KB forward_enabled.png 1KB sort_desc.png 1KB sort_both.png 1KB back_enabled_hover.png 1KB
screenshot.jpg 93KB index.php 1KB资源评论
