Db.class.php 5.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142
  1. <?php
  2. /**
  3. * 洛阳赤炎鹰网络科技有限公司
  4. * https://www.cyyvip.com
  5. * Copyright (c) 2022 赤店商城 All rights reserved.
  6. */
  7. // +----------------------------------------------------------------------
  8. // | ThinkPHP [ WE CAN DO IT JUST THINK IT ]
  9. // +----------------------------------------------------------------------
  10. // | Copyright (c) 2006-2014 http://thinkphp.cn All rights reserved.
  11. // +----------------------------------------------------------------------
  12. // | Licensed ( http://www.apache.org/licenses/LICENSE-2.0 )
  13. // +----------------------------------------------------------------------
  14. // | Author: liu21st <liu21st@gmail.com>
  15. // +----------------------------------------------------------------------
  16. namespace Think;
  17. /**
  18. * ThinkPHP 数据库中间层实现类
  19. */
  20. class Db {
  21. static private $instance = array(); // 数据库连接实例
  22. static private $_instance = null; // 当前数据库连接实例
  23. /**
  24. * 取得数据库类实例
  25. * @static
  26. * @access public
  27. * @param mixed $config 连接配置
  28. * @return Object 返回数据库驱动类
  29. */
  30. static public function getInstance($config=array()) {
  31. $md5 = md5(serialize($config));
  32. if(!isset(self::$instance[$md5])) {
  33. // 解析连接参数 支持数组和字符串
  34. $options = self::parseConfig($config);
  35. // 兼容mysqli
  36. if('mysqli' == $options['type']) $options['type'] = 'mysql';
  37. // 如果采用lite方式 仅支持原生SQL 包括query和execute方法
  38. $class = $options['lite']? 'Think\Db\Lite' : 'Think\\Db\\Driver\\'.ucwords(strtolower($options['type']));
  39. if(class_exists($class)){
  40. self::$instance[$md5] = new $class($options);
  41. }else{
  42. // 类没有定义
  43. E(L('_NO_DB_DRIVER_').': ' . $class);
  44. }
  45. }
  46. self::$_instance = self::$instance[$md5];
  47. return self::$_instance;
  48. }
  49. /**
  50. * 数据库连接参数解析
  51. * @static
  52. * @access private
  53. * @param mixed $config
  54. * @return array
  55. */
  56. static private function parseConfig($config){
  57. if(!empty($config)){
  58. if(is_string($config)) {
  59. return self::parseDsn($config);
  60. }
  61. $config = array_change_key_case($config);
  62. $config = array (
  63. 'type' => $config['db_type'],
  64. 'username' => $config['db_user'],
  65. 'password' => $config['db_pwd'],
  66. 'hostname' => $config['db_host'],
  67. 'hostport' => $config['db_port'],
  68. 'database' => $config['db_name'],
  69. 'dsn' => isset($config['db_dsn'])?$config['db_dsn']:null,
  70. 'params' => isset($config['db_params'])?$config['db_params']:null,
  71. 'charset' => isset($config['db_charset'])?$config['db_charset']:'utf8',
  72. 'deploy' => isset($config['db_deploy_type'])?$config['db_deploy_type']:0,
  73. 'rw_separate' => isset($config['db_rw_separate'])?$config['db_rw_separate']:false,
  74. 'master_num' => isset($config['db_master_num'])?$config['db_master_num']:1,
  75. 'slave_no' => isset($config['db_slave_no'])?$config['db_slave_no']:'',
  76. 'debug' => isset($config['db_debug'])?$config['db_debug']:APP_DEBUG,
  77. 'lite' => isset($config['db_lite'])?$config['db_lite']:false,
  78. );
  79. }else {
  80. $config = array (
  81. 'type' => C('DB_TYPE'),
  82. 'username' => C('DB_USER'),
  83. 'password' => C('DB_PWD'),
  84. 'hostname' => C('DB_HOST'),
  85. 'hostport' => C('DB_PORT'),
  86. 'database' => C('DB_NAME'),
  87. 'dsn' => C('DB_DSN'),
  88. 'params' => C('DB_PARAMS'),
  89. 'charset' => C('DB_CHARSET'),
  90. 'deploy' => C('DB_DEPLOY_TYPE'),
  91. 'rw_separate' => C('DB_RW_SEPARATE'),
  92. 'master_num' => C('DB_MASTER_NUM'),
  93. 'slave_no' => C('DB_SLAVE_NO'),
  94. 'debug' => C('DB_DEBUG',null,APP_DEBUG),
  95. 'lite' => C('DB_LITE'),
  96. );
  97. }
  98. return $config;
  99. }
  100. /**
  101. * DSN解析
  102. * 格式: mysql://username:passwd@localhost:3306/DbName?param1=val1&param2=val2#utf8
  103. * @static
  104. * @access private
  105. * @param string $dsnStr
  106. * @return array
  107. */
  108. static private function parseDsn($dsnStr) {
  109. if( empty($dsnStr) ){return false;}
  110. $info = parse_url($dsnStr);
  111. if(!$info) {
  112. return false;
  113. }
  114. $dsn = array(
  115. 'type' => $info['scheme'],
  116. 'username' => isset($info['user']) ? $info['user'] : '',
  117. 'password' => isset($info['pass']) ? $info['pass'] : '',
  118. 'hostname' => isset($info['host']) ? $info['host'] : '',
  119. 'hostport' => isset($info['port']) ? $info['port'] : '',
  120. 'database' => isset($info['path']) ? substr($info['path'],1) : '',
  121. 'charset' => isset($info['fragment'])?$info['fragment']:'utf8',
  122. );
  123. if(isset($info['query'])) {
  124. parse_str($info['query'],$dsn['params']);
  125. }else{
  126. $dsn['params'] = array();
  127. }
  128. return $dsn;
  129. }
  130. // 调用驱动类的方法
  131. static public function __callStatic($method, $params){
  132. return call_user_func_array(array(self::$_instance, $method), $params);
  133. }
  134. }