mysqli.c 44 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200
  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. | Authors: Georg Richter <georg@php.net> |
  14. | Andrey Hristov <andrey@php.net> |
  15. | Ulf Wendel <uw@php.net> |
  16. +----------------------------------------------------------------------+
  17. */
  18. #ifdef HAVE_CONFIG_H
  19. #include "config.h"
  20. #endif
  21. #include <signal.h>
  22. #include "php.h"
  23. #include "php_ini.h"
  24. #include "ext/standard/info.h"
  25. #include "ext/standard/php_string.h"
  26. #include "php_mysqli.h"
  27. #include "php_mysqli_structs.h"
  28. #include "mysqli_priv.h"
  29. #include "zend_exceptions.h"
  30. #include "ext/spl/spl_exceptions.h"
  31. #include "zend_interfaces.h"
  32. #include "mysqli_arginfo.h"
  33. ZEND_DECLARE_MODULE_GLOBALS(mysqli)
  34. static PHP_GINIT_FUNCTION(mysqli);
  35. #define MYSQLI_ADD_PROPERTIES(a, b) \
  36. { \
  37. int i = 0; \
  38. while (b[i].pname != NULL) { \
  39. mysqli_add_property((a), (b)[i].pname, (b)[i].pname_length, \
  40. (mysqli_read_t)(b)[i].r_func, (mysqli_write_t)(b)[i].w_func); \
  41. i++; \
  42. } \
  43. }
  44. #define ERROR_ARG_POS(arg_num) (getThis() ? (arg_num-1) : (arg_num))
  45. static HashTable classes;
  46. static zend_object_handlers mysqli_object_handlers;
  47. static zend_object_handlers mysqli_object_driver_handlers;
  48. static zend_object_handlers mysqli_object_link_handlers;
  49. static zend_object_handlers mysqli_object_result_handlers;
  50. static zend_object_handlers mysqli_object_stmt_handlers;
  51. static zend_object_handlers mysqli_object_warning_handlers;
  52. static HashTable mysqli_driver_properties;
  53. static HashTable mysqli_link_properties;
  54. static HashTable mysqli_result_properties;
  55. static HashTable mysqli_stmt_properties;
  56. static HashTable mysqli_warning_properties;
  57. zend_class_entry *mysqli_link_class_entry;
  58. zend_class_entry *mysqli_stmt_class_entry;
  59. zend_class_entry *mysqli_result_class_entry;
  60. zend_class_entry *mysqli_driver_class_entry;
  61. zend_class_entry *mysqli_warning_class_entry;
  62. zend_class_entry *mysqli_exception_class_entry;
  63. typedef int (*mysqli_read_t)(mysqli_object *obj, zval *rv, bool quiet);
  64. typedef int (*mysqli_write_t)(mysqli_object *obj, zval *newval);
  65. typedef struct _mysqli_prop_handler {
  66. zend_string *name;
  67. mysqli_read_t read_func;
  68. mysqli_write_t write_func;
  69. } mysqli_prop_handler;
  70. static int le_pmysqli;
  71. static void free_prop_handler(zval *el) {
  72. pefree(Z_PTR_P(el), 1);
  73. }
  74. /* Destructor for mysqli entries in free_links/used_links */
  75. void php_mysqli_dtor_p_elements(void *data)
  76. {
  77. MYSQL *mysql = (MYSQL *)data;
  78. mysqli_close(mysql, MYSQLI_CLOSE_IMPLICIT);
  79. }
  80. ZEND_RSRC_DTOR_FUNC(php_mysqli_dtor)
  81. {
  82. if (res->ptr) {
  83. mysqli_plist_entry *plist = (mysqli_plist_entry *)res->ptr;
  84. zend_ptr_stack_clean(&plist->free_links, php_mysqli_dtor_p_elements, 0);
  85. zend_ptr_stack_destroy(&plist->free_links);
  86. free(plist);
  87. }
  88. }
  89. int php_le_pmysqli(void)
  90. {
  91. return le_pmysqli;
  92. }
  93. #ifndef MYSQLI_USE_MYSQLND
  94. /* {{{ php_free_stmt_bind_buffer */
  95. void php_free_stmt_bind_buffer(BIND_BUFFER bbuf, int type)
  96. {
  97. unsigned int i;
  98. if (!bbuf.var_cnt) {
  99. return;
  100. }
  101. for (i=0; i < bbuf.var_cnt; i++) {
  102. /* free temporary bind buffer */
  103. if (type == FETCH_RESULT && bbuf.buf[i].val) {
  104. efree(bbuf.buf[i].val);
  105. }
  106. zval_ptr_dtor(&bbuf.vars[i]);
  107. }
  108. if (bbuf.vars) {
  109. efree(bbuf.vars);
  110. }
  111. /*
  112. Don't free bbuf.is_null for FETCH_RESULT since we have allocated
  113. is_null and buf in one block so we free only buf, which is the beginning
  114. of the block. When FETCH_SIMPLE then buf wasn't allocated together with
  115. buf and we have to free it.
  116. */
  117. if (type == FETCH_RESULT) {
  118. efree(bbuf.buf);
  119. } else if (type == FETCH_SIMPLE){
  120. efree(bbuf.is_null);
  121. }
  122. bbuf.var_cnt = 0;
  123. }
  124. /* }}} */
  125. #endif
  126. /* {{{ php_clear_stmt_bind */
  127. void php_clear_stmt_bind(MY_STMT *stmt)
  128. {
  129. if (stmt->stmt) {
  130. if (mysqli_stmt_close(stmt->stmt, true)) {
  131. php_error_docref(NULL, E_WARNING, "Error occurred while closing statement");
  132. return;
  133. }
  134. }
  135. /*
  136. mysqlnd keeps track of the binding and has freed its
  137. structures in stmt_close() above
  138. */
  139. #ifndef MYSQLI_USE_MYSQLND
  140. /* Clean param bind */
  141. php_free_stmt_bind_buffer(stmt->param, FETCH_SIMPLE);
  142. /* Clean output bind */
  143. php_free_stmt_bind_buffer(stmt->result, FETCH_RESULT);
  144. if (!Z_ISUNDEF(stmt->link_handle)) {
  145. zval_ptr_dtor(&stmt->link_handle);
  146. }
  147. #endif
  148. if (stmt->query) {
  149. efree(stmt->query);
  150. }
  151. efree(stmt);
  152. }
  153. /* }}} */
  154. /* {{{ php_clear_mysql */
  155. void php_clear_mysql(MY_MYSQL *mysql) {
  156. if (mysql->hash_key) {
  157. zend_string_release_ex(mysql->hash_key, 0);
  158. mysql->hash_key = NULL;
  159. }
  160. if (!Z_ISUNDEF(mysql->li_read)) {
  161. zval_ptr_dtor(&(mysql->li_read));
  162. ZVAL_UNDEF(&mysql->li_read);
  163. }
  164. }
  165. /* }}} */
  166. /* {{{ mysqli_objects_free_storage */
  167. static void mysqli_objects_free_storage(zend_object *object)
  168. {
  169. mysqli_object *intern = php_mysqli_fetch_object(object);
  170. MYSQLI_RESOURCE *my_res = (MYSQLI_RESOURCE *)intern->ptr;
  171. if (my_res) {
  172. efree(my_res);
  173. }
  174. zend_object_std_dtor(&intern->zo);
  175. }
  176. /* }}} */
  177. /* mysqli_link_free_storage partly doubles the work of PHP_FUNCTION(mysqli_close) */
  178. /* {{{ mysqli_link_free_storage */
  179. static void mysqli_link_free_storage(zend_object *object)
  180. {
  181. mysqli_object *intern = php_mysqli_fetch_object(object);
  182. MYSQLI_RESOURCE *my_res = (MYSQLI_RESOURCE *)intern->ptr;
  183. if (my_res && my_res->ptr) {
  184. MY_MYSQL *mysql = (MY_MYSQL *)my_res->ptr;
  185. if (mysql->mysql) {
  186. php_mysqli_close(mysql, MYSQLI_CLOSE_EXPLICIT, my_res->status);
  187. }
  188. php_clear_mysql(mysql);
  189. efree(mysql);
  190. my_res->status = MYSQLI_STATUS_UNKNOWN;
  191. }
  192. mysqli_objects_free_storage(object);
  193. }
  194. /* }}} */
  195. /* {{{ mysql_driver_free_storage */
  196. static void mysqli_driver_free_storage(zend_object *object)
  197. {
  198. mysqli_objects_free_storage(object);
  199. }
  200. /* }}} */
  201. /* {{{ mysqli_stmt_free_storage */
  202. static void mysqli_stmt_free_storage(zend_object *object)
  203. {
  204. mysqli_object *intern = php_mysqli_fetch_object(object);
  205. MYSQLI_RESOURCE *my_res = (MYSQLI_RESOURCE *)intern->ptr;
  206. if (my_res && my_res->ptr) {
  207. MY_STMT *stmt = (MY_STMT *)my_res->ptr;
  208. php_clear_stmt_bind(stmt);
  209. }
  210. mysqli_objects_free_storage(object);
  211. }
  212. /* }}} */
  213. /* {{{ mysqli_result_free_storage */
  214. static void mysqli_result_free_storage(zend_object *object)
  215. {
  216. mysqli_object *intern = php_mysqli_fetch_object(object);
  217. MYSQLI_RESOURCE *my_res = (MYSQLI_RESOURCE *)intern->ptr;
  218. if (my_res && my_res->ptr) {
  219. mysql_free_result(my_res->ptr);
  220. }
  221. mysqli_objects_free_storage(object);
  222. }
  223. /* }}} */
  224. /* {{{ mysqli_warning_free_storage */
  225. static void mysqli_warning_free_storage(zend_object *object)
  226. {
  227. mysqli_object *intern = php_mysqli_fetch_object(object);
  228. MYSQLI_RESOURCE *my_res = (MYSQLI_RESOURCE *)intern->ptr;
  229. if (my_res && my_res->ptr) {
  230. php_clear_warnings((MYSQLI_WARNING *)my_res->info);
  231. my_res->ptr = NULL;
  232. }
  233. mysqli_objects_free_storage(object);
  234. }
  235. /* }}} */
  236. /* {{{ mysqli_read_na */
  237. static int mysqli_read_na(mysqli_object *obj, zval *retval, bool quiet)
  238. {
  239. if (!quiet) {
  240. zend_throw_error(NULL, "Cannot read property");
  241. }
  242. return FAILURE;
  243. }
  244. /* }}} */
  245. /* {{{ mysqli_read_property */
  246. zval *mysqli_read_property(zend_object *object, zend_string *name, int type, void **cache_slot, zval *rv)
  247. {
  248. mysqli_object *obj = php_mysqli_fetch_object(object);
  249. if (obj->prop_handler) {
  250. mysqli_prop_handler *hnd = zend_hash_find_ptr(obj->prop_handler, name);
  251. if (hnd) {
  252. if (hnd->read_func(obj, rv, type == BP_VAR_IS) == SUCCESS) {
  253. return rv;
  254. } else {
  255. return &EG(uninitialized_zval);
  256. }
  257. }
  258. }
  259. return zend_std_read_property(object, name, type, cache_slot, rv);
  260. }
  261. /* }}} */
  262. /* {{{ mysqli_write_property */
  263. zval *mysqli_write_property(zend_object *object, zend_string *name, zval *value, void **cache_slot)
  264. {
  265. mysqli_object *obj = php_mysqli_fetch_object(object);
  266. if (obj->prop_handler) {
  267. const mysqli_prop_handler *hnd = zend_hash_find_ptr(obj->prop_handler, name);
  268. if (hnd) {
  269. if (!hnd->write_func) {
  270. zend_throw_error(NULL, "Cannot write read-only property %s::$%s",
  271. ZSTR_VAL(object->ce->name), ZSTR_VAL(name));
  272. return &EG(error_zval);
  273. }
  274. zend_property_info *prop = zend_get_property_info(object->ce, name, /* silent */ true);
  275. if (prop && ZEND_TYPE_IS_SET(prop->type)) {
  276. zval tmp;
  277. ZVAL_COPY(&tmp, value);
  278. if (!zend_verify_property_type(prop, &tmp,
  279. ZEND_CALL_USES_STRICT_TYPES(EG(current_execute_data)))) {
  280. zval_ptr_dtor(&tmp);
  281. return &EG(error_zval);
  282. }
  283. hnd->write_func(obj, &tmp);
  284. zval_ptr_dtor(&tmp);
  285. } else {
  286. hnd->write_func(obj, value);
  287. }
  288. return value;
  289. }
  290. }
  291. return zend_std_write_property(object, name, value, cache_slot);
  292. }
  293. /* }}} */
  294. /* {{{ void mysqli_add_property(HashTable *h, char *pname, mysqli_read_t r_func, mysqli_write_t w_func) */
  295. void mysqli_add_property(HashTable *h, const char *pname, size_t pname_len, mysqli_read_t r_func, mysqli_write_t w_func) {
  296. mysqli_prop_handler p;
  297. p.name = zend_string_init_interned(pname, pname_len, 1);
  298. p.read_func = (r_func) ? r_func : mysqli_read_na;
  299. p.write_func = w_func;
  300. zend_hash_add_mem(h, p.name, &p, sizeof(mysqli_prop_handler));
  301. zend_string_release_ex(p.name, 1);
  302. }
  303. /* }}} */
  304. static int mysqli_object_has_property(zend_object *object, zend_string *name, int has_set_exists, void **cache_slot) /* {{{ */
  305. {
  306. mysqli_object *obj = php_mysqli_fetch_object(object);
  307. mysqli_prop_handler *p;
  308. int ret = 0;
  309. if ((p = zend_hash_find_ptr(obj->prop_handler, name)) != NULL) {
  310. switch (has_set_exists) {
  311. case ZEND_PROPERTY_EXISTS:
  312. ret = 1;
  313. break;
  314. case ZEND_PROPERTY_NOT_EMPTY: {
  315. zval rv;
  316. zval *value = mysqli_read_property(object, name, BP_VAR_IS, cache_slot, &rv);
  317. if (value != &EG(uninitialized_zval)) {
  318. convert_to_boolean(value);
  319. ret = Z_TYPE_P(value) == IS_TRUE ? 1 : 0;
  320. }
  321. break;
  322. }
  323. case ZEND_PROPERTY_ISSET: {
  324. zval rv;
  325. zval *value = mysqli_read_property(object, name, BP_VAR_IS, cache_slot, &rv);
  326. if (value != &EG(uninitialized_zval)) {
  327. ret = Z_TYPE_P(value) != IS_NULL? 1 : 0;
  328. zval_ptr_dtor(value);
  329. }
  330. break;
  331. }
  332. EMPTY_SWITCH_DEFAULT_CASE();
  333. }
  334. } else {
  335. ret = zend_std_has_property(object, name, has_set_exists, cache_slot);
  336. }
  337. return ret;
  338. } /* }}} */
  339. HashTable *mysqli_object_get_debug_info(zend_object *object, int *is_temp)
  340. {
  341. mysqli_object *obj = php_mysqli_fetch_object(object);
  342. HashTable *retval, *props = obj->prop_handler;
  343. mysqli_prop_handler *entry;
  344. retval = zend_new_array(zend_hash_num_elements(props) + 1);
  345. ZEND_HASH_FOREACH_PTR(props, entry) {
  346. zval rv;
  347. zval *value;
  348. value = mysqli_read_property(object, entry->name, BP_VAR_IS, 0, &rv);
  349. if (value != &EG(uninitialized_zval)) {
  350. zend_hash_add(retval, entry->name, value);
  351. }
  352. } ZEND_HASH_FOREACH_END();
  353. *is_temp = 1;
  354. return retval;
  355. }
  356. /* {{{ mysqli_objects_new */
  357. PHP_MYSQLI_EXPORT(zend_object *) mysqli_objects_new(zend_class_entry *class_type)
  358. {
  359. mysqli_object *intern;
  360. zend_class_entry *mysqli_base_class;
  361. zend_object_handlers *handlers;
  362. intern = zend_object_alloc(sizeof(mysqli_object), class_type);
  363. mysqli_base_class = class_type;
  364. while (mysqli_base_class->type != ZEND_INTERNAL_CLASS &&
  365. mysqli_base_class->parent != NULL) {
  366. mysqli_base_class = mysqli_base_class->parent;
  367. }
  368. intern->prop_handler = zend_hash_find_ptr(&classes, mysqli_base_class->name);
  369. zend_object_std_init(&intern->zo, class_type);
  370. object_properties_init(&intern->zo, class_type);
  371. /* link object */
  372. if (instanceof_function(class_type, mysqli_link_class_entry)) {
  373. handlers = &mysqli_object_link_handlers;
  374. } else if (instanceof_function(class_type, mysqli_driver_class_entry)) { /* driver object */
  375. handlers = &mysqli_object_driver_handlers;
  376. } else if (instanceof_function(class_type, mysqli_stmt_class_entry)) { /* stmt object */
  377. handlers = &mysqli_object_stmt_handlers;
  378. } else if (instanceof_function(class_type, mysqli_result_class_entry)) { /* result object */
  379. handlers = &mysqli_object_result_handlers;
  380. } else if (instanceof_function(class_type, mysqli_warning_class_entry)) { /* warning object */
  381. handlers = &mysqli_object_warning_handlers;
  382. } else {
  383. handlers = &mysqli_object_handlers;
  384. }
  385. intern->zo.handlers = handlers;
  386. return &intern->zo;
  387. }
  388. /* }}} */
  389. #ifdef MYSQLI_USE_MYSQLND
  390. #include "ext/mysqlnd/mysqlnd_reverse_api.h"
  391. static MYSQLND *mysqli_convert_zv_to_mysqlnd(zval * zv)
  392. {
  393. if (Z_TYPE_P(zv) == IS_OBJECT && instanceof_function(Z_OBJCE_P(zv), mysqli_link_class_entry)) {
  394. MY_MYSQL *mysql;
  395. MYSQLI_RESOURCE *my_res;
  396. mysqli_object *intern = Z_MYSQLI_P(zv);
  397. if (!(my_res = (MYSQLI_RESOURCE *)intern->ptr)) {
  398. /* We know that we have a mysqli object, so this failure should be emitted */
  399. zend_throw_error(NULL, "%s object is already closed", ZSTR_VAL(intern->zo.ce->name));
  400. return NULL;
  401. }
  402. mysql = (MY_MYSQL *)(my_res->ptr);
  403. return mysql ? mysql->mysql : NULL;
  404. }
  405. return NULL;
  406. }
  407. static const MYSQLND_REVERSE_API mysqli_reverse_api = {
  408. &mysqli_module_entry,
  409. mysqli_convert_zv_to_mysqlnd
  410. };
  411. #endif
  412. /* {{{ PHP_INI_BEGIN */
  413. PHP_INI_BEGIN()
  414. STD_PHP_INI_ENTRY_EX("mysqli.max_links", "-1", PHP_INI_SYSTEM, OnUpdateLong, max_links, zend_mysqli_globals, mysqli_globals, display_link_numbers)
  415. STD_PHP_INI_ENTRY_EX("mysqli.max_persistent", "-1", PHP_INI_SYSTEM, OnUpdateLong, max_persistent, zend_mysqli_globals, mysqli_globals, display_link_numbers)
  416. STD_PHP_INI_BOOLEAN("mysqli.allow_persistent", "1", PHP_INI_SYSTEM, OnUpdateLong, allow_persistent, zend_mysqli_globals, mysqli_globals)
  417. STD_PHP_INI_BOOLEAN("mysqli.rollback_on_cached_plink", "0",PHP_INI_SYSTEM, OnUpdateBool, rollback_on_cached_plink, zend_mysqli_globals, mysqli_globals)
  418. STD_PHP_INI_ENTRY("mysqli.default_host", NULL, PHP_INI_ALL, OnUpdateString, default_host, zend_mysqli_globals, mysqli_globals)
  419. STD_PHP_INI_ENTRY("mysqli.default_user", NULL, PHP_INI_ALL, OnUpdateString, default_user, zend_mysqli_globals, mysqli_globals)
  420. STD_PHP_INI_ENTRY("mysqli.default_pw", NULL, PHP_INI_ALL, OnUpdateString, default_pw, zend_mysqli_globals, mysqli_globals)
  421. STD_PHP_INI_ENTRY("mysqli.default_port", "3306", PHP_INI_ALL, OnUpdateLong, default_port, zend_mysqli_globals, mysqli_globals)
  422. #ifdef PHP_MYSQL_UNIX_SOCK_ADDR
  423. STD_PHP_INI_ENTRY("mysqli.default_socket", MYSQL_UNIX_ADDR,PHP_INI_ALL,OnUpdateStringUnempty, default_socket, zend_mysqli_globals, mysqli_globals)
  424. #else
  425. STD_PHP_INI_ENTRY("mysqli.default_socket", NULL, PHP_INI_ALL, OnUpdateStringUnempty, default_socket, zend_mysqli_globals, mysqli_globals)
  426. #endif
  427. STD_PHP_INI_BOOLEAN("mysqli.reconnect", "0", PHP_INI_SYSTEM, OnUpdateLong, reconnect, zend_mysqli_globals, mysqli_globals)
  428. STD_PHP_INI_BOOLEAN("mysqli.allow_local_infile", "0", PHP_INI_SYSTEM, OnUpdateLong, allow_local_infile, zend_mysqli_globals, mysqli_globals)
  429. STD_PHP_INI_ENTRY("mysqli.local_infile_directory", NULL, PHP_INI_SYSTEM, OnUpdateString, local_infile_directory, zend_mysqli_globals, mysqli_globals)
  430. PHP_INI_END()
  431. /* }}} */
  432. /* {{{ PHP_GINIT_FUNCTION */
  433. static PHP_GINIT_FUNCTION(mysqli)
  434. {
  435. #if defined(COMPILE_DL_MYSQLI) && defined(ZTS)
  436. ZEND_TSRMLS_CACHE_UPDATE();
  437. #endif
  438. mysqli_globals->num_links = 0;
  439. mysqli_globals->max_links = -1;
  440. mysqli_globals->num_active_persistent = 0;
  441. mysqli_globals->num_inactive_persistent = 0;
  442. mysqli_globals->max_persistent = -1;
  443. mysqli_globals->allow_persistent = 1;
  444. mysqli_globals->default_port = 0;
  445. mysqli_globals->default_host = NULL;
  446. mysqli_globals->default_user = NULL;
  447. mysqli_globals->default_pw = NULL;
  448. mysqli_globals->default_socket = NULL;
  449. mysqli_globals->reconnect = 0;
  450. mysqli_globals->report_mode = MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT;;
  451. mysqli_globals->allow_local_infile = 0;
  452. mysqli_globals->local_infile_directory = NULL;
  453. mysqli_globals->rollback_on_cached_plink = false;
  454. }
  455. /* }}} */
  456. /* {{{ PHP_MINIT_FUNCTION */
  457. PHP_MINIT_FUNCTION(mysqli)
  458. {
  459. REGISTER_INI_ENTRIES();
  460. #ifndef MYSQLI_USE_MYSQLND
  461. if (mysql_server_init(0, NULL, NULL)) {
  462. return FAILURE;
  463. }
  464. #endif
  465. memcpy(&mysqli_object_handlers, &std_object_handlers, sizeof(zend_object_handlers));
  466. mysqli_object_handlers.offset = XtOffsetOf(mysqli_object, zo);
  467. mysqli_object_handlers.free_obj = mysqli_objects_free_storage;
  468. mysqli_object_handlers.clone_obj = NULL;
  469. mysqli_object_handlers.read_property = mysqli_read_property;
  470. mysqli_object_handlers.write_property = mysqli_write_property;
  471. mysqli_object_handlers.has_property = mysqli_object_has_property;
  472. mysqli_object_handlers.get_debug_info = mysqli_object_get_debug_info;
  473. memcpy(&mysqli_object_driver_handlers, &mysqli_object_handlers, sizeof(zend_object_handlers));
  474. mysqli_object_driver_handlers.free_obj = mysqli_driver_free_storage;
  475. memcpy(&mysqli_object_link_handlers, &mysqli_object_handlers, sizeof(zend_object_handlers));
  476. mysqli_object_link_handlers.free_obj = mysqli_link_free_storage;
  477. memcpy(&mysqli_object_result_handlers, &mysqli_object_handlers, sizeof(zend_object_handlers));
  478. mysqli_object_result_handlers.free_obj = mysqli_result_free_storage;
  479. memcpy(&mysqli_object_stmt_handlers, &mysqli_object_handlers, sizeof(zend_object_handlers));
  480. mysqli_object_stmt_handlers.free_obj = mysqli_stmt_free_storage;
  481. memcpy(&mysqli_object_warning_handlers, &mysqli_object_handlers, sizeof(zend_object_handlers));
  482. mysqli_object_warning_handlers.free_obj = mysqli_warning_free_storage;
  483. zend_hash_init(&classes, 0, NULL, NULL, 1);
  484. /* persistent connections */
  485. le_pmysqli = zend_register_list_destructors_ex(NULL, php_mysqli_dtor,
  486. "MySqli persistent connection", module_number);
  487. mysqli_exception_class_entry = register_class_mysqli_sql_exception(spl_ce_RuntimeException);
  488. mysqli_driver_class_entry = register_class_mysqli_driver();
  489. mysqli_driver_class_entry->create_object = mysqli_objects_new;
  490. zend_hash_init(&mysqli_driver_properties, 0, NULL, free_prop_handler, 1);
  491. MYSQLI_ADD_PROPERTIES(&mysqli_driver_properties, mysqli_driver_property_entries);
  492. zend_hash_add_ptr(&classes, mysqli_driver_class_entry->name, &mysqli_driver_properties);
  493. mysqli_link_class_entry = register_class_mysqli();
  494. mysqli_link_class_entry->create_object = mysqli_objects_new;
  495. zend_hash_init(&mysqli_link_properties, 0, NULL, free_prop_handler, 1);
  496. MYSQLI_ADD_PROPERTIES(&mysqli_link_properties, mysqli_link_property_entries);
  497. zend_hash_add_ptr(&classes, mysqli_link_class_entry->name, &mysqli_link_properties);
  498. mysqli_warning_class_entry = register_class_mysqli_warning();
  499. mysqli_warning_class_entry->create_object = mysqli_objects_new;
  500. zend_hash_init(&mysqli_warning_properties, 0, NULL, free_prop_handler, 1);
  501. MYSQLI_ADD_PROPERTIES(&mysqli_warning_properties, mysqli_warning_property_entries);
  502. zend_hash_add_ptr(&classes, mysqli_warning_class_entry->name, &mysqli_warning_properties);
  503. mysqli_result_class_entry = register_class_mysqli_result(zend_ce_aggregate);
  504. mysqli_result_class_entry->create_object = mysqli_objects_new;
  505. mysqli_result_class_entry->get_iterator = php_mysqli_result_get_iterator;
  506. zend_hash_init(&mysqli_result_properties, 0, NULL, free_prop_handler, 1);
  507. MYSQLI_ADD_PROPERTIES(&mysqli_result_properties, mysqli_result_property_entries);
  508. zend_hash_add_ptr(&classes, mysqli_result_class_entry->name, &mysqli_result_properties);
  509. mysqli_stmt_class_entry = register_class_mysqli_stmt();
  510. mysqli_stmt_class_entry->create_object = mysqli_objects_new;
  511. zend_hash_init(&mysqli_stmt_properties, 0, NULL, free_prop_handler, 1);
  512. MYSQLI_ADD_PROPERTIES(&mysqli_stmt_properties, mysqli_stmt_property_entries);
  513. zend_hash_add_ptr(&classes, mysqli_stmt_class_entry->name, &mysqli_stmt_properties);
  514. /* mysqli_options */
  515. REGISTER_LONG_CONSTANT("MYSQLI_READ_DEFAULT_GROUP", MYSQL_READ_DEFAULT_GROUP, CONST_CS | CONST_PERSISTENT);
  516. REGISTER_LONG_CONSTANT("MYSQLI_READ_DEFAULT_FILE", MYSQL_READ_DEFAULT_FILE, CONST_CS | CONST_PERSISTENT);
  517. REGISTER_LONG_CONSTANT("MYSQLI_OPT_CONNECT_TIMEOUT", MYSQL_OPT_CONNECT_TIMEOUT, CONST_CS | CONST_PERSISTENT);
  518. REGISTER_LONG_CONSTANT("MYSQLI_OPT_LOCAL_INFILE", MYSQL_OPT_LOCAL_INFILE, CONST_CS | CONST_PERSISTENT);
  519. #if (MYSQL_VERSION_ID >= 80021 && !defined(MARIADB_BASE_VERSION)) || defined(MYSQLI_USE_MYSQLND)
  520. REGISTER_LONG_CONSTANT("MYSQLI_OPT_LOAD_DATA_LOCAL_DIR", MYSQL_OPT_LOAD_DATA_LOCAL_DIR, CONST_CS | CONST_PERSISTENT);
  521. #endif
  522. REGISTER_LONG_CONSTANT("MYSQLI_INIT_COMMAND", MYSQL_INIT_COMMAND, CONST_CS | CONST_PERSISTENT);
  523. REGISTER_LONG_CONSTANT("MYSQLI_OPT_READ_TIMEOUT", MYSQL_OPT_READ_TIMEOUT, CONST_CS | CONST_PERSISTENT);
  524. #ifdef MYSQLI_USE_MYSQLND
  525. REGISTER_LONG_CONSTANT("MYSQLI_OPT_NET_CMD_BUFFER_SIZE", MYSQLND_OPT_NET_CMD_BUFFER_SIZE, CONST_CS | CONST_PERSISTENT);
  526. REGISTER_LONG_CONSTANT("MYSQLI_OPT_NET_READ_BUFFER_SIZE", MYSQLND_OPT_NET_READ_BUFFER_SIZE, CONST_CS | CONST_PERSISTENT);
  527. #endif
  528. #ifdef MYSQLI_USE_MYSQLND
  529. REGISTER_LONG_CONSTANT("MYSQLI_OPT_INT_AND_FLOAT_NATIVE", MYSQLND_OPT_INT_AND_FLOAT_NATIVE, CONST_CS | CONST_PERSISTENT);
  530. #endif
  531. #if MYSQL_VERSION_ID < 80000 || MYSQL_VERSION_ID >= 100000 || defined(MYSQLI_USE_MYSQLND)
  532. REGISTER_LONG_CONSTANT("MYSQLI_OPT_SSL_VERIFY_SERVER_CERT", MYSQL_OPT_SSL_VERIFY_SERVER_CERT, CONST_CS | CONST_PERSISTENT);
  533. #endif
  534. #if MYSQL_VERSION_ID > 50605 || defined(MYSQLI_USE_MYSQLND)
  535. REGISTER_LONG_CONSTANT("MYSQLI_SERVER_PUBLIC_KEY", MYSQL_SERVER_PUBLIC_KEY, CONST_CS | CONST_PERSISTENT);
  536. #endif
  537. /* mysqli_real_connect flags */
  538. REGISTER_LONG_CONSTANT("MYSQLI_CLIENT_SSL", CLIENT_SSL, CONST_CS | CONST_PERSISTENT);
  539. REGISTER_LONG_CONSTANT("MYSQLI_CLIENT_COMPRESS",CLIENT_COMPRESS, CONST_CS | CONST_PERSISTENT);
  540. REGISTER_LONG_CONSTANT("MYSQLI_CLIENT_INTERACTIVE", CLIENT_INTERACTIVE, CONST_CS | CONST_PERSISTENT);
  541. REGISTER_LONG_CONSTANT("MYSQLI_CLIENT_IGNORE_SPACE", CLIENT_IGNORE_SPACE, CONST_CS | CONST_PERSISTENT);
  542. REGISTER_LONG_CONSTANT("MYSQLI_CLIENT_NO_SCHEMA", CLIENT_NO_SCHEMA, CONST_CS | CONST_PERSISTENT);
  543. REGISTER_LONG_CONSTANT("MYSQLI_CLIENT_FOUND_ROWS", CLIENT_FOUND_ROWS, CONST_CS | CONST_PERSISTENT);
  544. #ifdef CLIENT_SSL_VERIFY_SERVER_CERT
  545. REGISTER_LONG_CONSTANT("MYSQLI_CLIENT_SSL_VERIFY_SERVER_CERT", CLIENT_SSL_VERIFY_SERVER_CERT, CONST_CS | CONST_PERSISTENT);
  546. #ifdef MYSQLI_USE_MYSQLND
  547. REGISTER_LONG_CONSTANT("MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT", CLIENT_SSL_DONT_VERIFY_SERVER_CERT, CONST_CS | CONST_PERSISTENT);
  548. #endif
  549. #endif
  550. #if (MYSQL_VERSION_ID >= 50611 && defined(CLIENT_CAN_HANDLE_EXPIRED_PASSWORDS)) || defined(MYSQLI_USE_MYSQLND)
  551. REGISTER_LONG_CONSTANT("MYSQLI_CLIENT_CAN_HANDLE_EXPIRED_PASSWORDS", CLIENT_CAN_HANDLE_EXPIRED_PASSWORDS, CONST_CS | CONST_PERSISTENT);
  552. REGISTER_LONG_CONSTANT("MYSQLI_OPT_CAN_HANDLE_EXPIRED_PASSWORDS", MYSQL_OPT_CAN_HANDLE_EXPIRED_PASSWORDS, CONST_CS | CONST_PERSISTENT);
  553. #endif
  554. /* for mysqli_query */
  555. REGISTER_LONG_CONSTANT("MYSQLI_STORE_RESULT", MYSQLI_STORE_RESULT, CONST_CS | CONST_PERSISTENT);
  556. REGISTER_LONG_CONSTANT("MYSQLI_USE_RESULT", MYSQLI_USE_RESULT, CONST_CS | CONST_PERSISTENT);
  557. #if defined (MYSQLI_USE_MYSQLND)
  558. REGISTER_LONG_CONSTANT("MYSQLI_ASYNC", MYSQLI_ASYNC, CONST_CS | CONST_PERSISTENT);
  559. REGISTER_LONG_CONSTANT("MYSQLI_STORE_RESULT_COPY_DATA", MYSQLI_STORE_RESULT_COPY_DATA, CONST_CS | CONST_PERSISTENT);
  560. #endif
  561. /* for mysqli_fetch_assoc */
  562. REGISTER_LONG_CONSTANT("MYSQLI_ASSOC", MYSQLI_ASSOC, CONST_CS | CONST_PERSISTENT);
  563. REGISTER_LONG_CONSTANT("MYSQLI_NUM", MYSQLI_NUM, CONST_CS | CONST_PERSISTENT);
  564. REGISTER_LONG_CONSTANT("MYSQLI_BOTH", MYSQLI_BOTH, CONST_CS | CONST_PERSISTENT);
  565. /* for mysqli_stmt_set_attr */
  566. REGISTER_LONG_CONSTANT("MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH", STMT_ATTR_UPDATE_MAX_LENGTH, CONST_CS | CONST_PERSISTENT);
  567. REGISTER_LONG_CONSTANT("MYSQLI_STMT_ATTR_CURSOR_TYPE", STMT_ATTR_CURSOR_TYPE, CONST_CS | CONST_PERSISTENT);
  568. REGISTER_LONG_CONSTANT("MYSQLI_CURSOR_TYPE_NO_CURSOR", CURSOR_TYPE_NO_CURSOR, CONST_CS | CONST_PERSISTENT);
  569. REGISTER_LONG_CONSTANT("MYSQLI_CURSOR_TYPE_READ_ONLY", CURSOR_TYPE_READ_ONLY, CONST_CS | CONST_PERSISTENT);
  570. REGISTER_LONG_CONSTANT("MYSQLI_CURSOR_TYPE_FOR_UPDATE", CURSOR_TYPE_FOR_UPDATE, CONST_CS | CONST_PERSISTENT);
  571. REGISTER_LONG_CONSTANT("MYSQLI_CURSOR_TYPE_SCROLLABLE", CURSOR_TYPE_SCROLLABLE, CONST_CS | CONST_PERSISTENT);
  572. REGISTER_LONG_CONSTANT("MYSQLI_STMT_ATTR_PREFETCH_ROWS", STMT_ATTR_PREFETCH_ROWS, CONST_CS | CONST_PERSISTENT);
  573. /* column information */
  574. REGISTER_LONG_CONSTANT("MYSQLI_NOT_NULL_FLAG", NOT_NULL_FLAG, CONST_CS | CONST_PERSISTENT);
  575. REGISTER_LONG_CONSTANT("MYSQLI_PRI_KEY_FLAG", PRI_KEY_FLAG, CONST_CS | CONST_PERSISTENT);
  576. REGISTER_LONG_CONSTANT("MYSQLI_UNIQUE_KEY_FLAG", UNIQUE_KEY_FLAG, CONST_CS | CONST_PERSISTENT);
  577. REGISTER_LONG_CONSTANT("MYSQLI_MULTIPLE_KEY_FLAG", MULTIPLE_KEY_FLAG, CONST_CS | CONST_PERSISTENT);
  578. REGISTER_LONG_CONSTANT("MYSQLI_BLOB_FLAG", BLOB_FLAG, CONST_CS | CONST_PERSISTENT);
  579. REGISTER_LONG_CONSTANT("MYSQLI_UNSIGNED_FLAG", UNSIGNED_FLAG, CONST_CS | CONST_PERSISTENT);
  580. REGISTER_LONG_CONSTANT("MYSQLI_ZEROFILL_FLAG", ZEROFILL_FLAG, CONST_CS | CONST_PERSISTENT);
  581. REGISTER_LONG_CONSTANT("MYSQLI_AUTO_INCREMENT_FLAG", AUTO_INCREMENT_FLAG, CONST_CS | CONST_PERSISTENT);
  582. REGISTER_LONG_CONSTANT("MYSQLI_TIMESTAMP_FLAG", TIMESTAMP_FLAG, CONST_CS | CONST_PERSISTENT);
  583. REGISTER_LONG_CONSTANT("MYSQLI_SET_FLAG", SET_FLAG, CONST_CS | CONST_PERSISTENT);
  584. REGISTER_LONG_CONSTANT("MYSQLI_NUM_FLAG", NUM_FLAG, CONST_CS | CONST_PERSISTENT);
  585. REGISTER_LONG_CONSTANT("MYSQLI_PART_KEY_FLAG", PART_KEY_FLAG, CONST_CS | CONST_PERSISTENT);
  586. REGISTER_LONG_CONSTANT("MYSQLI_GROUP_FLAG", GROUP_FLAG, CONST_CS | CONST_PERSISTENT);
  587. REGISTER_LONG_CONSTANT("MYSQLI_ENUM_FLAG", ENUM_FLAG, CONST_CS | CONST_PERSISTENT);
  588. REGISTER_LONG_CONSTANT("MYSQLI_BINARY_FLAG", BINARY_FLAG, CONST_CS | CONST_PERSISTENT);
  589. REGISTER_LONG_CONSTANT("MYSQLI_NO_DEFAULT_VALUE_FLAG", NO_DEFAULT_VALUE_FLAG, CONST_CS | CONST_PERSISTENT);
  590. #if MYSQL_VERSION_ID < 60000 || MYSQL_VERSION_ID > 60003 || defined(MYSQLI_USE_MYSQLND)
  591. REGISTER_LONG_CONSTANT("MYSQLI_ON_UPDATE_NOW_FLAG", ON_UPDATE_NOW_FLAG, CONST_CS | CONST_PERSISTENT);
  592. #endif
  593. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_DECIMAL", FIELD_TYPE_DECIMAL, CONST_CS | CONST_PERSISTENT);
  594. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_TINY", FIELD_TYPE_TINY, CONST_CS | CONST_PERSISTENT);
  595. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_SHORT", FIELD_TYPE_SHORT, CONST_CS | CONST_PERSISTENT);
  596. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_LONG", FIELD_TYPE_LONG, CONST_CS | CONST_PERSISTENT);
  597. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_FLOAT", FIELD_TYPE_FLOAT, CONST_CS | CONST_PERSISTENT);
  598. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_DOUBLE", FIELD_TYPE_DOUBLE, CONST_CS | CONST_PERSISTENT);
  599. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_NULL", FIELD_TYPE_NULL, CONST_CS | CONST_PERSISTENT);
  600. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_TIMESTAMP", FIELD_TYPE_TIMESTAMP, CONST_CS | CONST_PERSISTENT);
  601. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_LONGLONG", FIELD_TYPE_LONGLONG, CONST_CS | CONST_PERSISTENT);
  602. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_INT24", FIELD_TYPE_INT24, CONST_CS | CONST_PERSISTENT);
  603. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_DATE", FIELD_TYPE_DATE, CONST_CS | CONST_PERSISTENT);
  604. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_TIME", FIELD_TYPE_TIME, CONST_CS | CONST_PERSISTENT);
  605. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_DATETIME", FIELD_TYPE_DATETIME , CONST_CS | CONST_PERSISTENT);
  606. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_YEAR", FIELD_TYPE_YEAR, CONST_CS | CONST_PERSISTENT);
  607. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_NEWDATE", FIELD_TYPE_NEWDATE, CONST_CS | CONST_PERSISTENT);
  608. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_ENUM", FIELD_TYPE_ENUM, CONST_CS | CONST_PERSISTENT);
  609. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_SET", FIELD_TYPE_SET, CONST_CS | CONST_PERSISTENT);
  610. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_TINY_BLOB", FIELD_TYPE_TINY_BLOB, CONST_CS | CONST_PERSISTENT);
  611. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_MEDIUM_BLOB", FIELD_TYPE_MEDIUM_BLOB, CONST_CS | CONST_PERSISTENT);
  612. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_LONG_BLOB", FIELD_TYPE_LONG_BLOB, CONST_CS | CONST_PERSISTENT);
  613. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_BLOB", FIELD_TYPE_BLOB, CONST_CS | CONST_PERSISTENT);
  614. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_VAR_STRING", FIELD_TYPE_VAR_STRING, CONST_CS | CONST_PERSISTENT);
  615. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_STRING", FIELD_TYPE_STRING, CONST_CS | CONST_PERSISTENT);
  616. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_CHAR", FIELD_TYPE_CHAR, CONST_CS | CONST_PERSISTENT);
  617. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_INTERVAL", FIELD_TYPE_INTERVAL, CONST_CS | CONST_PERSISTENT);
  618. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_GEOMETRY", FIELD_TYPE_GEOMETRY, CONST_CS | CONST_PERSISTENT);
  619. #ifdef FIELD_TYPE_JSON
  620. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_JSON", FIELD_TYPE_JSON, CONST_CS | CONST_PERSISTENT);
  621. #endif
  622. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_NEWDECIMAL", FIELD_TYPE_NEWDECIMAL, CONST_CS | CONST_PERSISTENT);
  623. REGISTER_LONG_CONSTANT("MYSQLI_TYPE_BIT", FIELD_TYPE_BIT, CONST_CS | CONST_PERSISTENT);
  624. REGISTER_LONG_CONSTANT("MYSQLI_SET_CHARSET_NAME", MYSQL_SET_CHARSET_NAME, CONST_CS | CONST_PERSISTENT);
  625. REGISTER_LONG_CONSTANT("MYSQLI_SET_CHARSET_DIR", MYSQL_SET_CHARSET_DIR, CONST_CS | CONST_PERSISTENT);
  626. /* bind support */
  627. REGISTER_LONG_CONSTANT("MYSQLI_NO_DATA", MYSQL_NO_DATA, CONST_CS | CONST_PERSISTENT | CONST_DEPRECATED);
  628. #ifdef MYSQL_DATA_TRUNCATED
  629. REGISTER_LONG_CONSTANT("MYSQLI_DATA_TRUNCATED", MYSQL_DATA_TRUNCATED, CONST_CS | CONST_PERSISTENT | CONST_DEPRECATED);
  630. #endif
  631. /* reporting */
  632. REGISTER_LONG_CONSTANT("MYSQLI_REPORT_INDEX", MYSQLI_REPORT_INDEX, CONST_CS | CONST_PERSISTENT);
  633. REGISTER_LONG_CONSTANT("MYSQLI_REPORT_ERROR", MYSQLI_REPORT_ERROR, CONST_CS | CONST_PERSISTENT);
  634. REGISTER_LONG_CONSTANT("MYSQLI_REPORT_STRICT", MYSQLI_REPORT_STRICT, CONST_CS | CONST_PERSISTENT);
  635. REGISTER_LONG_CONSTANT("MYSQLI_REPORT_ALL", MYSQLI_REPORT_ALL, CONST_CS | CONST_PERSISTENT);
  636. REGISTER_LONG_CONSTANT("MYSQLI_REPORT_OFF", 0, CONST_CS | CONST_PERSISTENT);
  637. /* We use non-nested macros with expansion, as VC has problems */
  638. #ifdef MYSQLI_USE_MYSQLND
  639. REGISTER_LONG_CONSTANT("MYSQLI_DEBUG_TRACE_ENABLED", MYSQLND_DBG_ENABLED, CONST_CS | CONST_PERSISTENT);
  640. #else
  641. #ifdef DBUG_ON
  642. REGISTER_LONG_CONSTANT("MYSQLI_DEBUG_TRACE_ENABLED", 1, CONST_CS | CONST_PERSISTENT);
  643. #else
  644. REGISTER_LONG_CONSTANT("MYSQLI_DEBUG_TRACE_ENABLED", 0, CONST_CS | CONST_PERSISTENT);
  645. #endif
  646. #endif
  647. REGISTER_LONG_CONSTANT("MYSQLI_SERVER_QUERY_NO_GOOD_INDEX_USED", SERVER_QUERY_NO_GOOD_INDEX_USED, CONST_CS | CONST_PERSISTENT | CONST_DEPRECATED);
  648. REGISTER_LONG_CONSTANT("MYSQLI_SERVER_QUERY_NO_INDEX_USED", SERVER_QUERY_NO_INDEX_USED, CONST_CS | CONST_PERSISTENT | CONST_DEPRECATED);
  649. #ifdef SERVER_QUERY_WAS_SLOW
  650. REGISTER_LONG_CONSTANT("MYSQLI_SERVER_QUERY_WAS_SLOW", SERVER_QUERY_WAS_SLOW, CONST_CS | CONST_PERSISTENT | CONST_DEPRECATED);
  651. #endif
  652. #ifdef SERVER_PS_OUT_PARAMS
  653. REGISTER_LONG_CONSTANT("MYSQLI_SERVER_PS_OUT_PARAMS", SERVER_PS_OUT_PARAMS, CONST_CS | CONST_PERSISTENT | CONST_DEPRECATED);
  654. #endif
  655. REGISTER_LONG_CONSTANT("MYSQLI_REFRESH_GRANT", REFRESH_GRANT, CONST_CS | CONST_PERSISTENT);
  656. REGISTER_LONG_CONSTANT("MYSQLI_REFRESH_LOG", REFRESH_LOG, CONST_CS | CONST_PERSISTENT);
  657. REGISTER_LONG_CONSTANT("MYSQLI_REFRESH_TABLES", REFRESH_TABLES, CONST_CS | CONST_PERSISTENT);
  658. REGISTER_LONG_CONSTANT("MYSQLI_REFRESH_HOSTS", REFRESH_HOSTS, CONST_CS | CONST_PERSISTENT);
  659. REGISTER_LONG_CONSTANT("MYSQLI_REFRESH_STATUS", REFRESH_STATUS, CONST_CS | CONST_PERSISTENT);
  660. REGISTER_LONG_CONSTANT("MYSQLI_REFRESH_THREADS", REFRESH_THREADS, CONST_CS | CONST_PERSISTENT);
  661. REGISTER_LONG_CONSTANT("MYSQLI_REFRESH_REPLICA", REFRESH_SLAVE, CONST_CS | CONST_PERSISTENT);
  662. /* temporarily for backward compatibility */
  663. REGISTER_LONG_CONSTANT("MYSQLI_REFRESH_SLAVE", REFRESH_SLAVE, CONST_CS | CONST_PERSISTENT);
  664. REGISTER_LONG_CONSTANT("MYSQLI_REFRESH_MASTER", REFRESH_MASTER, CONST_CS | CONST_PERSISTENT);
  665. #ifdef REFRESH_BACKUP_LOG
  666. REGISTER_LONG_CONSTANT("MYSQLI_REFRESH_BACKUP_LOG", REFRESH_BACKUP_LOG, CONST_CS | CONST_PERSISTENT);
  667. #endif
  668. REGISTER_LONG_CONSTANT("MYSQLI_TRANS_START_WITH_CONSISTENT_SNAPSHOT", TRANS_START_WITH_CONSISTENT_SNAPSHOT, CONST_CS | CONST_PERSISTENT);
  669. REGISTER_LONG_CONSTANT("MYSQLI_TRANS_START_READ_WRITE", TRANS_START_READ_WRITE, CONST_CS | CONST_PERSISTENT);
  670. REGISTER_LONG_CONSTANT("MYSQLI_TRANS_START_READ_ONLY", TRANS_START_READ_ONLY, CONST_CS | CONST_PERSISTENT);
  671. REGISTER_LONG_CONSTANT("MYSQLI_TRANS_COR_AND_CHAIN", TRANS_COR_AND_CHAIN, CONST_CS | CONST_PERSISTENT);
  672. REGISTER_LONG_CONSTANT("MYSQLI_TRANS_COR_AND_NO_CHAIN", TRANS_COR_AND_NO_CHAIN, CONST_CS | CONST_PERSISTENT);
  673. REGISTER_LONG_CONSTANT("MYSQLI_TRANS_COR_RELEASE", TRANS_COR_RELEASE, CONST_CS | CONST_PERSISTENT);
  674. REGISTER_LONG_CONSTANT("MYSQLI_TRANS_COR_NO_RELEASE", TRANS_COR_NO_RELEASE, CONST_CS | CONST_PERSISTENT);
  675. #ifdef MARIADB_BASE_VERSION
  676. REGISTER_BOOL_CONSTANT("MYSQLI_IS_MARIADB", 1, CONST_CS | CONST_PERSISTENT);
  677. #else
  678. REGISTER_BOOL_CONSTANT("MYSQLI_IS_MARIADB", 0, CONST_CS | CONST_PERSISTENT);
  679. #endif
  680. #ifdef MYSQLI_USE_MYSQLND
  681. mysqlnd_reverse_api_register_api(&mysqli_reverse_api);
  682. #endif
  683. return SUCCESS;
  684. }
  685. /* }}} */
  686. /* {{{ PHP_MSHUTDOWN_FUNCTION */
  687. PHP_MSHUTDOWN_FUNCTION(mysqli)
  688. {
  689. #ifndef MYSQLI_USE_MYSQLND
  690. #ifdef PHP_WIN32
  691. zend_ulong client_ver = mysql_get_client_version();
  692. /*
  693. Can't call mysql_server_end() multiple times prior to 5.0.46 on Windows.
  694. PHP bug#41350 MySQL bug#25621
  695. */
  696. if ((client_ver >= 50046 && client_ver < 50100) || client_ver > 50122) {
  697. mysql_server_end();
  698. }
  699. #else
  700. mysql_server_end();
  701. #endif
  702. #endif
  703. zend_hash_destroy(&mysqli_driver_properties);
  704. zend_hash_destroy(&mysqli_result_properties);
  705. zend_hash_destroy(&mysqli_stmt_properties);
  706. zend_hash_destroy(&mysqli_warning_properties);
  707. zend_hash_destroy(&mysqli_link_properties);
  708. zend_hash_destroy(&classes);
  709. UNREGISTER_INI_ENTRIES();
  710. return SUCCESS;
  711. }
  712. /* }}} */
  713. /* {{{ PHP_RINIT_FUNCTION */
  714. PHP_RINIT_FUNCTION(mysqli)
  715. {
  716. #if !defined(MYSQLI_USE_MYSQLND) && defined(ZTS)
  717. if (mysql_thread_init()) {
  718. return FAILURE;
  719. }
  720. #endif
  721. MyG(error_msg) = NULL;
  722. MyG(error_no) = 0;
  723. MyG(report_mode) = MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT;
  724. return SUCCESS;
  725. }
  726. /* }}} */
  727. #if defined(A0) && defined(MYSQLI_USE_MYSQLND)
  728. static void php_mysqli_persistent_helper_for_every(void *p)
  729. {
  730. mysqlnd_end_psession((MYSQLND *) p);
  731. } /* }}} */
  732. static int php_mysqli_persistent_helper_once(zend_rsrc_list_entry *le)
  733. {
  734. if (le->type == php_le_pmysqli()) {
  735. mysqli_plist_entry *plist = (mysqli_plist_entry *) le->ptr;
  736. zend_ptr_stack_apply(&plist->free_links, php_mysqli_persistent_helper_for_every);
  737. }
  738. return ZEND_HASH_APPLY_KEEP;
  739. } /* }}} */
  740. #endif
  741. /* {{{ PHP_RSHUTDOWN_FUNCTION */
  742. PHP_RSHUTDOWN_FUNCTION(mysqli)
  743. {
  744. /* check persistent connections, move used to free */
  745. #if !defined(MYSQLI_USE_MYSQLND) && defined(ZTS)
  746. mysql_thread_end();
  747. #endif
  748. if (MyG(error_msg)) {
  749. efree(MyG(error_msg));
  750. }
  751. #if defined(A0) && defined(MYSQLI_USE_MYSQLND)
  752. /* psession is being called when the connection is freed - explicitly or implicitly */
  753. zend_hash_apply(&EG(persistent_list), (apply_func_t) php_mysqli_persistent_helper_once);
  754. #endif
  755. return SUCCESS;
  756. }
  757. /* }}} */
  758. /* {{{ PHP_MINFO_FUNCTION */
  759. PHP_MINFO_FUNCTION(mysqli)
  760. {
  761. char buf[32];
  762. php_info_print_table_start();
  763. php_info_print_table_header(2, "MysqlI Support", "enabled");
  764. php_info_print_table_row(2, "Client API library version", mysql_get_client_info());
  765. snprintf(buf, sizeof(buf), ZEND_LONG_FMT, MyG(num_active_persistent));
  766. php_info_print_table_row(2, "Active Persistent Links", buf);
  767. snprintf(buf, sizeof(buf), ZEND_LONG_FMT, MyG(num_inactive_persistent));
  768. php_info_print_table_row(2, "Inactive Persistent Links", buf);
  769. snprintf(buf, sizeof(buf), ZEND_LONG_FMT, MyG(num_links));
  770. php_info_print_table_row(2, "Active Links", buf);
  771. #ifndef MYSQLI_USE_MYSQLND
  772. php_info_print_table_row(2, "Client API header version", MYSQL_SERVER_VERSION);
  773. php_info_print_table_row(2, "MYSQLI_SOCKET", MYSQL_UNIX_ADDR);
  774. #endif
  775. php_info_print_table_end();
  776. DISPLAY_INI_ENTRIES();
  777. }
  778. /* }}} */
  779. /* Dependencies */
  780. static const zend_module_dep mysqli_deps[] = {
  781. ZEND_MOD_REQUIRED("spl")
  782. #ifdef MYSQLI_USE_MYSQLND
  783. ZEND_MOD_REQUIRED("mysqlnd")
  784. #endif
  785. ZEND_MOD_END
  786. };
  787. /* {{{ mysqli_module_entry */
  788. zend_module_entry mysqli_module_entry = {
  789. STANDARD_MODULE_HEADER_EX, NULL,
  790. mysqli_deps,
  791. "mysqli",
  792. ext_functions,
  793. PHP_MINIT(mysqli),
  794. PHP_MSHUTDOWN(mysqli),
  795. PHP_RINIT(mysqli),
  796. PHP_RSHUTDOWN(mysqli),
  797. PHP_MINFO(mysqli),
  798. PHP_MYSQLI_VERSION,
  799. PHP_MODULE_GLOBALS(mysqli),
  800. PHP_GINIT(mysqli),
  801. NULL,
  802. NULL,
  803. STANDARD_MODULE_PROPERTIES_EX
  804. };
  805. /* }}} */
  806. #ifdef COMPILE_DL_MYSQLI
  807. #ifdef ZTS
  808. ZEND_TSRMLS_CACHE_DEFINE()
  809. #endif
  810. ZEND_GET_MODULE(mysqli)
  811. #endif
  812. PHP_METHOD(mysqli_stmt, __construct)
  813. {
  814. MY_MYSQL *mysql;
  815. zval *mysql_link;
  816. MY_STMT *stmt;
  817. MYSQLI_RESOURCE *mysqli_resource;
  818. char *statement = NULL;
  819. size_t statement_len;
  820. if (zend_parse_parameters(ZEND_NUM_ARGS(), "O|s!", &mysql_link, mysqli_link_class_entry, &statement, &statement_len) == FAILURE) {
  821. RETURN_THROWS();
  822. }
  823. MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
  824. stmt = (MY_STMT *) ecalloc(1, sizeof(MY_STMT));
  825. if (!(stmt->stmt = mysql_stmt_init(mysql->mysql))) {
  826. efree(stmt);
  827. RETURN_FALSE;
  828. }
  829. #ifndef MYSQLI_USE_MYSQLND
  830. ZVAL_COPY(&stmt->link_handle, mysql_link);
  831. #endif
  832. mysqli_resource = (MYSQLI_RESOURCE *)ecalloc (1, sizeof(MYSQLI_RESOURCE));
  833. mysqli_resource->ptr = (void *)stmt;
  834. mysqli_resource->status = MYSQLI_STATUS_INITIALIZED;
  835. MYSQLI_REGISTER_RESOURCE_EX(mysqli_resource, getThis());
  836. if (statement) {
  837. if(mysql_stmt_prepare(stmt->stmt, statement, statement_len)) {
  838. MYSQLI_REPORT_STMT_ERROR(stmt->stmt);
  839. RETURN_FALSE;
  840. }
  841. mysqli_resource->status = MYSQLI_STATUS_VALID;
  842. }
  843. }
  844. PHP_METHOD(mysqli_result, __construct)
  845. {
  846. MY_MYSQL *mysql;
  847. MYSQL_RES *result = NULL;
  848. zval *mysql_link;
  849. MYSQLI_RESOURCE *mysqli_resource;
  850. zend_long resmode = MYSQLI_STORE_RESULT;
  851. if (zend_parse_parameters(ZEND_NUM_ARGS(), "O|l", &mysql_link, mysqli_link_class_entry, &resmode) == FAILURE) {
  852. RETURN_THROWS();
  853. }
  854. MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
  855. switch (resmode) {
  856. case MYSQLI_STORE_RESULT:
  857. result = mysql_store_result(mysql->mysql);
  858. break;
  859. case MYSQLI_USE_RESULT:
  860. result = mysql_use_result(mysql->mysql);
  861. break;
  862. default:
  863. zend_argument_value_error(2, "must be either MYSQLI_STORE_RESULT or MYSQLI_USE_RESULT");
  864. RETURN_THROWS();
  865. }
  866. if (!result) {
  867. RETURN_FALSE;
  868. }
  869. mysqli_resource = (MYSQLI_RESOURCE *)ecalloc (1, sizeof(MYSQLI_RESOURCE));
  870. mysqli_resource->ptr = (void *)result;
  871. mysqli_resource->status = MYSQLI_STATUS_VALID;
  872. MYSQLI_REGISTER_RESOURCE_EX(mysqli_resource, getThis());
  873. }
  874. PHP_METHOD(mysqli_result, getIterator)
  875. {
  876. if (zend_parse_parameters_none() == FAILURE) {
  877. RETURN_THROWS();
  878. }
  879. zend_create_internal_iterator_zval(return_value, ZEND_THIS);
  880. }
  881. /* {{{ php_mysqli_fetch_into_hash_aux */
  882. void php_mysqli_fetch_into_hash_aux(zval *return_value, MYSQL_RES * result, zend_long fetchtype)
  883. {
  884. #ifndef MYSQLI_USE_MYSQLND
  885. MYSQL_ROW row;
  886. unsigned int i, num_fields;
  887. MYSQL_FIELD *fields;
  888. unsigned long *field_len;
  889. if (!(row = mysql_fetch_row(result))) {
  890. RETURN_NULL();
  891. }
  892. if (fetchtype & MYSQLI_ASSOC) {
  893. fields = mysql_fetch_fields(result);
  894. }
  895. array_init(return_value);
  896. field_len = mysql_fetch_lengths(result);
  897. num_fields = mysql_num_fields(result);
  898. for (i = 0; i < num_fields; i++) {
  899. if (row[i]) {
  900. zval res;
  901. if (mysql_fetch_field_direct(result, i)->type == MYSQL_TYPE_BIT) {
  902. my_ulonglong llval;
  903. char tmp[22];
  904. switch (field_len[i]) {
  905. case 8:llval = (my_ulonglong) bit_uint8korr(row[i]);break;
  906. case 7:llval = (my_ulonglong) bit_uint7korr(row[i]);break;
  907. case 6:llval = (my_ulonglong) bit_uint6korr(row[i]);break;
  908. case 5:llval = (my_ulonglong) bit_uint5korr(row[i]);break;
  909. case 4:llval = (my_ulonglong) bit_uint4korr(row[i]);break;
  910. case 3:llval = (my_ulonglong) bit_uint3korr(row[i]);break;
  911. case 2:llval = (my_ulonglong) bit_uint2korr(row[i]);break;
  912. case 1:llval = (my_ulonglong) uint1korr(row[i]);break;
  913. EMPTY_SWITCH_DEFAULT_CASE()
  914. }
  915. /* even though lval is declared as unsigned, the value
  916. * may be negative. Therefore we cannot use MYSQLI_LLU_SPEC and must
  917. * use MYSQLI_LL_SPEC.
  918. */
  919. snprintf(tmp, sizeof(tmp), (mysql_fetch_field_direct(result, i)->flags & UNSIGNED_FLAG)? MYSQLI_LLU_SPEC : MYSQLI_LL_SPEC, llval);
  920. ZVAL_STRING(&res, tmp);
  921. } else {
  922. ZVAL_STRINGL(&res, row[i], field_len[i]);
  923. }
  924. if (fetchtype & MYSQLI_NUM) {
  925. add_index_zval(return_value, i, &res);
  926. }
  927. if (fetchtype & MYSQLI_ASSOC) {
  928. if (fetchtype & MYSQLI_NUM && Z_REFCOUNTED(res)) {
  929. Z_ADDREF(res);
  930. }
  931. add_assoc_zval(return_value, fields[i].name, &res);
  932. }
  933. } else {
  934. if (fetchtype & MYSQLI_NUM) {
  935. add_index_null(return_value, i);
  936. }
  937. if (fetchtype & MYSQLI_ASSOC) {
  938. add_assoc_null(return_value, fields[i].name);
  939. }
  940. }
  941. }
  942. #else
  943. mysqlnd_fetch_into(result, ((fetchtype & MYSQLI_NUM)? MYSQLND_FETCH_NUM:0) | ((fetchtype & MYSQLI_ASSOC)? MYSQLND_FETCH_ASSOC:0), return_value);
  944. /* TODO: We don't have access to the connection object at this point, so we use low-level
  945. * mysqlnd APIs to access the error information. We should try to pass through the connection
  946. * object instead. */
  947. if (MyG(report_mode) & MYSQLI_REPORT_ERROR) {
  948. MYSQLND_CONN_DATA *conn = result->conn;
  949. unsigned error_no = conn->m->get_error_no(conn);
  950. if (error_no) {
  951. php_mysqli_report_error(
  952. conn->m->get_sqlstate(conn), error_no, conn->m->get_error_str(conn));
  953. }
  954. }
  955. #endif
  956. }
  957. /* }}} */
  958. /* TODO Split this up */
  959. /* {{{ php_mysqli_fetch_into_hash */
  960. void php_mysqli_fetch_into_hash(INTERNAL_FUNCTION_PARAMETERS, int override_flags, int into_object)
  961. {
  962. MYSQL_RES *result;
  963. zval *mysql_result;
  964. zend_long fetchtype;
  965. zval *ctor_params = NULL;
  966. zend_class_entry *ce = NULL;
  967. if (into_object) {
  968. if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O|Ca", &mysql_result, mysqli_result_class_entry, &ce, &ctor_params) == FAILURE) {
  969. RETURN_THROWS();
  970. }
  971. if (ce == NULL) {
  972. ce = zend_standard_class_def;
  973. }
  974. if (UNEXPECTED(ce->ce_flags & (ZEND_ACC_INTERFACE|ZEND_ACC_TRAIT|ZEND_ACC_IMPLICIT_ABSTRACT_CLASS|ZEND_ACC_EXPLICIT_ABSTRACT_CLASS))) {
  975. zend_throw_error(NULL, "Class %s cannot be instantiated", ZSTR_VAL(ce->name));
  976. RETURN_THROWS();
  977. }
  978. fetchtype = MYSQLI_ASSOC;
  979. } else {
  980. if (override_flags) {
  981. if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_result, mysqli_result_class_entry) == FAILURE) {
  982. RETURN_THROWS();
  983. }
  984. fetchtype = override_flags;
  985. } else {
  986. fetchtype = MYSQLI_BOTH;
  987. if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O|l", &mysql_result, mysqli_result_class_entry, &fetchtype) == FAILURE) {
  988. RETURN_THROWS();
  989. }
  990. }
  991. }
  992. MYSQLI_FETCH_RESOURCE(result, MYSQL_RES *, mysql_result, "mysqli_result", MYSQLI_STATUS_VALID);
  993. if (fetchtype < MYSQLI_ASSOC || fetchtype > MYSQLI_BOTH) {
  994. zend_argument_value_error(ERROR_ARG_POS(2), "must be one of MYSQLI_NUM, MYSQLI_ASSOC, or MYSQLI_BOTH");
  995. RETURN_THROWS();
  996. }
  997. php_mysqli_fetch_into_hash_aux(return_value, result, fetchtype);
  998. if (into_object && Z_TYPE_P(return_value) == IS_ARRAY) {
  999. zval dataset, retval;
  1000. zend_fcall_info fci;
  1001. zend_fcall_info_cache fcc;
  1002. ZVAL_COPY_VALUE(&dataset, return_value);
  1003. object_init_ex(return_value, ce);
  1004. HashTable *prop_table = zend_symtable_to_proptable(Z_ARR(dataset));
  1005. zval_ptr_dtor(&dataset);
  1006. if (!ce->default_properties_count && !ce->__set) {
  1007. Z_OBJ_P(return_value)->properties = prop_table;
  1008. } else {
  1009. zend_merge_properties(return_value, prop_table);
  1010. zend_array_release(prop_table);
  1011. }
  1012. if (ce->constructor) {
  1013. fci.size = sizeof(fci);
  1014. ZVAL_UNDEF(&fci.function_name);
  1015. fci.object = Z_OBJ_P(return_value);
  1016. fci.retval = &retval;
  1017. fci.params = NULL;
  1018. fci.param_count = 0;
  1019. fci.named_params = NULL;
  1020. if (ctor_params) {
  1021. if (zend_fcall_info_args(&fci, ctor_params) == FAILURE) {
  1022. ZEND_UNREACHABLE();
  1023. }
  1024. }
  1025. fcc.function_handler = ce->constructor;
  1026. fcc.called_scope = Z_OBJCE_P(return_value);
  1027. fcc.object = Z_OBJ_P(return_value);
  1028. if (zend_call_function(&fci, &fcc) == FAILURE) {
  1029. zend_throw_exception_ex(zend_ce_exception, 0, "Could not execute %s::%s()", ZSTR_VAL(ce->name), ZSTR_VAL(ce->constructor->common.function_name));
  1030. } else {
  1031. zval_ptr_dtor(&retval);
  1032. }
  1033. zend_fcall_info_args_clear(&fci, 1);
  1034. } else if (ctor_params && zend_hash_num_elements(Z_ARRVAL_P(ctor_params)) > 0) {
  1035. zend_argument_error(zend_ce_exception, ERROR_ARG_POS(3),
  1036. "must be empty when the specified class (%s) does not have a constructor",
  1037. ZSTR_VAL(ce->name)
  1038. );
  1039. }
  1040. }
  1041. }
  1042. /* }}} */