mysqli_nonapi.c 39 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322
  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 "zend_smart_str.h"
  26. #include "php_mysqli_structs.h"
  27. #include "mysqli_priv.h"
  28. #define ERROR_ARG_POS(arg_num) (getThis() ? (arg_num-1) : (arg_num))
  29. #define SAFE_STR(a) ((a)?a:"")
  30. /* {{{ php_mysqli_set_error */
  31. static void php_mysqli_set_error(zend_long mysql_errno, char *mysql_err)
  32. {
  33. MyG(error_no) = mysql_errno;
  34. if (MyG(error_msg)) {
  35. efree(MyG(error_msg));
  36. }
  37. if(mysql_err && *mysql_err) {
  38. MyG(error_msg) = estrdup(mysql_err);
  39. } else {
  40. MyG(error_msg) = NULL;
  41. }
  42. }
  43. /* }}} */
  44. void mysqli_common_connect(INTERNAL_FUNCTION_PARAMETERS, bool is_real_connect, bool in_ctor) /* {{{ */
  45. {
  46. MY_MYSQL *mysql = NULL;
  47. MYSQLI_RESOURCE *mysqli_resource = NULL;
  48. zval *object = getThis();
  49. char *hostname = NULL, *username=NULL, *passwd=NULL, *dbname=NULL, *socket=NULL,
  50. *ssl_key = NULL, *ssl_cert = NULL, *ssl_ca = NULL, *ssl_capath = NULL,
  51. *ssl_cipher = NULL;
  52. size_t hostname_len = 0, username_len = 0, passwd_len = 0, dbname_len = 0, socket_len = 0;
  53. bool persistent = false, ssl = false;
  54. zend_long port = 0, flags = 0;
  55. bool port_is_null = 1;
  56. zend_string *hash_key = NULL;
  57. bool new_connection = false;
  58. zend_resource *le;
  59. mysqli_plist_entry *plist = NULL;
  60. bool self_alloced = 0;
  61. #if !defined(MYSQL_USE_MYSQLND)
  62. if ((MYSQL_VERSION_ID / 100) != (mysql_get_client_version() / 100)) {
  63. php_error_docref(NULL, E_WARNING,
  64. "Headers and client library minor version mismatch. Headers:%d Library:%ld",
  65. MYSQL_VERSION_ID, mysql_get_client_version());
  66. }
  67. #endif
  68. if (getThis() && !ZEND_NUM_ARGS() && in_ctor) {
  69. php_mysqli_init(INTERNAL_FUNCTION_PARAM_PASSTHRU, in_ctor);
  70. return;
  71. }
  72. hostname = username = dbname = passwd = socket = NULL;
  73. if (!is_real_connect) {
  74. if (zend_parse_parameters(ZEND_NUM_ARGS(), "|s!s!s!s!l!s!", &hostname, &hostname_len, &username, &username_len,
  75. &passwd, &passwd_len, &dbname, &dbname_len, &port, &port_is_null, &socket, &socket_len) == FAILURE) {
  76. RETURN_THROWS();
  77. }
  78. if (object) {
  79. ZEND_ASSERT(instanceof_function(Z_OBJCE_P(object), mysqli_link_class_entry));
  80. mysqli_resource = (Z_MYSQLI_P(object))->ptr;
  81. if (mysqli_resource && mysqli_resource->ptr) {
  82. mysql = (MY_MYSQL*) mysqli_resource->ptr;
  83. }
  84. }
  85. if (!mysql) {
  86. mysql = (MY_MYSQL *) ecalloc(1, sizeof(MY_MYSQL));
  87. self_alloced = 1;
  88. }
  89. flags |= CLIENT_MULTI_RESULTS; /* needed for mysql_multi_query() */
  90. } else {
  91. /* We have flags too */
  92. if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O|s!s!s!s!l!s!l", &object, mysqli_link_class_entry,
  93. &hostname, &hostname_len, &username, &username_len, &passwd, &passwd_len, &dbname, &dbname_len, &port, &port_is_null, &socket, &socket_len, &flags) == FAILURE) {
  94. RETURN_THROWS();
  95. }
  96. mysqli_resource = (Z_MYSQLI_P(object))->ptr;
  97. MYSQLI_FETCH_RESOURCE_CONN(mysql, object, MYSQLI_STATUS_INITIALIZED);
  98. /* set some required options */
  99. flags |= CLIENT_MULTI_RESULTS; /* needed for mysql_multi_query() */
  100. /* remove some insecure options */
  101. flags &= ~CLIENT_MULTI_STATEMENTS; /* don't allow multi_queries via connect parameter */
  102. #ifndef MYSQLI_USE_MYSQLND
  103. if (PG(open_basedir) && PG(open_basedir)[0] != '\0') {
  104. flags &= ~CLIENT_LOCAL_FILES;
  105. }
  106. #endif
  107. }
  108. if (!socket_len || !socket) {
  109. socket = MyG(default_socket);
  110. }
  111. if (port_is_null || !port) {
  112. port = MyG(default_port);
  113. }
  114. if (!passwd) {
  115. passwd = MyG(default_pw);
  116. passwd_len = strlen(SAFE_STR(passwd));
  117. }
  118. if (!username){
  119. username = MyG(default_user);
  120. }
  121. if (!hostname || !hostname_len) {
  122. hostname = MyG(default_host);
  123. }
  124. if (mysql->mysql && mysqli_resource &&
  125. (mysqli_resource->status > MYSQLI_STATUS_INITIALIZED))
  126. {
  127. /* already connected, we should close the connection */
  128. php_mysqli_close(mysql, MYSQLI_CLOSE_IMPLICIT, mysqli_resource->status);
  129. }
  130. if (strlen(SAFE_STR(hostname)) > 2 && !strncasecmp(hostname, "p:", 2)) {
  131. hostname += 2;
  132. if (!MyG(allow_persistent)) {
  133. php_error_docref(NULL, E_WARNING, "Persistent connections are disabled. Downgrading to normal");
  134. } else {
  135. mysql->persistent = persistent = true;
  136. hash_key = strpprintf(0, "mysqli_%s_%s" ZEND_LONG_FMT "%s%s%s", SAFE_STR(hostname), SAFE_STR(socket),
  137. port, SAFE_STR(username), SAFE_STR(dbname),
  138. SAFE_STR(passwd));
  139. mysql->hash_key = hash_key;
  140. /* check if we can reuse existing connection ... */
  141. if ((le = zend_hash_find_ptr(&EG(persistent_list), hash_key)) != NULL) {
  142. if (le->type == php_le_pmysqli()) {
  143. plist = (mysqli_plist_entry *) le->ptr;
  144. do {
  145. if (zend_ptr_stack_num_elements(&plist->free_links)) {
  146. /* If we have an initialized (but unconnected) mysql resource,
  147. * close it before we reuse an existing persistent resource. */
  148. if (mysql->mysql) {
  149. mysqli_close(mysql->mysql, MYSQLI_CLOSE_IMPLICIT);
  150. }
  151. mysql->mysql = zend_ptr_stack_pop(&plist->free_links);
  152. MyG(num_inactive_persistent)--;
  153. /* reset variables */
  154. #ifndef MYSQLI_NO_CHANGE_USER_ON_PCONNECT
  155. if (!mysqli_change_user_silent(mysql->mysql, username, passwd, dbname, passwd_len)) {
  156. #else
  157. if (!mysql_ping(mysql->mysql)) {
  158. #endif
  159. #ifdef MYSQLI_USE_MYSQLND
  160. mysqlnd_restart_psession(mysql->mysql);
  161. #endif
  162. MyG(num_active_persistent)++;
  163. /* clear error */
  164. php_mysqli_set_error(mysql_errno(mysql->mysql), (char *) mysql_error(mysql->mysql));
  165. goto end;
  166. } else {
  167. #ifdef MYSQLI_USE_MYSQLND
  168. if (mysql->mysql->data->vio->data->ssl) {
  169. /* copy over pre-existing ssl settings so we can reuse them when reconnecting */
  170. ssl = true;
  171. ssl_key = mysql->mysql->data->vio->data->options.ssl_key ? estrdup(mysql->mysql->data->vio->data->options.ssl_key) : NULL;
  172. ssl_cert = mysql->mysql->data->vio->data->options.ssl_cert ? estrdup(mysql->mysql->data->vio->data->options.ssl_cert) : NULL;
  173. ssl_ca = mysql->mysql->data->vio->data->options.ssl_ca ? estrdup(mysql->mysql->data->vio->data->options.ssl_ca) : NULL;
  174. ssl_capath = mysql->mysql->data->vio->data->options.ssl_capath ? estrdup(mysql->mysql->data->vio->data->options.ssl_capath) : NULL;
  175. ssl_cipher = mysql->mysql->data->vio->data->options.ssl_cipher ? estrdup(mysql->mysql->data->vio->data->options.ssl_cipher) : NULL;
  176. }
  177. #else
  178. if (mysql->mysql->options.ssl_key
  179. || mysql->mysql->options.ssl_cert
  180. || mysql->mysql->options.ssl_ca
  181. || mysql->mysql->options.ssl_capath
  182. || mysql->mysql->options.ssl_cipher) {
  183. /* copy over pre-existing ssl settings so we can reuse them when reconnecting */
  184. ssl = true;
  185. ssl_key = mysql->mysql->options.ssl_key ? estrdup(mysql->mysql->options.ssl_key) : NULL;
  186. ssl_cert = mysql->mysql->options.ssl_cert ? estrdup(mysql->mysql->options.ssl_cert) : NULL;
  187. ssl_ca = mysql->mysql->options.ssl_ca ? estrdup(mysql->mysql->options.ssl_ca) : NULL;
  188. ssl_capath = mysql->mysql->options.ssl_capath ? estrdup(mysql->mysql->options.ssl_capath) : NULL;
  189. ssl_cipher = mysql->mysql->options.ssl_cipher ? estrdup(mysql->mysql->options.ssl_cipher) : NULL;
  190. }
  191. #endif
  192. mysqli_close(mysql->mysql, MYSQLI_CLOSE_IMPLICIT);
  193. mysql->mysql = NULL;
  194. }
  195. }
  196. } while (0);
  197. }
  198. } else {
  199. plist = calloc(1, sizeof(mysqli_plist_entry));
  200. zend_ptr_stack_init_ex(&plist->free_links, 1);
  201. zend_register_persistent_resource(ZSTR_VAL(hash_key), ZSTR_LEN(hash_key), plist, php_le_pmysqli());
  202. }
  203. }
  204. }
  205. if (MyG(max_links) != -1 && MyG(num_links) >= MyG(max_links)) {
  206. php_error_docref(NULL, E_WARNING, "Too many open links (" ZEND_LONG_FMT ")", MyG(num_links));
  207. goto err;
  208. }
  209. if (persistent && MyG(max_persistent) != -1 &&
  210. (MyG(num_active_persistent) + MyG(num_inactive_persistent))>= MyG(max_persistent))
  211. {
  212. php_error_docref(NULL, E_WARNING, "Too many open persistent links (" ZEND_LONG_FMT ")",
  213. MyG(num_active_persistent) + MyG(num_inactive_persistent));
  214. goto err;
  215. }
  216. if (!mysql->mysql) {
  217. #ifndef MYSQLI_USE_MYSQLND
  218. if (!(mysql->mysql = mysql_init(NULL))) {
  219. #else
  220. if (!(mysql->mysql = mysqlnd_init(MYSQLND_CLIENT_NO_FLAG, persistent))) {
  221. #endif
  222. goto err;
  223. }
  224. new_connection = true;
  225. }
  226. #ifndef MYSQLI_USE_MYSQLND
  227. /* BC for prior to bug fix #53425 */
  228. flags |= CLIENT_MULTI_RESULTS;
  229. if (ssl) {
  230. /* if we're here, this means previous conn was ssl, repopulate settings */
  231. mysql_ssl_set(mysql->mysql, ssl_key, ssl_cert, ssl_ca, ssl_capath, ssl_cipher);
  232. if (ssl_key) {
  233. efree(ssl_key);
  234. }
  235. if (ssl_cert) {
  236. efree(ssl_cert);
  237. }
  238. if (ssl_ca) {
  239. efree(ssl_ca);
  240. }
  241. if (ssl_capath) {
  242. efree(ssl_capath);
  243. }
  244. if (ssl_cipher) {
  245. efree(ssl_cipher);
  246. }
  247. }
  248. if (mysql_real_connect(mysql->mysql, hostname, username, passwd, dbname, port, socket, flags) == NULL)
  249. #else
  250. if (ssl) {
  251. /* if we're here, this means previous conn was ssl, repopulate settings */
  252. mysql_ssl_set(mysql->mysql, ssl_key, ssl_cert, ssl_ca, ssl_capath, ssl_cipher);
  253. if (ssl_key) {
  254. efree(ssl_key);
  255. }
  256. if (ssl_cert) {
  257. efree(ssl_cert);
  258. }
  259. if (ssl_ca) {
  260. efree(ssl_ca);
  261. }
  262. if (ssl_capath) {
  263. efree(ssl_capath);
  264. }
  265. if (ssl_cipher) {
  266. efree(ssl_cipher);
  267. }
  268. }
  269. if (mysqlnd_connect(mysql->mysql, hostname, username, passwd, passwd_len, dbname, dbname_len,
  270. port, socket, flags, MYSQLND_CLIENT_NO_FLAG) == NULL)
  271. #endif
  272. {
  273. /* Save error messages - for mysqli_connect_error() & mysqli_connect_errno() */
  274. php_mysqli_set_error(mysql_errno(mysql->mysql), (char *) mysql_error(mysql->mysql));
  275. php_mysqli_throw_sql_exception((char *)mysql_sqlstate(mysql->mysql), mysql_errno(mysql->mysql),
  276. "%s", mysql_error(mysql->mysql));
  277. if (!is_real_connect) {
  278. /* free mysql structure */
  279. mysqli_close(mysql->mysql, MYSQLI_CLOSE_DISCONNECTED);
  280. mysql->mysql = NULL;
  281. }
  282. goto err;
  283. }
  284. /* clear error */
  285. php_mysqli_set_error(mysql_errno(mysql->mysql), (char *) mysql_error(mysql->mysql));
  286. #ifndef MYSQLI_USE_MYSQLND
  287. char reconnect = MyG(reconnect);
  288. mysql_options(mysql->mysql, MYSQL_OPT_RECONNECT, (char *)&reconnect);
  289. #endif
  290. unsigned int allow_local_infile = MyG(allow_local_infile);
  291. mysql_options(mysql->mysql, MYSQL_OPT_LOCAL_INFILE, (char *)&allow_local_infile);
  292. #if (MYSQL_VERSION_ID >= 80021 && !defined(MARIADB_BASE_VERSION)) || defined(MYSQLI_USE_MYSQLND)
  293. if (MyG(local_infile_directory) && !php_check_open_basedir(MyG(local_infile_directory))) {
  294. mysql_options(mysql->mysql, MYSQL_OPT_LOAD_DATA_LOCAL_DIR, MyG(local_infile_directory));
  295. }
  296. #endif
  297. end:
  298. if (!mysqli_resource) {
  299. mysqli_resource = (MYSQLI_RESOURCE *)ecalloc (1, sizeof(MYSQLI_RESOURCE));
  300. mysqli_resource->ptr = (void *)mysql;
  301. }
  302. mysqli_resource->status = MYSQLI_STATUS_VALID;
  303. /* store persistent connection */
  304. if (persistent && (new_connection || is_real_connect)) {
  305. MyG(num_active_persistent)++;
  306. }
  307. MyG(num_links)++;
  308. mysql->multi_query = 0;
  309. if (object) {
  310. ZEND_ASSERT(instanceof_function(Z_OBJCE_P(object), mysqli_link_class_entry));
  311. (Z_MYSQLI_P(object))->ptr = mysqli_resource;
  312. RETURN_TRUE;
  313. } else {
  314. MYSQLI_RETVAL_RESOURCE(mysqli_resource, mysqli_link_class_entry);
  315. return;
  316. }
  317. err:
  318. if (mysql->hash_key) {
  319. zend_string_release_ex(mysql->hash_key, 0);
  320. mysql->hash_key = NULL;
  321. mysql->persistent = false;
  322. }
  323. if (!is_real_connect && self_alloced) {
  324. efree(mysql);
  325. }
  326. RETVAL_FALSE;
  327. } /* }}} */
  328. /* {{{ Open a connection to a mysql server */
  329. PHP_FUNCTION(mysqli_connect)
  330. {
  331. mysqli_common_connect(INTERNAL_FUNCTION_PARAM_PASSTHRU, false, false);
  332. }
  333. /* }}} */
  334. PHP_METHOD(mysqli, __construct)
  335. {
  336. mysqli_common_connect(INTERNAL_FUNCTION_PARAM_PASSTHRU, false, true);
  337. }
  338. /* {{{ Initialize mysqli and return a resource for use with mysql_real_connect */
  339. PHP_METHOD(mysqli, init)
  340. {
  341. php_mysqli_init(INTERNAL_FUNCTION_PARAM_PASSTHRU, true);
  342. }
  343. /* }}} */
  344. /* {{{ Returns the numerical value of the error message from last connect command */
  345. PHP_FUNCTION(mysqli_connect_errno)
  346. {
  347. if (zend_parse_parameters_none() == FAILURE) {
  348. RETURN_THROWS();
  349. }
  350. RETURN_LONG(MyG(error_no));
  351. }
  352. /* }}} */
  353. /* {{{ Returns the text of the error message from previous MySQL operation */
  354. PHP_FUNCTION(mysqli_connect_error)
  355. {
  356. if (zend_parse_parameters_none() == FAILURE) {
  357. RETURN_THROWS();
  358. }
  359. if (MyG(error_msg)) {
  360. RETURN_STRING(MyG(error_msg));
  361. } else {
  362. RETURN_NULL();
  363. }
  364. }
  365. /* }}} */
  366. /* {{{ Fetch a result row as an associative array, a numeric array, or both */
  367. PHP_FUNCTION(mysqli_fetch_array)
  368. {
  369. php_mysqli_fetch_into_hash(INTERNAL_FUNCTION_PARAM_PASSTHRU, 0, 0);
  370. }
  371. /* }}} */
  372. /* {{{ Fetch a result row as an associative array */
  373. PHP_FUNCTION(mysqli_fetch_assoc)
  374. {
  375. php_mysqli_fetch_into_hash(INTERNAL_FUNCTION_PARAM_PASSTHRU, MYSQLI_ASSOC, 0);
  376. }
  377. /* }}} */
  378. /* {{{ Fetch a column from the result row */
  379. PHP_FUNCTION(mysqli_fetch_column)
  380. {
  381. MYSQL_RES *result;
  382. zval *mysql_result;
  383. zval row_array;
  384. zend_long col_no = 0;
  385. if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O|l", &mysql_result, mysqli_result_class_entry, &col_no) == FAILURE) {
  386. RETURN_THROWS();
  387. }
  388. MYSQLI_FETCH_RESOURCE(result, MYSQL_RES*, mysql_result, "mysqli_result", MYSQLI_STATUS_VALID);
  389. if (col_no < 0) {
  390. zend_argument_value_error(ERROR_ARG_POS(2), "must be greater than or equal to 0");
  391. RETURN_THROWS();
  392. }
  393. if (col_no >= mysql_num_fields(result)) {
  394. zend_argument_value_error(ERROR_ARG_POS(2), "must be less than the number of fields for this result set");
  395. RETURN_THROWS();
  396. }
  397. php_mysqli_fetch_into_hash_aux(&row_array, result, MYSQLI_NUM);
  398. if (Z_TYPE(row_array) != IS_ARRAY) {
  399. zval_ptr_dtor_nogc(&row_array);
  400. RETURN_FALSE;
  401. }
  402. ZVAL_COPY(return_value, zend_hash_index_find(Z_ARR(row_array), col_no));
  403. zval_ptr_dtor_nogc(&row_array);
  404. }
  405. /* }}} */
  406. /* {{{ Fetches all result rows as an associative array, a numeric array, or both */
  407. PHP_FUNCTION(mysqli_fetch_all)
  408. {
  409. MYSQL_RES *result;
  410. zval *mysql_result;
  411. zend_long mode = MYSQLI_NUM;
  412. if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O|l", &mysql_result, mysqli_result_class_entry, &mode) == FAILURE) {
  413. RETURN_THROWS();
  414. }
  415. MYSQLI_FETCH_RESOURCE(result, MYSQL_RES *, mysql_result, "mysqli_result", MYSQLI_STATUS_VALID);
  416. if (!mode || (mode & ~MYSQLI_BOTH)) {
  417. zend_argument_value_error(ERROR_ARG_POS(2), "must be one of MYSQLI_NUM, MYSQLI_ASSOC, or MYSQLI_BOTH");
  418. RETURN_THROWS();
  419. }
  420. array_init_size(return_value, mysql_num_rows(result));
  421. zend_ulong i = 0;
  422. do {
  423. zval row;
  424. php_mysqli_fetch_into_hash_aux(&row, result, mode);
  425. if (Z_TYPE(row) != IS_ARRAY) {
  426. zval_ptr_dtor_nogc(&row);
  427. break;
  428. }
  429. add_index_zval(return_value, i++, &row);
  430. } while (1);
  431. }
  432. /* }}} */
  433. #ifdef MYSQLI_USE_MYSQLND
  434. /* {{{ Returns statistics about the zval cache */
  435. PHP_FUNCTION(mysqli_get_client_stats)
  436. {
  437. if (zend_parse_parameters_none() == FAILURE) {
  438. RETURN_THROWS();
  439. }
  440. mysqlnd_get_client_stats(return_value);
  441. }
  442. /* }}} */
  443. /* {{{ Returns statistics about the zval cache */
  444. PHP_FUNCTION(mysqli_get_connection_stats)
  445. {
  446. MY_MYSQL *mysql;
  447. zval *mysql_link;
  448. if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O",
  449. &mysql_link, mysqli_link_class_entry) == FAILURE) {
  450. RETURN_THROWS();
  451. }
  452. MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
  453. mysqlnd_get_connection_stats(mysql->mysql, return_value);
  454. }
  455. #endif
  456. /* }}} */
  457. /* {{{ Fetches all client errors */
  458. PHP_FUNCTION(mysqli_error_list)
  459. {
  460. MY_MYSQL *mysql;
  461. zval *mysql_link;
  462. if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
  463. RETURN_THROWS();
  464. }
  465. MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
  466. #ifdef MYSQLI_USE_MYSQLND
  467. if (1) {
  468. MYSQLND_ERROR_LIST_ELEMENT * message;
  469. zend_llist_position pos;
  470. array_init(return_value);
  471. for (message = (MYSQLND_ERROR_LIST_ELEMENT *) zend_llist_get_first_ex(&mysql->mysql->data->error_info->error_list, &pos);
  472. message;
  473. message = (MYSQLND_ERROR_LIST_ELEMENT *) zend_llist_get_next_ex(&mysql->mysql->data->error_info->error_list, &pos))
  474. {
  475. zval single_error;
  476. array_init(&single_error);
  477. add_assoc_long_ex(&single_error, "errno", sizeof("errno") - 1, message->error_no);
  478. add_assoc_string_ex(&single_error, "sqlstate", sizeof("sqlstate") - 1, message->sqlstate);
  479. add_assoc_string_ex(&single_error, "error", sizeof("error") - 1, message->error);
  480. add_next_index_zval(return_value, &single_error);
  481. }
  482. } else {
  483. RETURN_EMPTY_ARRAY();
  484. }
  485. #else
  486. if (mysql_errno(mysql->mysql)) {
  487. zval single_error;
  488. array_init(return_value);
  489. array_init(&single_error);
  490. add_assoc_long_ex(&single_error, "errno", sizeof("errno") - 1, mysql_errno(mysql->mysql));
  491. add_assoc_string_ex(&single_error, "sqlstate", sizeof("sqlstate") - 1, mysql_sqlstate(mysql->mysql));
  492. add_assoc_string_ex(&single_error, "error", sizeof("error") - 1, mysql_error(mysql->mysql));
  493. add_next_index_zval(return_value, &single_error);
  494. } else {
  495. RETURN_EMPTY_ARRAY();
  496. }
  497. #endif
  498. }
  499. /* }}} */
  500. /* {{{ */
  501. PHP_FUNCTION(mysqli_stmt_error_list)
  502. {
  503. MY_STMT *stmt;
  504. zval *mysql_stmt;
  505. if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) {
  506. RETURN_THROWS();
  507. }
  508. MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_INITIALIZED);
  509. #ifdef MYSQLI_USE_MYSQLND
  510. if (stmt->stmt && stmt->stmt->data && stmt->stmt->data->error_info) {
  511. MYSQLND_ERROR_LIST_ELEMENT * message;
  512. zend_llist_position pos;
  513. array_init(return_value);
  514. for (message = (MYSQLND_ERROR_LIST_ELEMENT *) zend_llist_get_first_ex(&stmt->stmt->data->error_info->error_list, &pos);
  515. message;
  516. message = (MYSQLND_ERROR_LIST_ELEMENT *) zend_llist_get_next_ex(&stmt->stmt->data->error_info->error_list, &pos))
  517. {
  518. zval single_error;
  519. array_init(&single_error);
  520. add_assoc_long_ex(&single_error, "errno", sizeof("errno") - 1, message->error_no);
  521. add_assoc_string_ex(&single_error, "sqlstate", sizeof("sqlstate") - 1, message->sqlstate);
  522. add_assoc_string_ex(&single_error, "error", sizeof("error") - 1, message->error);
  523. add_next_index_zval(return_value, &single_error);
  524. }
  525. } else {
  526. RETURN_EMPTY_ARRAY();
  527. }
  528. #else
  529. if (mysql_stmt_errno(stmt->stmt)) {
  530. zval single_error;
  531. array_init(return_value);
  532. array_init(&single_error);
  533. add_assoc_long_ex(&single_error, "errno", sizeof("errno") - 1, mysql_stmt_errno(stmt->stmt));
  534. add_assoc_string_ex(&single_error, "sqlstate", sizeof("sqlstate") - 1, mysql_stmt_sqlstate(stmt->stmt));
  535. add_assoc_string_ex(&single_error, "error", sizeof("error") - 1, mysql_stmt_error(stmt->stmt));
  536. add_next_index_zval(return_value, &single_error);
  537. } else {
  538. RETURN_EMPTY_ARRAY();
  539. }
  540. #endif
  541. }
  542. /* }}} */
  543. /* {{{ Fetch a result row as an object */
  544. PHP_FUNCTION(mysqli_fetch_object)
  545. {
  546. php_mysqli_fetch_into_hash(INTERNAL_FUNCTION_PARAM_PASSTHRU, MYSQLI_ASSOC, 1);
  547. }
  548. /* }}} */
  549. /* {{{ allows to execute multiple queries */
  550. PHP_FUNCTION(mysqli_multi_query)
  551. {
  552. MY_MYSQL *mysql;
  553. zval *mysql_link;
  554. char *query = NULL;
  555. size_t query_len;
  556. if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "Os", &mysql_link, mysqli_link_class_entry, &query, &query_len) == FAILURE) {
  557. RETURN_THROWS();
  558. }
  559. MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
  560. MYSQLI_ENABLE_MQ;
  561. if (mysql_real_query(mysql->mysql, query, query_len)) {
  562. #ifndef MYSQLI_USE_MYSQLND
  563. char s_error[MYSQL_ERRMSG_SIZE], s_sqlstate[SQLSTATE_LENGTH+1];
  564. unsigned int s_errno;
  565. /* we have to save error information, cause
  566. MYSQLI_DISABLE_MQ will reset error information */
  567. strcpy(s_error, mysql_error(mysql->mysql));
  568. strcpy(s_sqlstate, mysql_sqlstate(mysql->mysql));
  569. s_errno = mysql_errno(mysql->mysql);
  570. #else
  571. MYSQLND_ERROR_INFO error_info = *mysql->mysql->data->error_info;
  572. mysql->mysql->data->error_info->error_list.head = NULL;
  573. mysql->mysql->data->error_info->error_list.tail = NULL;
  574. mysql->mysql->data->error_info->error_list.count = 0;
  575. #endif
  576. MYSQLI_REPORT_MYSQL_ERROR(mysql->mysql);
  577. MYSQLI_DISABLE_MQ;
  578. #ifndef MYSQLI_USE_MYSQLND
  579. /* restore error information */
  580. strcpy(mysql->mysql->net.last_error, s_error);
  581. strcpy(mysql->mysql->net.sqlstate, s_sqlstate);
  582. mysql->mysql->net.last_errno = s_errno;
  583. #else
  584. zend_llist_clean(&mysql->mysql->data->error_info->error_list);
  585. *mysql->mysql->data->error_info = error_info;
  586. #endif
  587. RETURN_FALSE;
  588. }
  589. RETURN_TRUE;
  590. }
  591. /* }}} */
  592. /* {{{ */
  593. PHP_FUNCTION(mysqli_query)
  594. {
  595. MY_MYSQL *mysql;
  596. zval *mysql_link;
  597. MYSQLI_RESOURCE *mysqli_resource;
  598. MYSQL_RES *result = NULL;
  599. char *query = NULL;
  600. size_t query_len;
  601. zend_long resultmode = MYSQLI_STORE_RESULT;
  602. if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "Os|l", &mysql_link, mysqli_link_class_entry, &query, &query_len, &resultmode) == FAILURE) {
  603. RETURN_THROWS();
  604. }
  605. if (!query_len) {
  606. zend_argument_value_error(ERROR_ARG_POS(2), "cannot be empty");
  607. RETURN_THROWS();
  608. }
  609. if ((resultmode & ~MYSQLI_ASYNC) != MYSQLI_USE_RESULT &&
  610. MYSQLI_STORE_RESULT != (resultmode & ~(MYSQLI_ASYNC | MYSQLI_STORE_RESULT_COPY_DATA))
  611. ) {
  612. zend_argument_value_error(ERROR_ARG_POS(3), "must be either MYSQLI_USE_RESULT or MYSQLI_STORE_RESULT"
  613. #ifdef MYSQLI_USE_MYSQLND
  614. " with MYSQLI_ASYNC as an optional bitmask flag"
  615. #endif
  616. );
  617. RETURN_THROWS();
  618. }
  619. MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
  620. MYSQLI_DISABLE_MQ;
  621. #ifdef MYSQLI_USE_MYSQLND
  622. if (resultmode & MYSQLI_ASYNC) {
  623. if (mysqli_async_query(mysql->mysql, query, query_len)) {
  624. MYSQLI_REPORT_MYSQL_ERROR(mysql->mysql);
  625. RETURN_FALSE;
  626. }
  627. mysql->async_result_fetch_type = resultmode & ~MYSQLI_ASYNC;
  628. RETURN_TRUE;
  629. }
  630. #endif
  631. if (mysql_real_query(mysql->mysql, query, query_len)) {
  632. MYSQLI_REPORT_MYSQL_ERROR(mysql->mysql);
  633. RETURN_FALSE;
  634. }
  635. if (!mysql_field_count(mysql->mysql)) {
  636. /* no result set - not a SELECT */
  637. if (MyG(report_mode) & MYSQLI_REPORT_INDEX) {
  638. php_mysqli_report_index(query, mysqli_server_status(mysql->mysql));
  639. }
  640. RETURN_TRUE;
  641. }
  642. #ifdef MYSQLI_USE_MYSQLND
  643. switch (resultmode & ~(MYSQLI_ASYNC | MYSQLI_STORE_RESULT_COPY_DATA)) {
  644. #else
  645. switch (resultmode & ~MYSQLI_ASYNC) {
  646. #endif
  647. case MYSQLI_STORE_RESULT:
  648. result = mysql_store_result(mysql->mysql);
  649. break;
  650. case MYSQLI_USE_RESULT:
  651. result = mysql_use_result(mysql->mysql);
  652. break;
  653. }
  654. if (!result) {
  655. php_mysqli_throw_sql_exception((char *)mysql_sqlstate(mysql->mysql), mysql_errno(mysql->mysql),
  656. "%s", mysql_error(mysql->mysql));
  657. RETURN_FALSE;
  658. }
  659. if (MyG(report_mode) & MYSQLI_REPORT_INDEX) {
  660. php_mysqli_report_index(query, mysqli_server_status(mysql->mysql));
  661. }
  662. mysqli_resource = (MYSQLI_RESOURCE *)ecalloc (1, sizeof(MYSQLI_RESOURCE));
  663. mysqli_resource->ptr = (void *)result;
  664. mysqli_resource->status = MYSQLI_STATUS_VALID;
  665. MYSQLI_RETVAL_RESOURCE(mysqli_resource, mysqli_result_class_entry);
  666. }
  667. /* }}} */
  668. #ifdef MYSQLI_USE_MYSQLND
  669. #include "php_network.h"
  670. /* {{{ mysqlnd_zval_array_to_mysqlnd_array functions */
  671. static int mysqlnd_zval_array_to_mysqlnd_array(zval *in_array, MYSQLND ***out_array)
  672. {
  673. zval *elem;
  674. int i = 0, current = 0;
  675. if (Z_TYPE_P(in_array) != IS_ARRAY) {
  676. return SUCCESS;
  677. }
  678. *out_array = ecalloc(zend_hash_num_elements(Z_ARRVAL_P(in_array)) + 1, sizeof(MYSQLND *));
  679. ZEND_HASH_FOREACH_VAL(Z_ARRVAL_P(in_array), elem) {
  680. i++;
  681. if (Z_TYPE_P(elem) != IS_OBJECT ||
  682. !instanceof_function(Z_OBJCE_P(elem), mysqli_link_class_entry)) {
  683. zend_argument_type_error(i, "must be an instance of mysqli, %s given", zend_zval_type_name(elem));
  684. return FAILURE;
  685. } else {
  686. MY_MYSQL *mysql;
  687. MYSQLI_RESOURCE *my_res;
  688. mysqli_object *intern = Z_MYSQLI_P(elem);
  689. if (!(my_res = (MYSQLI_RESOURCE *)intern->ptr)) {
  690. zend_throw_error(NULL, "%s object is already closed", ZSTR_VAL(intern->zo.ce->name));
  691. return FAILURE;
  692. }
  693. mysql = (MY_MYSQL*) my_res->ptr;
  694. if (my_res->status < MYSQLI_STATUS_VALID) {
  695. zend_throw_error(NULL, "%s object is not fully initialized", ZSTR_VAL(intern->zo.ce->name));
  696. return FAILURE;
  697. }
  698. (*out_array)[current++] = mysql->mysql;
  699. }
  700. } ZEND_HASH_FOREACH_END();
  701. return SUCCESS;
  702. }
  703. /* }}} */
  704. /* {{{ mysqlnd_zval_array_from_mysqlnd_array */
  705. static int mysqlnd_zval_array_from_mysqlnd_array(MYSQLND **in_array, zval *out_array)
  706. {
  707. MYSQLND **p = in_array;
  708. zval dest_array;
  709. zval *elem, *dest_elem;
  710. int ret = 0;
  711. array_init_size(&dest_array, zend_hash_num_elements(Z_ARRVAL_P(out_array)));
  712. ZEND_HASH_FOREACH_VAL(Z_ARRVAL_P(out_array), elem) {
  713. if (Z_TYPE_P(elem) != IS_OBJECT ||
  714. !instanceof_function(Z_OBJCE_P(elem), mysqli_link_class_entry)) {
  715. continue;
  716. }
  717. {
  718. MY_MYSQL *mysql;
  719. MYSQLI_RESOURCE *my_res;
  720. mysqli_object *intern = Z_MYSQLI_P(elem);
  721. if (!(my_res = (MYSQLI_RESOURCE *)intern->ptr)) {
  722. zend_throw_error(NULL, "%s object is already closed", ZSTR_VAL(intern->zo.ce->name));
  723. return FAILURE;
  724. }
  725. mysql = (MY_MYSQL *) my_res->ptr;
  726. if (mysql->mysql == *p) {
  727. dest_elem = zend_hash_next_index_insert(Z_ARRVAL(dest_array), elem);
  728. if (dest_elem) {
  729. zval_add_ref(dest_elem);
  730. }
  731. ret++;
  732. p++;
  733. }
  734. }
  735. } ZEND_HASH_FOREACH_END();
  736. /* destroy old array and add new one */
  737. zval_ptr_dtor(out_array);
  738. ZVAL_COPY_VALUE(out_array, &dest_array);
  739. return 0;
  740. }
  741. /* }}} */
  742. /* {{{ mysqlnd_dont_poll_zval_array_from_mysqlnd_array */
  743. static int mysqlnd_dont_poll_zval_array_from_mysqlnd_array(MYSQLND **in_array, zval *in_zval_array, zval *out_array)
  744. {
  745. MYSQLND **p = in_array;
  746. zval proxy, *elem, *dest_elem;
  747. int ret = 0;
  748. array_init(&proxy);
  749. if (in_array) {
  750. ZEND_HASH_FOREACH_VAL(Z_ARRVAL_P(in_zval_array), elem) {
  751. MY_MYSQL *mysql;
  752. mysqli_object *intern = Z_MYSQLI_P(elem);
  753. mysql = (MY_MYSQL *)((MYSQLI_RESOURCE *)intern->ptr)->ptr;
  754. if (mysql->mysql == *p) {
  755. dest_elem = zend_hash_next_index_insert(Z_ARRVAL(proxy), elem);
  756. if (dest_elem) {
  757. zval_add_ref(dest_elem);
  758. }
  759. ret++;
  760. p++;
  761. }
  762. } ZEND_HASH_FOREACH_END();
  763. }
  764. /* destroy old array and add new one */
  765. zval_ptr_dtor(out_array);
  766. ZVAL_COPY_VALUE(out_array, &proxy);
  767. return 0;
  768. }
  769. /* }}} */
  770. /* {{{ Poll connections */
  771. PHP_FUNCTION(mysqli_poll)
  772. {
  773. zval *r_array, *e_array, *dont_poll_array;
  774. MYSQLND **new_r_array = NULL, **new_e_array = NULL, **new_dont_poll_array = NULL;
  775. zend_long sec = 0, usec = 0;
  776. enum_func_status ret;
  777. int desc_num;
  778. if (zend_parse_parameters(ZEND_NUM_ARGS(), "a!a!al|l", &r_array, &e_array, &dont_poll_array, &sec, &usec) == FAILURE) {
  779. RETURN_THROWS();
  780. }
  781. if (sec < 0) {
  782. zend_argument_value_error(4, "must be greater than or equal to 0");
  783. RETURN_THROWS();
  784. }
  785. if (usec < 0) {
  786. zend_argument_value_error(5, "must be greater than or equal to 0");
  787. RETURN_THROWS();
  788. }
  789. // TODO Error promotion
  790. if (!r_array && !e_array) {
  791. php_error_docref(NULL, E_WARNING, "No stream arrays were passed");
  792. RETURN_FALSE;
  793. }
  794. if (r_array != NULL) {
  795. if (mysqlnd_zval_array_to_mysqlnd_array(r_array, &new_r_array) == FAILURE) {
  796. efree(new_r_array);
  797. RETURN_THROWS();
  798. }
  799. }
  800. if (e_array != NULL) {
  801. if (mysqlnd_zval_array_to_mysqlnd_array(e_array, &new_e_array) == FAILURE) {
  802. efree(new_e_array);
  803. efree(new_r_array);
  804. RETURN_THROWS();
  805. }
  806. }
  807. ret = mysqlnd_poll(new_r_array, new_e_array, &new_dont_poll_array, sec, usec, &desc_num);
  808. mysqlnd_dont_poll_zval_array_from_mysqlnd_array(r_array != NULL ? new_dont_poll_array:NULL, r_array, dont_poll_array);
  809. if (r_array != NULL) {
  810. mysqlnd_zval_array_from_mysqlnd_array(new_r_array, r_array);
  811. }
  812. if (e_array != NULL) {
  813. mysqlnd_zval_array_from_mysqlnd_array(new_e_array, e_array);
  814. }
  815. if (new_dont_poll_array) {
  816. efree(new_dont_poll_array);
  817. }
  818. if (new_r_array) {
  819. efree(new_r_array);
  820. }
  821. if (new_e_array) {
  822. efree(new_e_array);
  823. }
  824. if (ret == PASS) {
  825. RETURN_LONG(desc_num);
  826. } else {
  827. RETURN_FALSE;
  828. }
  829. }
  830. /* }}} */
  831. /* {{{ Poll connections */
  832. PHP_FUNCTION(mysqli_reap_async_query)
  833. {
  834. MY_MYSQL *mysql;
  835. zval *mysql_link;
  836. MYSQLI_RESOURCE *mysqli_resource;
  837. MYSQL_RES *result = NULL;
  838. if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
  839. RETURN_THROWS();
  840. }
  841. MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
  842. if (FAIL == mysqlnd_reap_async_query(mysql->mysql)) {
  843. MYSQLI_REPORT_MYSQL_ERROR(mysql->mysql);
  844. RETURN_FALSE;
  845. }
  846. if (!mysql_field_count(mysql->mysql)) {
  847. /* no result set - not a SELECT */
  848. if (MyG(report_mode) & MYSQLI_REPORT_INDEX) {
  849. /* php_mysqli_report_index("n/a", mysqli_server_status(mysql->mysql)); */
  850. }
  851. RETURN_TRUE;
  852. }
  853. switch (mysql->async_result_fetch_type) {
  854. case MYSQLI_STORE_RESULT:
  855. result = mysql_store_result(mysql->mysql);
  856. break;
  857. case MYSQLI_USE_RESULT:
  858. result = mysql_use_result(mysql->mysql);
  859. break;
  860. }
  861. if (!result) {
  862. MYSQLI_REPORT_MYSQL_ERROR(mysql->mysql);
  863. RETURN_FALSE;
  864. }
  865. if (MyG(report_mode) & MYSQLI_REPORT_INDEX) {
  866. /* php_mysqli_report_index("n/a", mysqli_server_status(mysql->mysql)); */
  867. }
  868. mysqli_resource = (MYSQLI_RESOURCE *)ecalloc (1, sizeof(MYSQLI_RESOURCE));
  869. mysqli_resource->ptr = (void *)result;
  870. mysqli_resource->status = MYSQLI_STATUS_VALID;
  871. MYSQLI_RETVAL_RESOURCE(mysqli_resource, mysqli_result_class_entry);
  872. }
  873. /* }}} */
  874. /* {{{ Buffer result set on client */
  875. PHP_FUNCTION(mysqli_stmt_get_result)
  876. {
  877. MYSQL_RES *result;
  878. MYSQLI_RESOURCE *mysqli_resource;
  879. MY_STMT *stmt;
  880. zval *mysql_stmt;
  881. if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) {
  882. RETURN_THROWS();
  883. }
  884. MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_VALID);
  885. if (!(result = mysqlnd_stmt_get_result(stmt->stmt))) {
  886. MYSQLI_REPORT_STMT_ERROR(stmt->stmt);
  887. RETURN_FALSE;
  888. }
  889. mysqli_resource = (MYSQLI_RESOURCE *)ecalloc (1, sizeof(MYSQLI_RESOURCE));
  890. mysqli_resource->ptr = (void *)result;
  891. mysqli_resource->status = MYSQLI_STATUS_VALID;
  892. MYSQLI_RETVAL_RESOURCE(mysqli_resource, mysqli_result_class_entry);
  893. }
  894. /* }}} */
  895. #endif
  896. /* {{{ */
  897. PHP_FUNCTION(mysqli_get_warnings)
  898. {
  899. MY_MYSQL *mysql;
  900. zval *mysql_link;
  901. MYSQLI_RESOURCE *mysqli_resource;
  902. MYSQLI_WARNING *w = NULL;
  903. if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
  904. RETURN_THROWS();
  905. }
  906. MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
  907. if (mysql_warning_count(mysql->mysql)) {
  908. #ifdef MYSQLI_USE_MYSQLND
  909. w = php_get_warnings(mysql->mysql->data);
  910. #else
  911. w = php_get_warnings(mysql->mysql);
  912. #endif
  913. }
  914. if (!w) {
  915. RETURN_FALSE;
  916. }
  917. mysqli_resource = (MYSQLI_RESOURCE *)ecalloc (1, sizeof(MYSQLI_RESOURCE));
  918. mysqli_resource->ptr = mysqli_resource->info = (void *)w;
  919. mysqli_resource->status = MYSQLI_STATUS_VALID;
  920. MYSQLI_RETVAL_RESOURCE(mysqli_resource, mysqli_warning_class_entry);
  921. }
  922. /* }}} */
  923. /* {{{ */
  924. PHP_FUNCTION(mysqli_stmt_get_warnings)
  925. {
  926. MY_STMT *stmt;
  927. zval *stmt_link;
  928. MYSQLI_RESOURCE *mysqli_resource;
  929. MYSQLI_WARNING *w = NULL;
  930. if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &stmt_link, mysqli_stmt_class_entry) == FAILURE) {
  931. RETURN_THROWS();
  932. }
  933. MYSQLI_FETCH_RESOURCE_STMT(stmt, stmt_link, MYSQLI_STATUS_VALID);
  934. if (mysqli_stmt_warning_count(stmt->stmt)) {
  935. w = php_get_warnings(mysqli_stmt_get_connection(stmt->stmt));
  936. }
  937. if (!w) {
  938. RETURN_FALSE;
  939. }
  940. mysqli_resource = (MYSQLI_RESOURCE *)ecalloc (1, sizeof(MYSQLI_RESOURCE));
  941. mysqli_resource->ptr = mysqli_resource->info = (void *)w;
  942. mysqli_resource->status = MYSQLI_STATUS_VALID;
  943. MYSQLI_RETVAL_RESOURCE(mysqli_resource, mysqli_warning_class_entry);
  944. }
  945. /* }}} */
  946. /* {{{ sets client character set */
  947. PHP_FUNCTION(mysqli_set_charset)
  948. {
  949. MY_MYSQL *mysql;
  950. zval *mysql_link;
  951. char *cs_name;
  952. size_t csname_len;
  953. if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "Os", &mysql_link, mysqli_link_class_entry, &cs_name, &csname_len) == FAILURE) {
  954. RETURN_THROWS();
  955. }
  956. MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
  957. if (mysql_set_character_set(mysql->mysql, cs_name)) {
  958. MYSQLI_REPORT_MYSQL_ERROR(mysql->mysql);
  959. RETURN_FALSE;
  960. }
  961. RETURN_TRUE;
  962. }
  963. /* }}} */
  964. /* {{{ returns a character set object */
  965. PHP_FUNCTION(mysqli_get_charset)
  966. {
  967. MY_MYSQL *mysql;
  968. zval *mysql_link;
  969. const char *name = NULL, *collation = NULL, *dir = NULL, *comment = NULL;
  970. uint32_t minlength, maxlength, number, state;
  971. #ifndef MYSQLI_USE_MYSQLND
  972. MY_CHARSET_INFO cs;
  973. #else
  974. const MYSQLND_CHARSET *cs;
  975. #endif
  976. if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
  977. RETURN_THROWS();
  978. }
  979. MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
  980. #ifndef MYSQLI_USE_MYSQLND
  981. mysql_get_character_set_info(mysql->mysql, &cs);
  982. name = (char *)cs.csname;
  983. collation = (char *)cs.name;
  984. dir = (char *)cs.dir;
  985. minlength = cs.mbminlen;
  986. maxlength = cs.mbmaxlen;
  987. number = cs.number;
  988. state = cs.state;
  989. comment = cs.comment;
  990. #else
  991. cs = mysql->mysql->data->charset;
  992. if (!cs) {
  993. php_error_docref(NULL, E_WARNING, "The connection has no charset associated");
  994. RETURN_NULL();
  995. }
  996. name = cs->name;
  997. collation = cs->collation;
  998. minlength = cs->char_minlen;
  999. maxlength = cs->char_maxlen;
  1000. number = cs->nr;
  1001. comment = cs->comment;
  1002. state = 1; /* all charsets are compiled in */
  1003. #endif
  1004. object_init(return_value);
  1005. add_property_string(return_value, "charset", (name) ? (char *)name : "");
  1006. add_property_string(return_value, "collation",(collation) ? (char *)collation : "");
  1007. add_property_string(return_value, "dir", (dir) ? (char *)dir : "");
  1008. add_property_long(return_value, "min_length", minlength);
  1009. add_property_long(return_value, "max_length", maxlength);
  1010. add_property_long(return_value, "number", number);
  1011. add_property_long(return_value, "state", state);
  1012. add_property_string(return_value, "comment", (comment) ? (char *)comment : "");
  1013. }
  1014. /* }}} */
  1015. #ifndef MYSQLI_USE_MYSQLND
  1016. extern char * mysqli_escape_string_for_tx_name_in_comment(const char * const name);
  1017. /* {{{ */
  1018. static int mysqli_begin_transaction_libmysql(MYSQL * conn, const unsigned int mode, const char * const name)
  1019. {
  1020. int ret;
  1021. smart_str tmp_str = {0};
  1022. char * name_esc;
  1023. char * query;
  1024. unsigned int query_len;
  1025. if (mode & TRANS_START_WITH_CONSISTENT_SNAPSHOT) {
  1026. if (tmp_str.s) {
  1027. smart_str_appendl(&tmp_str, ", ", sizeof(", ") - 1);
  1028. }
  1029. smart_str_appendl(&tmp_str, "WITH CONSISTENT SNAPSHOT", sizeof("WITH CONSISTENT SNAPSHOT") - 1);
  1030. }
  1031. if (mode & TRANS_START_READ_WRITE) {
  1032. if (tmp_str.s) {
  1033. smart_str_appendl(&tmp_str, ", ", sizeof(", ") - 1);
  1034. }
  1035. smart_str_appendl(&tmp_str, "READ WRITE", sizeof("READ WRITE") - 1);
  1036. } else if (mode & TRANS_START_READ_ONLY) {
  1037. if (tmp_str.s) {
  1038. smart_str_appendl(&tmp_str, ", ", sizeof(", ") - 1);
  1039. }
  1040. smart_str_appendl(&tmp_str, "READ ONLY", sizeof("READ ONLY") - 1);
  1041. }
  1042. smart_str_0(&tmp_str);
  1043. name_esc = mysqli_escape_string_for_tx_name_in_comment(name);
  1044. query_len = spprintf(&query, 0, "START TRANSACTION%s %s",
  1045. name_esc? name_esc:"", tmp_str.s? ZSTR_VAL(tmp_str.s):"");
  1046. smart_str_free(&tmp_str);
  1047. if (name_esc) {
  1048. efree(name_esc);
  1049. }
  1050. ret = mysql_real_query(conn, query, query_len);
  1051. efree(query);
  1052. if (ret && mode & (TRANS_START_READ_WRITE | TRANS_START_READ_ONLY) && mysql_errno(conn) == 1064) {
  1053. php_error_docref(NULL, E_WARNING, "This server version doesn't support 'READ WRITE' and 'READ ONLY'. Minimum 5.6.5 is required");
  1054. }
  1055. return ret;
  1056. }
  1057. /* }}} */
  1058. #endif
  1059. /* {{{ Starts a transaction */
  1060. PHP_FUNCTION(mysqli_begin_transaction)
  1061. {
  1062. MY_MYSQL *mysql;
  1063. zval *mysql_link;
  1064. zend_long flags = TRANS_START_NO_OPT;
  1065. char * name = NULL;
  1066. size_t name_len = 0;
  1067. if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O|ls!", &mysql_link, mysqli_link_class_entry, &flags, &name, &name_len) == FAILURE) {
  1068. RETURN_THROWS();
  1069. }
  1070. MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
  1071. if (flags < 0) {
  1072. zend_argument_value_error(ERROR_ARG_POS(2), "must be one of the MYSQLI_TRANS_* constants");
  1073. RETURN_THROWS();
  1074. }
  1075. if (name && !name_len) {
  1076. zend_argument_value_error(ERROR_ARG_POS(3), "cannot be empty");
  1077. RETURN_THROWS();
  1078. }
  1079. #ifndef MYSQLI_USE_MYSQLND
  1080. if (mysqli_begin_transaction_libmysql(mysql->mysql, flags, name)) {
  1081. RETURN_FALSE;
  1082. }
  1083. #else
  1084. if (FAIL == mysqlnd_begin_transaction(mysql->mysql, flags, name)) {
  1085. RETURN_FALSE;
  1086. }
  1087. #endif
  1088. RETURN_TRUE;
  1089. }
  1090. /* }}} */
  1091. #ifndef MYSQLI_USE_MYSQLND
  1092. /* {{{ */
  1093. static int mysqli_savepoint_libmysql(MYSQL * conn, const char * const name, bool release)
  1094. {
  1095. int ret;
  1096. char * query;
  1097. unsigned int query_len = spprintf(&query, 0, release? "RELEASE SAVEPOINT `%s`":"SAVEPOINT `%s`", name);
  1098. ret = mysql_real_query(conn, query, query_len);
  1099. efree(query);
  1100. return ret;
  1101. }
  1102. /* }}} */
  1103. #endif
  1104. /* {{{ Starts a transaction */
  1105. PHP_FUNCTION(mysqli_savepoint)
  1106. {
  1107. MY_MYSQL *mysql;
  1108. zval *mysql_link;
  1109. char * name = NULL;
  1110. size_t name_len;
  1111. if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "Os", &mysql_link, mysqli_link_class_entry, &name, &name_len) == FAILURE) {
  1112. RETURN_THROWS();
  1113. }
  1114. MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
  1115. if (name_len == 0) {
  1116. zend_argument_value_error(ERROR_ARG_POS(2), "cannot be empty");
  1117. RETURN_THROWS();
  1118. }
  1119. #ifndef MYSQLI_USE_MYSQLND
  1120. if (mysqli_savepoint_libmysql(mysql->mysql, name, false)) {
  1121. #else
  1122. if (FAIL == mysqlnd_savepoint(mysql->mysql, name)) {
  1123. #endif
  1124. RETURN_FALSE;
  1125. }
  1126. RETURN_TRUE;
  1127. }
  1128. /* }}} */
  1129. /* {{{ Starts a transaction */
  1130. PHP_FUNCTION(mysqli_release_savepoint)
  1131. {
  1132. MY_MYSQL *mysql;
  1133. zval *mysql_link;
  1134. char * name = NULL;
  1135. size_t name_len;
  1136. if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "Os", &mysql_link, mysqli_link_class_entry, &name, &name_len) == FAILURE) {
  1137. RETURN_THROWS();
  1138. }
  1139. MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
  1140. if (name_len == 0) {
  1141. zend_argument_value_error(ERROR_ARG_POS(2), "cannot be empty");
  1142. RETURN_THROWS();
  1143. }
  1144. #ifndef MYSQLI_USE_MYSQLND
  1145. if (mysqli_savepoint_libmysql(mysql->mysql, name, true)) {
  1146. #else
  1147. if (FAIL == mysqlnd_release_savepoint(mysql->mysql, name)) {
  1148. #endif
  1149. RETURN_FALSE;
  1150. }
  1151. RETURN_TRUE;
  1152. }
  1153. /* }}} */
  1154. /* {{{ Returns information about open and cached links */
  1155. PHP_FUNCTION(mysqli_get_links_stats)
  1156. {
  1157. if (zend_parse_parameters_none() == FAILURE) {
  1158. RETURN_THROWS();
  1159. }
  1160. array_init(return_value);
  1161. add_assoc_long_ex(return_value, "total", sizeof("total") - 1, MyG(num_links));
  1162. add_assoc_long_ex(return_value, "active_plinks", sizeof("active_plinks") - 1, MyG(num_active_persistent));
  1163. add_assoc_long_ex(return_value, "cached_plinks", sizeof("cached_plinks") - 1, MyG(num_inactive_persistent));
  1164. }
  1165. /* }}} */