1. 封装数据库查询函数
//取数据库数据
function sql_get_data($sql)
{
???$conn=sql_conn();
???$query = mysqli_query($conn,$sql);
???if(!$query)
???{
???????return false;
???}
???$result =array();
???while ($row = mysqli_fetch_assoc($query))
???{
???????$result[] = $row;
???}
???mysqli_close($conn);
???return $result;
}
2.显示数据
<?php
require_once (‘../config.php‘);
require_once(‘../functions.php‘);
check_login();
$category_data = sql_get_data(‘select * from ft_category‘);
?>
//模板
<?php foreach ($category_data as $c) { ?>
<tr>
???<td align="center"><?php echo ?$c[‘id‘];?></td>
???<td ><?php echo ?$c[‘catename‘];?></td>
???<td ><?php echo ?$c[‘slug‘];?></td>
???<td align="center">
???????<a href="/admin/user/edit/id/6.html" class="btn btn-primary btn-sm shiny">
???????????<i class="fa fa-edit"></i> 编辑
???????</a>
???????<a href="#" onClick="warning(‘确实要删除吗‘, ‘/admin/user/del/id/6.html‘)" class="btn btn-danger btn-sm shiny">
???????????<i class="fa fa-trash-o"></i> 删除
???????</a>
???</td>
</tr>
<?php } ?>PHP7实战开发简单CMS内容管理系统(9)栏目列表获取功能模块
原文地址：https://www.cnblogs.com/zifeiyu2018/p/10529243.html