mysqli_nonapi.c 38 KB

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