Guest User

Untitled

a guest
Nov 16th, 2018
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.19 KB | None | 0 0
  1. $dbh = new Dsn;
  2. $pdo = $dbh->connnect1Read(NAME1, USER2, PASS2);
  3. $pdo2 = $dbh->connnect2Write(NAME1, USER1, PASS1);
  4. $pdo3 = $dbh->connnect3(USER2, PASS2);
  5. $pdo4 = $dbh->connnect4(USER3, PASS3);
  6. $pdo5 = $dbh->connnect5(USER4, PASS4);
  7.  
  8. class Dsn
  9. {
  10.  
  11. private $host = 'localhost';
  12. private $charset = 'utf8mb4';
  13.  
  14. private $dbName1;
  15. private $userName1;
  16. private $userPass1;
  17.  
  18. private $dbName2 = 'db2';
  19. private $userName2;
  20. private $userPass2;
  21.  
  22. private $dbName3 = 'db3';
  23. private $userName3;
  24. private $userPass3;
  25.  
  26. private $dbName4 = 'db4';
  27. private $userName4;
  28. private $userPass4;
  29.  
  30.  
  31. private $opt = [
  32. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  33. PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  34. PDO::ATTR_EMULATE_PREPARES => false,
  35. ];
  36.  
  37.  
  38. public function connnect1Read($dbName, $userName, $userPass)
  39. {
  40. $this->dbName1 = $dbName;
  41. $this->userName2 = $userName;
  42. $this->userPass2 = $userPass;
  43.  
  44. $dsn = "mysql:host=" . $this->host . ";dbname=" . $this->dbName1 . ";charset=" . $this->charset . "";
  45. $pdo1 = new PDO($dsn, $this->userName2, $this->userPass2, $this->opt);
  46.  
  47. return $pdo1;
  48. }
  49.  
  50. public function connnect2Write($dbName1, $userName, $userPass)
  51. {
  52. $this->dbName1 = $dbName1;
  53. $this->userName1 = $userName;
  54. $this->userPass1 = $userPass;
  55.  
  56. $dsn = "mysql:host=" . $this->host . ";dbname=" . $this->dbName1 . ";charset=" . $this->charset . "";
  57. $pdo2 = new PDO($dsn, $this->userName1, $this->userPass1, $this->opt);
  58.  
  59. return $pdo2;
  60. }
  61.  
  62. public function connnect3($userName, $userPass)
  63. {
  64. $this->userName2 = $userName;
  65. $this->userPass2 = $userPass;
  66.  
  67. $dsn = "mysql:host=" . $this->host . ";dbname=" . $this->dbName2 . ";charset=" . $this->charset . "";
  68. $pdo4 = new PDO($dsn, $this->userName2, $this->userPass2, $this->opt);
  69.  
  70. return $pdo3;
  71. }
  72.  
  73. public function connnect4($userName, $userPass)
  74. {
  75. $this->userName3 = $userName;
  76. $this->userPass3 = $userPass;
  77.  
  78. $dsn = "mysql:host=" . $this->host . ";dbname=" . $this->dbName3 . ";charset=" . $this->charset . "";
  79. $pdo5 = new PDO($dsn, $this->userName3, $this->userPass3, $this->opt);
  80.  
  81. return $pdo4;
  82. }
  83.  
  84. public function connnect5($userName, $userPass)
  85. {
  86. $this->userName4 = $userName;
  87. $this->userPass4 = $userPass;
  88.  
  89. $dsn = "mysql:host=" . $this->host . ";dbname=" . $this->dbName4 . ";charset=" . $this->charset . "";
  90. $pdo3 = new PDO($dsn, $this->userName4, $this->userPass4, $this->opt);
  91.  
  92. return $pdo5;
  93. }
  94. }
  95.  
  96. function connnect($dbName, $userName, $userPass)
  97. {
  98. $host = 'localhost';
  99. $charset = 'utf8mb4';
  100. $opt = [
  101. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  102. PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  103. PDO::ATTR_EMULATE_PREPARES => false,
  104. ];
  105. $dsn = "mysql:host=$host;dbname=$dbName;charset=$charset";
  106. return new PDO($dsn, $userName, $userPass, $opt);
  107. }
  108.  
  109. $dbRead = connnect(NAME1, USER2, PASS2);
  110. $dbWrte = connnect(NAME1, USER1, PASS1);
  111. $db3 = connnect(NAME3, USER2, PASS2);
  112. $db4 = connnect(NAME4, USER3, PASS3);
  113. $db5 = connnect(NAME5, USER4, PASS4);
Add Comment
Please, Sign In to add comment