You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

Mysql.php 1.8 KiB

3 years ago
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
  1. <?php
  2. /*
  3. Author:XM
  4. Compeny:Spiders Travel
  5. */
  6. require_once __DIR__.'/Config.php';
  7. require_once __DIR__.'/Function.php';
  8. date_default_timezone_set('PRC');
  9. function conn(){
  10. $port=defined('MYSQL_PORT')?MYSQL_PORT:3306;
  11. try {
  12. $pdo=new PDO("mysql:host=".MYSQL_HOST.";port=".$port.";dbname=".MYSQL_DB, MYSQL_USER, MYSQL_PASSWORD,array(PDO::MYSQL_ATTR_INIT_COMMAND => "set names utf8"));
  13. return $pdo;
  14. }catch (PDOException $e){
  15. writeLog('new PDO failed:'.$e->getMessage());
  16. }
  17. }
  18. function conn1(){
  19. $port=defined('MYSQL_PORT')?MYSQL_PORT:3306;
  20. try {
  21. $pdo=new PDO("mysql:host=".MYSQL_HOST.";port=".$port.";dbname=".MYSQL_DB, MYSQL_USER, MYSQL_PASSWORD,array(PDO::MYSQL_ATTR_INIT_COMMAND => "set names utf8"));
  22. return $pdo;
  23. }catch (PDOException $e){
  24. writeLog('new PDO failed:'.$e->getMessage());
  25. }
  26. }
  27. function conn2(){
  28. $port=defined('MYSQL_PORT2')?MYSQL_PORT2:3306;
  29. try {
  30. $pdo=new PDO("mysql:host=".MYSQL_HOST2.";port=".$port.";dbname=".MYSQL_DB2, MYSQL_USER2, MYSQL_PASSWORD2,array(PDO::MYSQL_ATTR_INIT_COMMAND => "set names utf8"));
  31. return $pdo;
  32. }catch (PDOException $e){
  33. writeLog('new PDO failed:'.$e->getMessage());
  34. }
  35. }
  36. function conn3(){
  37. $port=defined('MYSQL_PORT')?MYSQL_PORT:3306;
  38. try {
  39. $pdo=new PDO("mysql:host=".MYSQL_HOST.";port=".$port.";dbname=waice", MYSQL_USER, MYSQL_PASSWORD,array(PDO::MYSQL_ATTR_INIT_COMMAND => "set names utf8"));
  40. return $pdo;
  41. }catch (PDOException $e){
  42. writeLog('new PDO failed:'.$e->getMessage());
  43. }
  44. }
  45. function conn_njyyt(){
  46. $port=defined('MYSQL_PORT_YYT')?MYSQL_PORT_YYT:3306;
  47. try {
  48. $pdo=new PDO("mysql:host=".MYSQL_HOST_YYT.";port=".$port.";dbname=".MYSQL_DB_YYT, MYSQL_USER_YYT, MYSQL_PASSWORD_YYT,array(PDO::MYSQL_ATTR_INIT_COMMAND => "set names utf8"));
  49. return $pdo;
  50. }catch (PDOException $e){
  51. writeLog('new PDO failed:'.$e->getMessage());
  52. }
  53. }