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