thinkphp 6.x 数据库增删改查

忘是亡心i 2022-12-14 03:57 302阅读 0赞

参考：[https://www.kancloud.cn/manual/thinkphp6\_0/1037570][https_www.kancloud.cn_manual_thinkphp6_0_1037570]

[https://www.kancloud.cn/manual/thinkphp6\_0/1037534][https_www.kancloud.cn_manual_thinkphp6_0_1037534]

[https://www.cnblogs.com/yi2105/p/11532215.html][https_www.cnblogs.com_yi2105_p_11532215.html]

1、引用Db

use think\\facade\\Db; //引用Db

2、查询用`query`方法，添加、修改、删除用`execute`方法

/**
         * @NodeAnotation(title="tp6 原生查询")
         */
        public function test1()
        {
            $sql = "SELECT a.id,a.stu_name,a.age,a.sex,b.name AS cname FROM my_student AS a,my_class AS b WHERE a.class_id=b.id AND a.class_id=:class_id ORDER BY a.id DESC";
            $param = ['class_id' => 4];
            $res = Db::query($sql, $param);
            dump($res);//打印查询结果$res
        }
    	
    	/**
         * @NodeAnotation(title="tp6 原生增加")
         */
        public function test2()
        {
            $sql = "insert into my_class(name) values(:name)";
            $param = ['name' => '班级6'];
            $res = Db::execute($sql, $param);
            dump($res);//打印查询结果$res
        }
    	/**
         * @NodeAnotation(title="tp6 原生修改")
         */
        public function test3()
        {
            $sql = "update my_class set name=:name where id=:id";
            $param = ['id'=>6,'name' => '班级666'];
            $res = Db::execute($sql, $param);
            dump($res);//打印查询结果$res
        }
    	/**
         * @NodeAnotation(title="tp6 原生删除")
         */
        public function test4()
        {
            $sql = "delete from my_class where id=:id";
            $param = ['id'=>6];
            $res = Db::execute($sql, $param);
            dump($res);//打印查询结果$res
        }

3、添加数据获取新增记录id用方法insertGetId

/**
         * @NodeAnotation(title="tp6 添加数据")
         */
        public function test5()
        {
            $data = ['name' => '软班33'];
            $res = Db::name('class')->insertGetId($data);
            dump($res);//打印查询结果$res
        }

[https_www.kancloud.cn_manual_thinkphp6_0_1037570]: https://www.kancloud.cn/manual/thinkphp6_0/1037570
[https_www.kancloud.cn_manual_thinkphp6_0_1037534]: https://www.kancloud.cn/manual/thinkphp6_0/1037534
[https_www.cnblogs.com_yi2105_p_11532215.html]: https://www.cnblogs.com/yi2105/p/11532215.html