thinkphp 6.x 数据库增删改查

参考：https://www.kancloud.cn/manual/thinkphp6_0/1037570

           https://www.kancloud.cn/manual/thinkphp6_0/1037534

           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
    }