[Webman] 使用MySQL

官方文档

1.安装包(用的是laravel同一个)

composer require -W illuminate/database illuminate/pagination illuminate/events symfony/var-dumper

2.数据库配置

// config/database.php
return [
    // 默认数据库
    'default' => 'mysql',

    // 各种数据库配置
    'connections' => [
        'mysql' => [
            'driver'      => 'mysql',
            'host'        => '127.0.0.1',
            'port'        => 3306,
            'database'    => 'demo',
            'username'    => 'demo',
            'password'    => 'demo',
            'unix_socket' => '',
            'charset'     => 'utf8',
            'collation'   => 'utf8_unicode_ci',
            'prefix'      => 'wm_',
            'strict'      => true,
            'engine'      => null,
            'options' => [
                \PDO::ATTR_TIMEOUT => 3
            ]
        ],
    ],
];

3.使用, 记得重启cli

// http://IP:8787/index/json

namespace app\controller;
use support\Request;
use support\Db;

class IndexController
{
    public function json(Request $request)
    {
        $id = $request->get('id');
        $list = Db::table('demo')->where('id', '>', 1)->get()->toArray();
        return json(['code' => 0, 'msg' => 'ok', 'data' => $list]);
    }

}