ThinkPHP6 ?? ?????? ??? ?? ??? ??: ??? ?? ?????? ? ?? ??? ??

???? ??? ???? ???? ?? ?? ???? ?? ???????? ????? ??? ? ?? ??? ????. ?????. ? ??? ???? ?? ThinkPHP6 ?????? ?? ?????? ??? ???? ??? ?? ? ??? ??? ???? ?????? ??? ????? ??? ???? ???? ? ????.

ThinkPHP6??? ?? ?????? ??? ?? ??? ?? ?????. ?? ?? ??(config/database.php)? ?? ?????? ?? ??? ???? ???. ?:

return [
    // 默認數(shù)據(jù)庫連接
    'default' => env('database.default', 'mysql'),
    // 數(shù)據(jù)庫連接列表
    'connections' => [
        // 第一個數(shù)據(jù)庫連接
        'mysql' => [
            'type'            => 'mysql',
            'hostname'        => env('database.hostname', '127.0.0.1'),
            'database'        => 'database1',
            'username'        => env('database.username', 'root'),
            'password'        => env('database.password', ''),
            // 其他配置...
        ],
        // 第二個數(shù)據(jù)庫連接
        'mysql2' => [
            'type'            => 'mysql',
            'hostname'        => env('database.hostname', '127.0.0.1'),
            'database'        => 'database2',
            'username'        => env('database.username', 'root'),
            'password'        => env('database.password', ''),
            // 其他配置...
        ],
    ],
];

? ????? mysql? mysql2?? ? ?? ?????? ??? ?????.

???? ???? ??? ?????? ??? ??? ? ????. ?:

namespace appmodel;

use thinkModel;

class User extends Model
{
    // 使用mysql2數(shù)據(jù)庫連接
    protected $connection = 'mysql2';
}

$connection ??? ???? ??? mysql2 ?????? ??? ????? ??? ? ????.

?? ???????? ??????? ????? ??? ??? ?? ???? ?? ?????. ThinkPHP6 ?????? ??????? ???? ??? ??? ???? ?? ? ?? ??? ?????.

1. ?? ??????

??? ?? ??????? ?? ??? ?? ???? ?? ??????? ????? ????. ?????? ???? ???? ? ??? ??? ? ????. ?:

namespace appmodel;

use thinkModel;

class Order extends Model
{
    // 自動分表
    protected $autoWriteTimestamp = true;
    protected $connection = 'mysql2';
    protected $name = 'order_';

    protected function getCreateatAttr($value)
    {
        return date('Y-m-d H:i:s', $value);
    }

    protected function setCreateatAttr($value)
    {
        return strtotime($value);
    }
}

? ????? mysql2 ?????? ??? ????? Order ??? ???? ??? ?? ???? order_? ?????. ??? ???? ??? ??? Order ??? ??? ? ThinkPHP6? ??? ID? ???? ???? ???? ?? ??????? ????.

2. ??? ??

??? ??? ?? ??? ?? ???? ??? ??????? ?? ???? ????? ????. ??? ???? ???? ? ??? ??? ? ????. ?:

namespace appmodel;

use thinkModel;

class Order extends Model
{
    // 自動分表
    protected $autoWriteTimestamp = true;
    protected $connection = 'mysql2';
    protected $name = 'order';

    protected function partitionTableName($tableName, $data)
    {
        // 根據(jù)用戶id取模進行分表
        $userId = $data['user_id'];
        $tableSuffix = $userId % 10;
        return $tableName . '_' . $tableSuffix;
    }

    protected function getCreateatAttr($value)
    {
        return date('Y-m-d H:i:s', $value);
    }

    protected function setCreateatAttr($value)
    {
        return strtotime($value);
    }
}

? ????? partitionTableName ???? ?? ????, ???? user_id? ???? ??? ??? ????, ??? ?? ???? ????. ??? ???? ??? ??? Order ??? ??? ? ThinkPHP6? ???? user_id? ?? ???? ??? ???? ?? ???? ?????.

?? ? ?? ??? ?? ??? ?? ??? ?? ???? ?????? ??? ????? ??? ???? ???? ? ????. ??? ?? ???? ?? ?? ??? ?? ?????? ?? ? ??? ???? ???? ??? ???? ?? ? ?? ?? ??? ?? ??? ? ????.

??:

? ???? ThinkPHP6 ?????? ?? ?????? ??? ??? ?????? ? ??? ?? ?? ??? ??? ?????. ?? ??? ???? ?? ?? ?????? ?? ? ??? ?? ??? ?????? ???? ??????? ???? ?? ???? ?????? ??? ??? ???? ???? ? ????. ??? ??? ???? ?? ?? ?? ???? ???? ?? ?????? ??? ???? ???? ??? ? ????. ??? ???? ????? ???? ??? ???? ?? ?? ??? ?? ????? ???? ???.

? ??? ThinkPHP6 ?? ?????? ??? ?? ??? ??: ??? ?? ?????? ? ?? ??? ??? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!