用thinkphp执行原生sql
时间：2021-07-01 10:21:17
帮助过：2人阅读
use Think\Controller;
use Think\Model;
class Demo2Controller
extends Controller {
//insert 操作
public function test1(){
$Model =
new Model();
$sql = "insert into city(cityname,province,citydesc) values(‘石家庄‘,‘河北省‘,‘河北省城市‘)"
;
$Model->execute(
$sql);
echo "insert 操作"
;
}
//delete 操作
public function test2(){
$Model =
new Model();
$sql = "delete from city where cityname=‘石家庄‘"
;
$Model->execute(
$sql);
echo "delete 操作"
;
}
// update 操作
public function test3(){
$Model =
new Model();
$sql = "update city set citydesc=‘河北省省会‘ where cityname=‘石家庄‘"
;
$Model->execute(
$sql);
echo "update 操作"
;
}
// select 操作
public function test4(){
$Model =
new Model();
$sql = "select * from city order by id asc"
;
$list =
$Model->query(
$sql);
$this->assign(‘list‘,
$list);
$this->
display();
}
}
select 操作对应的View页面：
test4.html
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>test3</title>
</head>
<body>
<table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td>序号</td>
<td>城市</td>
<td>省会</td>
<td>描述</td>
</tr>
<foreach name="list" item="item" key="index">
<tr>
<td>{$index+1}</td>
<td>{$item.cityname}</td>
<td>{$item.province}</td>
<td>{$item.citydesc}</td>
</tr>
</foreach>
</table>
</body>
</html>
用thinkphp执行原生sql
标签：
