app/admin/controllerData.php

<?php
namespace app\admin\controller;

use app\BaseController;
use think\Facade\Db;

class Data extends BaseController
{
    public function index()
    {
        return '<h1>PHP 数据库联动</h1>';   
    }

    public function check($table = 'user')
    {
        // 在controller 层直接return，
        // 就会报错 variable type error： array
        // 需用json() 函数返回
        return json(Db::table($table)->where('id', 1)->find());
    }
    // 路由传参：admin/index/reque/id/1
    // url传参：admin/index/reque?id=9
    public function reque($id = 2)
    {
        // TP5访问控制器，不能用return直接返回数组
        $sql = "SELECT `name` FROM `user` WHERE `id`=:id ";
        $map = ['id' => $id];
        $res = Db::query($sql, $map);
        return json($res);
    }
    public function add()
    {
        $data = ['name' => 'Kasay', 'age' => 1500];
        // 返回添加成功的条数的是1
        return Db::name('user')->save($data);
    }

    public function adds()
    {
        $data = [
            ['name' => 'fiaz', 'age' => 23],
            ['name' => 'build', 'age' => 56],
            ['name' => 'zio', 'age' => 123]
        ];
        return Db::name('user')->insertAll($data);
    }
    public function updata()
    {
        Db::name('user')
            ->save(['id' => 1, 'name' => 'thinkphp']);
    }
    public function updata2()
    {
        Db::name('user')
            ->save(['id' => 1, 'name' => 'thinkphp']);
    }

}