Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- '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,
- ],
- 'mysql_earth' => [
- 'driver' => 'mysql',
- 'host' => env('DB_HOST', '127.0.0.1'),
- 'port' => env('DB_PORT', '3306'),
- 'database' => env('DB_EARTH_DATABASE', 'earth'),
- 'username' => env('DB_EARTH_USERNAME', 'earth'),
- 'password' => env('DB_EARTH_PASSWORD', ''),
- 'unix_socket' => env('DB_SOCKET', ''),
- 'charset' => 'utf8mb4',
- 'collation' => 'utf8mb4_unicode_ci',
- 'prefix' => '',
- 'strict' => true,
- 'engine' => null,
- ],
- 'mysql_moon' => [
- 'driver' => 'mysql',
- 'host' => env('DB_HOST', '127.0.0.1'),
- 'port' => env('DB_PORT', '3306'),
- 'database' => env('DB_MOON_DATABASE', 'moon'),
- 'username' => env('DB_MOON_USERNAME', 'moon'),
- 'password' => env('DB_MOON_PASSWORD', ''),
- 'unix_socket' => env('DB_SOCKET', ''),
- 'charset' => 'utf8mb4',
- 'collation' => 'utf8mb4_unicode_ci',
- 'prefix' => '',
- 'strict' => true,
- 'engine' => null,
- ],
- DB_CONNECTION=mysql
- DB_HOST=127.0.0.1
- DB_PORT=3306
- DB_DATABASE=forge
- DB_USERNAME=forge
- DB_PASSWORD=forgepw
- DB_EARTH_DATABASE=earth
- DB_EARTH_USERNAME=erth
- DB_EARTH_PASSWORD=earthpw
- DB_MOON_DATABASE=moon
- DB_MOON_USERNAME=moon
- DB_MOON_PASSWORD=moonpw
- $db = DB::connection('mysql');
- $db = DB::connection('mysql_earth');
- $db = DB::connection('mysql_moon');
- $products = $db->table('products')
- ->distinct()
- ->select("*" )
- ->orderBy('products.id','asc')
- ->get();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement