mysqli_nonapi.c 38 KB

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