1. Configure the. env file
1 db_connection=mysql 2 db_host=127.0.0.1 3 db_port=3306 4 db_database= database_name 5 db_username=root 6 db_password= 7 8 db_host_center=127.0.0.1 9< /c11> db_port_center=3306 db_database_center=database_center db_username_ center=root db_password_center=
2, Configuration config/database.php
' MySQL ' = [ ' Driver ' = ' mysql ', ' host ' + env (' db_host ', ' localhost '), ' port ' = env (' Db_port ', ' 3306 ') ), ' database ' = env (' db_database ', ' Forge '), ' username ' = env (' db_username ', ' Forge '), ' Password ' = env (' Db_password ', '), ' charset ' and ' UTF8 ', ' collation ' and ' Utf8_unico ' De_ci ', ' prefix ' = ', ' strict ' =false, ' engine ' =NULL, ], ' mysql_center ' = [ ' Driver ' = ' mysql ', ' host ' + env (' db_host_center ', ' localhost '), ' port ' = env (' Db_port_c ENTER ', ' 3306 '), ' database ' = env (' Db_database_center ', ' Forge '), ' username ' = env (' Db_usern Ame_center ', ' Forge '), ' password ' = env (' Db_password_center ', '), ' charset ' = ' utf8 ', ' Collation ' = ' utf8_unicode_ci ', ' prefix ' = ', ' strict 'false, ' engine ' =NULL, ],
3. Create model
// This model will use the default ' MySQL ' Connection class usermodel model{
// The Users table protected $table = "Users" ;
// this model will be connected using Mysql_center class extends model{
the Users table in database ' Dadtabase_center ' protected$connection = ' mysql_center '; protected $table = "users";}
Laravel using multiple database connections