laravel多个数据库相关问题
最近项目中遇到存在多个库的问题,涉及相关的migration,配置,查询等要点如下:
config/database.php配置:
'connections' => [ 'sqlite' => [ 'driver' => 'sqlite', 'database' => env('DB_DATABASE', database_path('database.sqlite')), 'prefix' => '', ], 'mysql' => [ 'driver' => 'mysql', 'host' => env('DB_HOST', '127.0.0.1'), 'port' => env('DB_PORT', '3306'), 'database' => env('DB_DATABASE', 'forge'), 'username' => env('DB_USERNAME', 'forge'), 'password' => env('DB_PASSWORD', ''), 'unix_socket' => env('DB_SOCKET', ''), 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => '', 'strict' => true, 'engine' => null, ], 'mysql1' => [ 'driver' => 'mysql', 'host' => env('DB_HOST', '127.0.0.1'), 'port' => env('DB_PORT', '3306'), 'database' => env('DB_DATABASE1', 'forge'), 'username' => env('DB_USERNAME', 'forge'), 'password' => env('DB_PASSWORD', ''), 'unix_socket' => env('DB_SOCKET', ''), 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => '', 'strict' => true, 'engine' => null, ],
migration通过connection指定连接(库):
class CreateUsersTableDb1 extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::connection('mysql1')->create('users', function (Blueprint $table) { $table->increments('id'); $table->string('name'); $table->string('email')->unique(); $table->string('password'); $table->rememberToken(); $table->timestamps(); }); }
路由:
Route::get('/', 'UserController@index'); Route::get('/index1', 'UserController@index1');
控制器:
<?php namespace App\Http\Controllers; use App\User; use Illuminate\Http\Request; class UserController extends Controller { /** * 读取的是laravel_swoole库的users表 */ public function index(){ $user=User::first()->toArray(); dd($user); } /** * 读取的是laravel_swoole库的users表 */ public function index1(){ $m = new User(); $user=$m->setConnection('mysql1')->first()->toArray(); dd($user); } }
运行结果:
路由1:
array:5 [▼ "id" => 1 "name" => "name0" "email" => "email0" "created_at" => "2018-07-24 21:25:09" "updated_at" => "2018-07-24 21:25:09"]
路由2:
array:5 [▼ "id" => 1 "name" => "name1" "email" => "email1" "created_at" => "2018-07-24 21:24:38" "updated_at" => "2018-07-24 21:24:38"]
数据库中数据:
赞:(0)
踩:(0)
- 相关文章
- laravel 中悲观锁 & 乐观锁的使用
- laravel整合dingo/api方法步骤:jwt
- 一个简单的laravel分表联合查询
- laravel页面静态化的方法
- laravel对具体的路由不采用csrfTok
- laravel不转义富文本中html标签
- laravel学习笔记
- laravel监听sql并生成日志,php art
- laravel框架核心-反射、依赖注入、
- laravel框架核心-serviceProvider
- 热门文章
- win7中将文件拷贝到虚拟机linux下
- phpexcel设置行高及列宽,背景颜色,
- rabbitmq无法启动
- intellij idea不显示git push按钮
- php7中使用mongodb的aggregate进行
- centos7.4 64位下swoole安装及配置
- laravel页面静态化的方法
- navicate连接mycat报1184错误
- 单点登录sso原理及php实现方式及de
- devops-jenkins容器为pending状态
- 好评文章
- phpexcel设置行高及列宽,背景颜色,
- php7中使用mongodb的aggregate进行
- intellij idea打开文件所在文件夹
- windows下使用MongoDB Compass Com
- win7中将文件拷贝到虚拟机linux下
- laravel 中悲观锁 & 乐观锁的使用
- 单点登录sso原理及php实现方式及de
- navicate连接mycat报1184错误
- rabbitmq无法启动
- laravel整合dingo/api方法步骤:jwt
- 我的项目
- 【github】www.github.com/hurong241
- 【码云】gitee.com/hu_rong/projects
- 【docker hub】hub.docker.com/repositories/hurong241
- 【packagist】packagist.org/users/hurong241/packages
- 站点信息
- 建站时间:2011年
- 文章数:607篇
- 浏览数:940273