2.5 Laravel Admin配置多个数据库

# 表结构
# 图片分类表

CREATE TABLE `ph_images_category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(11) DEFAULT '0' COMMENT '父级id，0为一级分类',
  `name` varchar(20) DEFAULT NULL COMMENT '分类名称',
  `cover_url` varchar(255) DEFAULT NULL COMMENT '分类封面图片',
  `sort` smallint(5) DEFAULT '100' COMMENT '分类排序 越小越靠前',
  `created_at` timestamp NULL DEFAULT NULL COMMENT '添加时间',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT '修改时间',
  `deleted_at` timestamp NULL DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='图片分类表';

 

 

1、配置.env文件

# 添加配置参数
DB_HOST_API=xxxx
DB_PORT_API=3306
DB_DATABASE_API=xxx
DB_USERNAME_API=xxx
DB_PASSWORD_API=xxx
DB_PREFIX_API=xxx

 

2、配置database.php文件

/config/database.php

'mysql' => [
    xxx
],
# 配置数据库2连接参数
'mysql_api' => [
    'driver' => 'mysql',
    'url' => env('DATABASE_URL'),
    'host' => env('DB_HOST_API', ''),
    'port' => env('DB_PORT_API', '3306'),
    'database' => env('DB_DATABASE_API', ''),
    'username' => env('DB_USERNAME_API', ''),
    'password' => env('DB_PASSWORD_API', ''),
    'unix_socket' => env('DB_SOCKET', ''),
    'charset' => 'utf8mb4',
    'collation' => 'utf8mb4_unicode_ci',
    'prefix' => env('DB_PREFIX_API', ''),
    'prefix_indexes' => true,
    'strict' => true,
    'engine' => null,
    'options' => extension_loaded('pdo_mysql') ? array_filter([
        PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
    ]) : [],
],

 

3、新建模型

# 控制台运行
php artisan make:model ImagesCategory


# 模型文件修改如下
<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
use DateTimeInterface;
class ImagesCategory extends Model
{
    use HasFactory;
    use SoftDeletes;
    // 数据库 mysql_api 中的表
    protected $connection = 'mysql_api';
    protected $table = "images_category";
    /**
     * 为数组 / JSON 序列化准备日期。
     *
     * @param  \DateTimeInterface  $date
     * @return string
     */
    protected function serializeDate(DateTimeInterface $date)
    {
        return $date->format('Y-m-d H:i:s');
    }
}

 

4、新建控制器

# 控制台运行
php artisan admin:make ImagesCategoryController --model=App\Models\ImagesCategory


# 控制器修改如下
<?php
namespace App\Admin\Controllers;
use App\Models\ImagesCategory;
use Encore\Admin\Controllers\AdminController;
use Encore\Admin\Form;
use Encore\Admin\Grid;
use Encore\Admin\Show;
class ImagesCategoryController extends AdminController
{
    /**
     * Title for current resource.
     *
     * @var string
     */
    protected $title = '图片分类';
    /**
     * Make a grid builder.
     *
     * @return Grid
     */
    protected function grid()
    {
        $grid = new Grid(new ImagesCategory());
        $grid->column('id', __('Id'));
        $grid->column('pid', __('ImagesCategoryPid'));
        $grid->column('name', __('ImagesCategoryName'));
        $grid->column('cover_url', __('Cover url'))->image('',150,150);
        $grid->column('sort', __('Sort'));
        $grid->column('created_at', __('Created at'));
        $grid->column('updated_at', __('Updated at'));
        $grid->column('deleted_at', __('Deleted at'));
        $grid->filter(function ($filter) {
            // 范围过滤器，调用模型的`onlyTrashed`方法，查询出被软删除的数据。
            $filter->scope('trashed', '回收站')->onlyTrashed();
        });
        return $grid;
    }
    /**
     * Make a show builder.
     *
     * @param mixed $id
     * @return Show
     */
    protected function detail($id)
    {
        $show = new Show(ImagesCategory::findOrFail($id));
        $show->field('id', __('Id'));
        $show->field('pid', __('ImagesCategoryPid'));
        $show->field('name', __('ImagesCategoryName'));
        $show->field('cover_url', __('Cover url'))->image('',200,200);
        $show->field('sort', __('Sort'));
        $show->field('created_at', __('Created at'));
        $show->field('updated_at', __('Updated at'));
        $show->field('deleted_at', __('Deleted at'));
        return $show;
    }
    /**
     * Make a form builder.
     *
     * @return Form
     */
    protected function form()
    {
        $form = new Form(new ImagesCategory());
        $form->number('pid', __('ImagesCategoryPid'))->width(200)->default(0);
        $form->text('name', __('ImagesCategoryName'))->required();
        // 以合适比例裁剪成300x300，更多使用方法 http://image.intervention.io/api/fit
        $form->image('cover_url', __('Cover url'))->removable()->fit(300);
        $form->number('sort', __('Sort'))->default(100);
        return $form;
    }
}

# zh-CN.json添加
"ImagesCategoryName": "分类名称",
"ImagesCategoryPid": "分类父级Id",
"Cover url": "封面图片",
"Sort": "排序",
"Created at": "创建时间",
"Updated at": "修改时间",
"Deleted at": "删除时间

可达到基本显示、修改等