pdo_mysql.c 7.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250
  1. /*
  2. +----------------------------------------------------------------------+
  3. | Copyright (c) The PHP Group |
  4. +----------------------------------------------------------------------+
  5. | This source file is subject to version 3.01 of the PHP license, |
  6. | that is bundled with this package in the file LICENSE, and is |
  7. | available through the world-wide-web at the following url: |
  8. | https://www.php.net/license/3_01.txt |
  9. | If you did not receive a copy of the PHP license and are unable to |
  10. | obtain it through the world-wide-web, please send a note to |
  11. | license@php.net so we can mail you a copy immediately. |
  12. +----------------------------------------------------------------------+
  13. | Author: George Schlossnagle <george@omniti.com> |
  14. | Johannes Schlueter <johannes@mysql.com> |
  15. +----------------------------------------------------------------------+
  16. */
  17. #ifdef HAVE_CONFIG_H
  18. #include "config.h"
  19. #endif
  20. #include "php.h"
  21. #include "php_ini.h"
  22. #include "ext/standard/info.h"
  23. #include "pdo/php_pdo.h"
  24. #include "pdo/php_pdo_driver.h"
  25. #include "php_pdo_mysql.h"
  26. #include "php_pdo_mysql_int.h"
  27. #ifdef COMPILE_DL_PDO_MYSQL
  28. #ifdef ZTS
  29. ZEND_TSRMLS_CACHE_DEFINE()
  30. #endif
  31. ZEND_GET_MODULE(pdo_mysql)
  32. #endif
  33. ZEND_DECLARE_MODULE_GLOBALS(pdo_mysql)
  34. /*
  35. The default socket location is sometimes defined by configure.
  36. With libmysql `mysql_config --socket` will fill PDO_MYSQL_UNIX_ADDR
  37. and the user can use --with-mysql-sock=SOCKET which will fill
  38. PDO_MYSQL_UNIX_ADDR. If both aren't set we're using mysqlnd and use
  39. /tmp/mysql.sock as default on *nix and NULL for Windows (default
  40. named pipe name is set in mysqlnd).
  41. */
  42. #ifndef PDO_MYSQL_UNIX_ADDR
  43. # ifdef PHP_MYSQL_UNIX_SOCK_ADDR
  44. # define PDO_MYSQL_UNIX_ADDR PHP_MYSQL_UNIX_SOCK_ADDR
  45. # else
  46. # ifndef PHP_WIN32
  47. # define PDO_MYSQL_UNIX_ADDR "/tmp/mysql.sock"
  48. # else
  49. # define PDO_MYSQL_UNIX_ADDR NULL
  50. # endif
  51. # endif
  52. #endif
  53. #ifdef PDO_USE_MYSQLND
  54. #include "ext/mysqlnd/mysqlnd_reverse_api.h"
  55. static MYSQLND * pdo_mysql_convert_zv_to_mysqlnd(zval * zv)
  56. {
  57. if (Z_TYPE_P(zv) == IS_OBJECT && instanceof_function(Z_OBJCE_P(zv), php_pdo_get_dbh_ce())) {
  58. pdo_dbh_t * dbh = Z_PDO_DBH_P(zv);
  59. ZEND_ASSERT(dbh);
  60. if (dbh->driver != &pdo_mysql_driver) {
  61. php_error_docref(NULL, E_WARNING, "Provided PDO instance is not using MySQL but %s", dbh->driver->driver_name);
  62. return NULL;
  63. }
  64. return ((pdo_mysql_db_handle *)dbh->driver_data)->server;
  65. }
  66. return NULL;
  67. }
  68. static const MYSQLND_REVERSE_API pdo_mysql_reverse_api = {
  69. &pdo_mysql_module_entry,
  70. pdo_mysql_convert_zv_to_mysqlnd
  71. };
  72. #endif
  73. /* {{{ PHP_INI_BEGIN */
  74. PHP_INI_BEGIN()
  75. #ifndef PHP_WIN32
  76. STD_PHP_INI_ENTRY("pdo_mysql.default_socket", PDO_MYSQL_UNIX_ADDR, PHP_INI_SYSTEM, OnUpdateStringUnempty, default_socket, zend_pdo_mysql_globals, pdo_mysql_globals)
  77. #endif
  78. #if PDO_DBG_ENABLED
  79. STD_PHP_INI_ENTRY("pdo_mysql.debug", NULL, PHP_INI_SYSTEM, OnUpdateString, debug, zend_pdo_mysql_globals, pdo_mysql_globals)
  80. #endif
  81. PHP_INI_END()
  82. /* }}} */
  83. /* true global environment */
  84. /* {{{ PHP_MINIT_FUNCTION */
  85. static PHP_MINIT_FUNCTION(pdo_mysql)
  86. {
  87. REGISTER_INI_ENTRIES();
  88. REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_USE_BUFFERED_QUERY", (zend_long)PDO_MYSQL_ATTR_USE_BUFFERED_QUERY);
  89. REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_LOCAL_INFILE", (zend_long)PDO_MYSQL_ATTR_LOCAL_INFILE);
  90. REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_INIT_COMMAND", (zend_long)PDO_MYSQL_ATTR_INIT_COMMAND);
  91. #ifndef PDO_USE_MYSQLND
  92. REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_MAX_BUFFER_SIZE", (zend_long)PDO_MYSQL_ATTR_MAX_BUFFER_SIZE);
  93. REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_READ_DEFAULT_FILE", (zend_long)PDO_MYSQL_ATTR_READ_DEFAULT_FILE);
  94. REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_READ_DEFAULT_GROUP", (zend_long)PDO_MYSQL_ATTR_READ_DEFAULT_GROUP);
  95. #endif
  96. REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_COMPRESS", (zend_long)PDO_MYSQL_ATTR_COMPRESS);
  97. REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_DIRECT_QUERY", (zend_long)PDO_MYSQL_ATTR_DIRECT_QUERY);
  98. REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_FOUND_ROWS", (zend_long)PDO_MYSQL_ATTR_FOUND_ROWS);
  99. REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_IGNORE_SPACE", (zend_long)PDO_MYSQL_ATTR_IGNORE_SPACE);
  100. REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_SSL_KEY", (zend_long)PDO_MYSQL_ATTR_SSL_KEY);
  101. REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_SSL_CERT", (zend_long)PDO_MYSQL_ATTR_SSL_CERT);
  102. REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_SSL_CA", (zend_long)PDO_MYSQL_ATTR_SSL_CA);
  103. REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_SSL_CAPATH", (zend_long)PDO_MYSQL_ATTR_SSL_CAPATH);
  104. REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_SSL_CIPHER", (zend_long)PDO_MYSQL_ATTR_SSL_CIPHER);
  105. #if MYSQL_VERSION_ID > 50605 || defined(PDO_USE_MYSQLND)
  106. REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_SERVER_PUBLIC_KEY", (zend_long)PDO_MYSQL_ATTR_SERVER_PUBLIC_KEY);
  107. #endif
  108. REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_MULTI_STATEMENTS", (zend_long)PDO_MYSQL_ATTR_MULTI_STATEMENTS);
  109. #ifdef PDO_USE_MYSQLND
  110. REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_SSL_VERIFY_SERVER_CERT", (zend_long)PDO_MYSQL_ATTR_SSL_VERIFY_SERVER_CERT);
  111. #endif
  112. #if MYSQL_VERSION_ID >= 80021 || defined(PDO_USE_MYSQLND)
  113. REGISTER_PDO_CLASS_CONST_LONG("MYSQL_ATTR_LOCAL_INFILE_DIRECTORY", (zend_long)PDO_MYSQL_ATTR_LOCAL_INFILE_DIRECTORY);
  114. #endif
  115. #ifdef PDO_USE_MYSQLND
  116. mysqlnd_reverse_api_register_api(&pdo_mysql_reverse_api);
  117. #endif
  118. return php_pdo_register_driver(&pdo_mysql_driver);
  119. }
  120. /* }}} */
  121. /* {{{ PHP_MSHUTDOWN_FUNCTION */
  122. static PHP_MSHUTDOWN_FUNCTION(pdo_mysql)
  123. {
  124. php_pdo_unregister_driver(&pdo_mysql_driver);
  125. #ifdef PDO_USE_MYSQLND
  126. UNREGISTER_INI_ENTRIES();
  127. #endif
  128. return SUCCESS;
  129. }
  130. /* }}} */
  131. /* {{{ PHP_MINFO_FUNCTION */
  132. static PHP_MINFO_FUNCTION(pdo_mysql)
  133. {
  134. php_info_print_table_start();
  135. php_info_print_table_header(2, "PDO Driver for MySQL", "enabled");
  136. php_info_print_table_row(2, "Client API version", mysql_get_client_info());
  137. php_info_print_table_end();
  138. #ifndef PHP_WIN32
  139. DISPLAY_INI_ENTRIES();
  140. #endif
  141. }
  142. /* }}} */
  143. #if defined(PDO_USE_MYSQLND) && PDO_DBG_ENABLED
  144. /* {{{ PHP_RINIT_FUNCTION */
  145. static PHP_RINIT_FUNCTION(pdo_mysql)
  146. {
  147. if (PDO_MYSQL_G(debug)) {
  148. MYSQLND_DEBUG *dbg = mysqlnd_debug_init(mysqlnd_debug_std_no_trace_funcs);
  149. if (!dbg) {
  150. return FAILURE;
  151. }
  152. dbg->m->set_mode(dbg, PDO_MYSQL_G(debug));
  153. PDO_MYSQL_G(dbg) = dbg;
  154. }
  155. return SUCCESS;
  156. }
  157. /* }}} */
  158. /* {{{ PHP_RSHUTDOWN_FUNCTION */
  159. static PHP_RSHUTDOWN_FUNCTION(pdo_mysql)
  160. {
  161. MYSQLND_DEBUG *dbg = PDO_MYSQL_G(dbg);
  162. PDO_DBG_ENTER("RSHUTDOWN");
  163. if (dbg) {
  164. dbg->m->close(dbg);
  165. dbg->m->free_handle(dbg);
  166. PDO_MYSQL_G(dbg) = NULL;
  167. }
  168. return SUCCESS;
  169. }
  170. /* }}} */
  171. #endif
  172. /* {{{ PHP_GINIT_FUNCTION */
  173. static PHP_GINIT_FUNCTION(pdo_mysql)
  174. {
  175. #if defined(COMPILE_DL_PDO_MYSQL) && defined(ZTS)
  176. ZEND_TSRMLS_CACHE_UPDATE();
  177. #endif
  178. #ifndef PHP_WIN32
  179. pdo_mysql_globals->default_socket = NULL;
  180. #endif
  181. #if PDO_DBG_ENABLED
  182. pdo_mysql_globals->debug = NULL; /* The actual string */
  183. pdo_mysql_globals->dbg = NULL; /* The DBG object*/
  184. #endif
  185. }
  186. /* }}} */
  187. /* {{{ pdo_mysql_deps[] */
  188. static const zend_module_dep pdo_mysql_deps[] = {
  189. ZEND_MOD_REQUIRED("pdo")
  190. #ifdef PDO_USE_MYSQLND
  191. ZEND_MOD_REQUIRED("mysqlnd")
  192. #endif
  193. ZEND_MOD_END
  194. };
  195. /* }}} */
  196. /* {{{ pdo_mysql_module_entry */
  197. zend_module_entry pdo_mysql_module_entry = {
  198. STANDARD_MODULE_HEADER_EX, NULL,
  199. pdo_mysql_deps,
  200. "pdo_mysql",
  201. NULL,
  202. PHP_MINIT(pdo_mysql),
  203. PHP_MSHUTDOWN(pdo_mysql),
  204. #if defined(PDO_USE_MYSQLND) && PDO_DBG_ENABLED
  205. PHP_RINIT(pdo_mysql),
  206. PHP_RSHUTDOWN(pdo_mysql),
  207. #else
  208. NULL,
  209. NULL,
  210. #endif
  211. PHP_MINFO(pdo_mysql),
  212. PHP_PDO_MYSQL_VERSION,
  213. PHP_MODULE_GLOBALS(pdo_mysql),
  214. PHP_GINIT(pdo_mysql),
  215. NULL,
  216. NULL,
  217. STANDARD_MODULE_PROPERTIES_EX
  218. };
  219. /* }}} */