在第6课,我们学习了使用Db类添加数据,接下来要学习使用Db类查询数据
在Student控制器,添加一个all()方法,实现查询数据
<?php
namespace app\index\controller;
use think\Controller;
use think\Db;
/**
* Class Student
*/
class Student extends Controller
{
public function all()
{
//select方法,返回二维数组
$data = Db::name('student')->select();
$this->assign('student',$data);
return $this->fetch();
}
}
对应的模板文件all.html,代码如下
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport"
content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>学生列表</title>
<link rel="stylesheet" href="__STATIC__/bootstrap-3.3.7-dist/css/bootstrap.css">
<link rel="stylesheet" href="__STATIC__/bootstrapvalidator/css/bootstrapValidator.css">
<script src="__STATIC__/jquery-1.11.3.min.js"></script>
<script src="__STATIC__/bootstrap-3.3.7-dist/js/bootstrap.js"></script>
<script src="__STATIC__/bootstrapvalidator/js/bootstrapValidator.js"></script>
<script src="__STATIC__/bootstrapvalidator/js/language/zh_CN.js"></script>
</head>
<body>
<div class="container">
<div class="row">
<div class="col-md-6 col-md-offset-3">
<table class="table table-bordered">
<tr>
<td>学号</td>
<td>姓名</td>
<td>性别</td>
<td>年龄</td>
</tr>
<{volist name="student" id="row"}>
<tr>
<td>{$row.no}</td>
<td>{$row.name}</td>
<td>{$row.sex}</td>
<td>{$row.age}</td>
</tr>
<{/volist}>
</table>
</div>
</div>
</div>
</body>
</html>
运行结果如下
有关Db类查询的其它用法后面还会用到。