Advertisement
Guest User

Untitled

a guest
Mar 14th, 2019
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.95 KB | None | 0 0
  1. 'mysql' => [
  2. 'driver' => 'mysql',
  3. 'host' => env('DB_HOST', '127.0.0.1'),
  4. 'port' => env('DB_PORT', '3306'),
  5. 'database' => env('DB_DATABASE', 'forge'),
  6. 'username' => env('DB_USERNAME', 'forge'),
  7. 'password' => env('DB_PASSWORD', ''),
  8. 'unix_socket' => env('DB_SOCKET', ''),
  9. 'charset' => 'utf8mb4',
  10. 'collation' => 'utf8mb4_unicode_ci',
  11. 'prefix' => '',
  12. 'strict' => true,
  13. 'engine' => null,
  14. ],
  15.  
  16. 'mysql_earth' => [
  17. 'driver' => 'mysql',
  18. 'host' => env('DB_HOST', '127.0.0.1'),
  19. 'port' => env('DB_PORT', '3306'),
  20. 'database' => env('DB_EARTH_DATABASE', 'earth'),
  21. 'username' => env('DB_EARTH_USERNAME', 'earth'),
  22. 'password' => env('DB_EARTH_PASSWORD', ''),
  23. 'unix_socket' => env('DB_SOCKET', ''),
  24. 'charset' => 'utf8mb4',
  25. 'collation' => 'utf8mb4_unicode_ci',
  26. 'prefix' => '',
  27. 'strict' => true,
  28. 'engine' => null,
  29. ],
  30.  
  31. 'mysql_moon' => [
  32. 'driver' => 'mysql',
  33. 'host' => env('DB_HOST', '127.0.0.1'),
  34. 'port' => env('DB_PORT', '3306'),
  35. 'database' => env('DB_MOON_DATABASE', 'moon'),
  36. 'username' => env('DB_MOON_USERNAME', 'moon'),
  37. 'password' => env('DB_MOON_PASSWORD', ''),
  38. 'unix_socket' => env('DB_SOCKET', ''),
  39. 'charset' => 'utf8mb4',
  40. 'collation' => 'utf8mb4_unicode_ci',
  41. 'prefix' => '',
  42. 'strict' => true,
  43. 'engine' => null,
  44. ],
  45.  
  46. DB_CONNECTION=mysql
  47. DB_HOST=127.0.0.1
  48. DB_PORT=3306
  49. DB_DATABASE=forge
  50. DB_USERNAME=forge
  51. DB_PASSWORD=forgepw
  52.  
  53. DB_EARTH_DATABASE=earth
  54. DB_EARTH_USERNAME=erth
  55. DB_EARTH_PASSWORD=earthpw
  56.  
  57. DB_MOON_DATABASE=moon
  58. DB_MOON_USERNAME=moon
  59. DB_MOON_PASSWORD=moonpw
  60.  
  61. $db = DB::connection('mysql');
  62. $db = DB::connection('mysql_earth');
  63. $db = DB::connection('mysql_moon');
  64.  
  65. $products = $db->table('products')
  66. ->distinct()
  67. ->select("*" )
  68. ->orderBy('products.id','asc')
  69. ->get();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement