数据库默认端口:3306
获取上一条执行的SQl语句:Db::getLastSql();
PHP给HTML赋值:
创建一个控制器,然后查询数据库获取所有数据:
use think\Controller;
use think\Db;
class Demo extends Controller
{
$data=Db::query('select * from student');
$this->assign('data',$data);
$num='aaaaa';
$this->assign('num',$num);
return view();
}
下面是html代码
我们先打印一下$data的值
<?php
var_dump($data);
?>
结果
array(6) { [0]=> array(8) { ["uid"]=> string(4) "1020" ["name"]=> string(12) "小西康路" ["studentid"]=> int(123456) ["sex"]=> string(3) "女" ["class"]=> string(8) "3年2班" ["polity"]=> string(6) "团员" ["birthday"]=> string(10) "2017-10-28" ["phone"]=> int(2147483647) } [1]=> array(8) { ["uid"]=> string(4) "1000" ["name"]=> string(9) "管理员" ["studentid"]=> int(123456) ["sex"]=> string(3) "男" ["class"]=> string(9) "教务处" ["polity"]=> string(6) "党员" ["birthday"]=> string(9) "2017-10-8" ["phone"]=> int(2147483647) } [2]=> array(8) { ["uid"]=> string(4) "1034" ["name"]=> string(6) "林二" ["studentid"]=> int(115555) ["sex"]=> string(3) "男" ["class"]=> string(4) "2班" ["polity"]=> string(6) "团员" ["birthday"]=> string(8) "1996-2-9" ["phone"]=> int(1111111111) } [3]=> array(8) { ["uid"]=> string(4) "1037" ["name"]=> string(6) "林三" ["studentid"]=> int(88) ["sex"]=> string(3) "男" ["class"]=> string(4) "1班" ["polity"]=> string(6) "团员" ["birthday"]=> string(8) "1995-4-9" ["phone"]=> int(1523625010) } [4]=> array(8) { ["uid"]=> string(4) "1048" ["name"]=> string(3) "林" ["studentid"]=> int(25) ["sex"]=> string(3) "男" ["class"]=> string(1) "1" ["polity"]=> string(6) "团员" ["birthday"]=> string(9) "1999-4-18" ["phone"]=> int(1565952012) } [5]=> array(8) { ["uid"]=> string(4) "1049" ["name"]=> string(6) "罗一" ["studentid"]=> int(19) ["sex"]=> string(3) "男" ["class"]=> string(1) "1" ["polity"]=> string(6) "团员" ["birthday"]=> string(9) "1998-4-18" ["phone"]=> int(1565950213) } }
我们给页面赋值
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>页面赋值</title>
</head>
<body>
<table style="border: 1px solid red">
<tr >
<td>姓名</td>
<td>学号</td>
<td>性别</td>
<td>班级</td>
<td>身份</td>
<td>生日</td>
<td>联系方式</td>
</tr>
<!--volist循环遍历 name 控制器传值的key,标志, value获取的值-->
{volist name='data' id='value'}
<tr>
<!--{{$value.name}} 值里面包含的字段-->
<td>{$value.name}</td>
<td>{$value.studentid}</td>
<td>{$value.sex}</td>
<td>{$value.class}</td>
<td>{$value.polity}</td>
<td>{$value.birthday}</td>
<td>{$value.birthday}</td>
</tr>
{/volist}
</table>
<h2>{$num}</h2> //单个数据赋值
</body>
</html>