diff options
Diffstat (limited to 'ext/mysqli/mysqli_api.c')
-rw-r--r-- | ext/mysqli/mysqli_api.c | 1931 |
1 files changed, 0 insertions, 1931 deletions
diff --git a/ext/mysqli/mysqli_api.c b/ext/mysqli/mysqli_api.c deleted file mode 100644 index 550e1bc9bf..0000000000 --- a/ext/mysqli/mysqli_api.c +++ /dev/null @@ -1,1931 +0,0 @@ -/* - +----------------------------------------------------------------------+ - | PHP Version 5 | - +----------------------------------------------------------------------+ - | Copyright (c) 1997-2004 The PHP Group | - +----------------------------------------------------------------------+ - | This source file is subject to version 3.0 of the PHP license, | - | that is bundled with this package in the file LICENSE, and is | - | available through the world-wide-web at the following url: | - | http://www.php.net/license/3_0.txt. | - | If you did not receive a copy of the PHP license and are unable to | - | obtain it through the world-wide-web, please send a note to | - | license@php.net so we can mail you a copy immediately. | - +----------------------------------------------------------------------+ - | Author: Georg Richter <georg@php.net> | - +----------------------------------------------------------------------+ - - $Id$ -*/ - -#ifdef HAVE_CONFIG_H -#include "config.h" -#endif - -#include <signal.h> - -#include "php.h" -#include "php_ini.h" -#include "ext/standard/info.h" -#include "php_mysqli.h" - - -/* {{{ proto mixed mysqli_affected_rows(object link) - Get number of affected rows in previous MySQL operation */ -PHP_FUNCTION(mysqli_affected_rows) -{ - MYSQL *mysql; - zval *mysql_link; - my_ulonglong rc; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - rc = mysql_affected_rows(mysql); - MYSQLI_RETURN_LONG_LONG(rc); -} -/* }}} */ - -/* {{{ proto bool mysqli_autocommit(object link, bool mode) - Turn auto commit on or of */ -PHP_FUNCTION(mysqli_autocommit) -{ - MYSQL *mysql; - zval *mysql_link; - unsigned long rc; - unsigned long automode; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "Ob", &mysql_link, mysqli_link_class_entry, &automode) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - rc = (long) mysql_autocommit(mysql, automode); - - RETURN_BOOL(rc); -} -/* }}} */ - -/* {{{ proto bool mysqli_bind_param(object stmt, array types, mixed variable [,mixed,....]) - Bind variables to a prepared statement as parameters */ -PHP_FUNCTION(mysqli_bind_param) -{ - zval ***args; - int argc = ZEND_NUM_ARGS(); - int i; - int num_vars; - int start = 2; - int ofs; - STMT *stmt; - zval *mysql_stmt; - MYSQL_BIND *bind; - zval *types; - HashPosition hpos; - unsigned long rc; - - /* calculate and check number of parameters */ - num_vars = argc - 1; - if (!getThis()) { - /* ignore handle parameter in procedural interface*/ - --num_vars; - } - if (argc < 2) { - /* there has to be at least one pair */ - WRONG_PARAM_COUNT; - } - - if (zend_parse_method_parameters((getThis()) ? 1:2 TSRMLS_CC, getThis(), "Oa", &mysql_stmt, mysqli_stmt_class_entry, &types) == FAILURE) { - return; - } - - MYSQLI_FETCH_RESOURCE(stmt, STMT *, &mysql_stmt, "mysqli_stmt"); - - if (getThis()) { - start = 1; - } - - if (zend_hash_num_elements(Z_ARRVAL_P(types)) != argc - start) { - /* number of bind variables doesn't match number of elements in array */ - php_error_docref(NULL TSRMLS_CC, E_WARNING, "Number of elements in type array doesn't match number of bind variables"); - } - - /* prevent leak if variables are already bound */ - if (stmt->param.var_cnt) { - php_free_stmt_bind_buffer(stmt->param, FETCH_SIMPLE); - } - - args = (zval ***)safe_emalloc(argc, sizeof(zval **), 0); - - if (zend_get_parameters_array_ex(argc, args) == FAILURE) { - efree(args); - WRONG_PARAM_COUNT; - } - - stmt->param.is_null = ecalloc(num_vars, sizeof(char)); - bind = (MYSQL_BIND *)ecalloc(num_vars, sizeof(MYSQL_BIND)); - - zend_hash_internal_pointer_reset_ex(Z_ARRVAL_P(types), &hpos); - - ofs = 0; - for (i=start; i < argc; i++) { - zval **ctype; - - zend_hash_get_current_data_ex(Z_ARRVAL_P(types), (void **)&ctype, &hpos); - - /* set specified type */ - switch (Z_LVAL_PP(ctype)) { - case MYSQLI_BIND_DOUBLE: - bind[ofs].buffer_type = MYSQL_TYPE_DOUBLE; - bind[ofs].buffer = (gptr)&Z_DVAL_PP(args[i]); - bind[ofs].is_null = &stmt->param.is_null[ofs]; - break; - - case MYSQLI_BIND_INT: - bind[ofs].buffer_type = MYSQL_TYPE_LONG; - bind[ofs].buffer = (gptr)&Z_LVAL_PP(args[i]); - bind[ofs].is_null = &stmt->param.is_null[ofs]; - break; - - case MYSQLI_BIND_SEND_DATA: - bind[ofs].buffer_type = MYSQL_TYPE_VAR_STRING; - bind[ofs].is_null = 0; - bind[ofs].length = 0; - break; - - case MYSQLI_BIND_STRING: - bind[ofs].buffer_type = MYSQL_TYPE_VAR_STRING; - bind[ofs].buffer = NULL; - bind[ofs].buffer_length = 0; - bind[ofs].is_null = &stmt->param.is_null[ofs]; - break; - - default: - php_error_docref(NULL TSRMLS_CC, E_WARNING, "Undefined fieldtype %ld (parameter %d)", Z_LVAL_PP(args[i]), i+1); - efree(args); - efree(bind); - RETURN_FALSE; - break; - } - ofs++; - zend_hash_move_forward_ex(Z_ARRVAL_P(types), &hpos); - } - - rc = mysql_bind_param(stmt->stmt, bind); - MYSQLI_REPORT_STMT_ERROR(stmt->stmt); - - if (rc) { - efree(args); - efree(bind); - RETURN_FALSE; - } - - stmt->param.var_cnt = num_vars; - stmt->param.vars = (zval **)safe_emalloc(num_vars, sizeof(zval), 0); - for (i = 0; i < num_vars; i++) { - if (bind[i].buffer_type != MYSQLI_BIND_SEND_DATA) { - ZVAL_ADDREF(*args[i+start]); - stmt->param.vars[i] = *args[i+start]; - } else { - stmt->param.vars[i] = NULL; - } - } - efree(args); - efree(bind); - - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto bool mysqli_bind_result(object stmt, mixed var, [,mixed, ...]) - Bind variables to a prepared statement for result storage */ - -/* TODO: - do_alloca, free_alloca -*/ - -PHP_FUNCTION(mysqli_bind_result) -{ - zval ***args; - int argc = ZEND_NUM_ARGS(); - int i; - int start = 1; - int var_cnt; - int ofs; - long col_type; - ulong rc; - STMT *stmt; - zval *mysql_stmt; - MYSQL_BIND *bind; - - if (argc < (getThis() ? 1 : 2)) { - WRONG_PARAM_COUNT; - } - - args = (zval ***)safe_emalloc(argc, sizeof(zval **), 0); - - if (zend_get_parameters_array_ex(argc, args) == FAILURE) { - efree(args); - WRONG_PARAM_COUNT; - } - - if (getThis()) { - start = 0; - } - - if (zend_parse_method_parameters((getThis()) ? 0:1 TSRMLS_CC, getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) { - return; - } - - MYSQLI_FETCH_RESOURCE(stmt, STMT *, &mysql_stmt, "mysqli_stmt"); - - var_cnt = argc - start; - - /* prevent leak if variables are already bound */ - if (stmt->result.var_cnt) { - php_free_stmt_bind_buffer(stmt->result, FETCH_RESULT); - } - - bind = (MYSQL_BIND *)ecalloc(var_cnt, sizeof(MYSQL_BIND)); - stmt->result.buf = (VAR_BUFFER *)ecalloc(var_cnt,sizeof(VAR_BUFFER)); - stmt->result.is_null = (char *)ecalloc(var_cnt, sizeof(char)); - - for (i=start; i < var_cnt + start ; i++) { - ofs = i - start; - stmt->result.is_null[ofs] = 0; - - col_type = (stmt->stmt->fields) ? stmt->stmt->fields[ofs].type : MYSQL_TYPE_STRING; - - switch (col_type) { - case MYSQL_TYPE_DECIMAL: - case MYSQL_TYPE_DOUBLE: - case MYSQL_TYPE_FLOAT: - convert_to_double_ex(args[i]); - stmt->result.buf[ofs].type = IS_DOUBLE; - stmt->result.buf[ofs].buflen = 0; - bind[ofs].buffer_type = MYSQL_TYPE_DOUBLE; - bind[ofs].buffer = (gptr)&Z_DVAL_PP(args[i]); - bind[ofs].is_null = &stmt->result.is_null[ofs]; - break; - - case MYSQL_TYPE_SHORT: - case MYSQL_TYPE_TINY: - case MYSQL_TYPE_LONG: - case MYSQL_TYPE_INT24: - case MYSQL_TYPE_YEAR: - convert_to_long_ex(args[i]); - stmt->result.buf[ofs].type = IS_LONG; - stmt->result.buf[ofs].buflen = 0; - bind[ofs].buffer_type = MYSQL_TYPE_LONG; - bind[ofs].buffer = (gptr)&Z_LVAL_PP(args[i]); - bind[ofs].is_null = &stmt->result.is_null[ofs]; - break; - - case MYSQL_TYPE_LONGLONG: - stmt->result.buf[ofs].type = IS_STRING; - stmt->result.buf[ofs].buflen = sizeof(my_ulonglong); - stmt->result.buf[ofs].buffer = (char *)emalloc(stmt->result.buf[ofs].buflen); - bind[ofs].buffer_type = MYSQL_TYPE_LONGLONG; - bind[ofs].buffer = stmt->result.buf[ofs].buffer; - bind[ofs].is_null = &stmt->result.is_null[ofs]; - bind[ofs].buffer_length = stmt->result.buf[ofs].buflen; - break; - - case MYSQL_TYPE_DATE: - case MYSQL_TYPE_TIME: - case MYSQL_TYPE_DATETIME: - case MYSQL_TYPE_NEWDATE: - case MYSQL_TYPE_VAR_STRING: - case MYSQL_TYPE_STRING: - case MYSQL_TYPE_BLOB: - case MYSQL_TYPE_TIMESTAMP: - stmt->result.buf[ofs].type = IS_STRING; - stmt->result.buf[ofs].buflen = (stmt->stmt->fields) ? stmt->stmt->fields[ofs].length + 1: 256; - stmt->result.buf[ofs].buffer = (char *)emalloc(stmt->result.buf[ofs].buflen); - bind[ofs].buffer_type = MYSQL_TYPE_STRING; - bind[ofs].buffer = stmt->result.buf[ofs].buffer; - bind[ofs].is_null = &stmt->result.is_null[ofs]; - bind[ofs].buffer_length = stmt->result.buf[ofs].buflen; - bind[ofs].length = &stmt->result.buf[ofs].buflen; - break; - } - } - - rc = mysql_bind_result(stmt->stmt, bind); - MYSQLI_REPORT_STMT_ERROR(stmt->stmt); - - if (rc) { - efree(bind); - efree(args); - php_clear_stmt_bind(stmt); - RETURN_FALSE; - } - - stmt->result.var_cnt = var_cnt; - stmt->result.vars = (zval **)safe_emalloc((var_cnt), sizeof(zval), 0); - for (i = start; i < var_cnt+start; i++) { - ofs = i-start; - ZVAL_ADDREF(*args[i]); - stmt->result.vars[ofs] = *args[i]; - } - - efree(args); - efree(bind); - - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto bool mysqli_change_user(object link, string user, string password, string database) - Change logged-in user of the active connection */ -PHP_FUNCTION(mysqli_change_user) -{ - MYSQL *mysql; - zval *mysql_link = NULL; - char *user, *password, *dbname; - int user_len, password_len, dbname_len; - ulong rc; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "Osss", &mysql_link, mysqli_link_class_entry, &user, &user_len, &password, &password_len, &dbname, &dbname_len) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - rc = mysql_change_user(mysql, user, password, dbname); - MYSQLI_REPORT_MYSQL_ERROR(mysql); - - if (rc) { - RETURN_FALSE; - } - - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto string mysqli_character_set_name(object link) - Returns the name of the character set used for this connection */ -PHP_FUNCTION(mysqli_character_set_name) -{ - MYSQL *mysql; - zval *mysql_link; - char *charsetname; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - charsetname = (char *)mysql_character_set_name(mysql); - - RETURN_STRING(charsetname, 1); -} -/* }}} */ - -/* {{{ proto bool mysqli_close(object link) - Close connection */ -PHP_FUNCTION(mysqli_close) -{ - zval *mysql_link; - MYSQL *mysql; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - mysql_close(mysql); - - MYSQLI_CLEAR_RESOURCE(&mysql_link); - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto bool mysqli_commit(object link) - Commit outstanding actions and close transaction */ -PHP_FUNCTION(mysqli_commit) -{ - MYSQL *mysql; - zval *mysql_link; - ulong rc; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - rc = mysql_commit(mysql); - RETURN_BOOL(rc); -} -/* }}} */ - -/* {{{ proto void mysqli_data_seek(object result, int offset) - Move internal result pointer */ -PHP_FUNCTION(mysqli_data_seek) -{ - MYSQL_RES *result; - zval *mysql_result; - long offset; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "Ol", &mysql_result, mysqli_result_class_entry, &offset) == FAILURE) { - return; - } - - MYSQLI_FETCH_RESOURCE(result, MYSQL_RES *, &mysql_result, "mysqli_result"); - - if (result->handle && result->handle->status == MYSQL_STATUS_USE_RESULT) { - php_error_docref(NULL TSRMLS_CC, E_WARNING, "Function cannot be used with MYSQL_USE_RESULT"); - RETURN_LONG(0); - } - - mysql_data_seek(result, offset); - return; -} -/* }}} */ - -/* {{{ proto void mysqli_debug(string debug) -*/ -PHP_FUNCTION(mysqli_debug) -{ - char *debug; - int debug_len; - - if (zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "s", &debug, &debug_len) == FAILURE) { - return; - } - - mysql_debug(debug); - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto void mysqli_disable_reads_from_master(object link) -*/ -PHP_FUNCTION(mysqli_disable_reads_from_master) -{ - MYSQL *mysql; - zval *mysql_link; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - mysql_disable_reads_from_master(mysql); - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto void mysqli_disable_rpl_parse(object link) -*/ -PHP_FUNCTION(mysqli_disable_rpl_parse) -{ - MYSQL *mysql; - zval *mysql_link; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - mysql_disable_rpl_parse(mysql); - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto bool mysqli_dump_debug_info(object link) -*/ -PHP_FUNCTION(mysqli_dump_debug_info) -{ - MYSQL *mysql; - zval *mysql_link; - ulong rc; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - rc = mysql_dump_debug_info(mysql); - - if (rc) { - RETURN_FALSE; - } - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto void mysqli_enable_reads_from_master(object link) -*/ -PHP_FUNCTION(mysqli_enable_reads_from_master) -{ - MYSQL *mysql; - zval *mysql_link; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - mysql_enable_reads_from_master(mysql); - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto void mysqli_enable_rpl_parse(object link) -*/ -PHP_FUNCTION(mysqli_enable_rpl_parse) -{ - MYSQL *mysql; - zval *mysql_link; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - mysql_enable_rpl_parse(mysql); - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto int mysqli_errno(object link) - Returns the numerical value of the error message from previous MySQL operation */ -PHP_FUNCTION(mysqli_errno) -{ - MYSQL *mysql; - zval *mysql_link; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - RETURN_LONG(mysql_errno(mysql)); -} -/* }}} */ - -/* {{{ proto string mysqli_error(object link) - Returns the text of the error message from previous MySQL operation */ -PHP_FUNCTION(mysqli_error) -{ - MYSQL *mysql; - zval *mysql_link; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - RETURN_STRING((char *)mysql_error(mysql),1); -} -/* }}} */ - -/* {{{ proto bool mysqli_execute(object stmt) - Execute a prepared statement */ -PHP_FUNCTION(mysqli_execute) -{ - STMT *stmt; - zval *mysql_stmt; - unsigned int i; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(stmt, STMT *, &mysql_stmt, "mysqli_stmt"); - - for (i = 0; i < stmt->param.var_cnt; i++) { - if (stmt->param.vars[i]) { - stmt->param.is_null[i] = (stmt->param.vars[i]->type == IS_NULL); - - switch (stmt->stmt->params[i].buffer_type) { - case MYSQL_TYPE_VAR_STRING: - convert_to_string_ex(&stmt->param.vars[i]); - stmt->stmt->params[i].buffer = Z_STRVAL_PP(&stmt->param.vars[i]); - stmt->stmt->params[i].buffer_length = strlen(Z_STRVAL_PP(&stmt->param.vars[i])); - break; - case MYSQL_TYPE_DOUBLE: - convert_to_double_ex(&stmt->param.vars[i]); - stmt->stmt->params[i].buffer = (gptr)&Z_LVAL_PP(&stmt->param.vars[i]); - break; - case MYSQL_TYPE_LONG: - convert_to_long_ex(&stmt->param.vars[i]); - stmt->stmt->params[i].buffer = (gptr)&Z_LVAL_PP(&stmt->param.vars[i]); - break; - default: - break; - } - } - } - - if (mysql_execute(stmt->stmt)) { - MYSQLI_REPORT_STMT_ERROR(stmt->stmt); - RETURN_FALSE; - } - if (MyG(report_mode) & MYSQLI_REPORT_INDEX) { - php_mysqli_report_index(stmt->stmt->query, stmt->stmt->mysql->server_status TSRMLS_CC); - } - - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto mixed mysqli_fetch(object stmt) - Fetch results from a prepared statement into the bound variables */ -PHP_FUNCTION(mysqli_fetch) -{ - STMT *stmt; - zval *mysql_stmt; - unsigned int i; - ulong ret; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(stmt, STMT *, &mysql_stmt, "mysqli_stmt"); - - /* reset buffers */ - - - for (i = 0; i < stmt->result.var_cnt; i++) { - if (stmt->result.buf[i].type == IS_STRING) { - memset(stmt->result.buf[i].buffer, 0, stmt->result.buf[i].buflen); - } - } - - if (!(ret = mysql_fetch(stmt->stmt))) { - - for (i = 0; i < stmt->result.var_cnt; i++) { - if (!stmt->result.is_null[i]) { - switch (stmt->result.buf[i].type) { - case IS_LONG: - stmt->result.vars[i]->type = IS_LONG; - break; - case IS_DOUBLE: - stmt->result.vars[i]->type = IS_DOUBLE; - break; - case IS_STRING: - if (stmt->stmt->bind[i].buffer_type == MYSQL_TYPE_LONGLONG) { - char tmp[50]; - my_ulonglong lval; - memcpy (&lval, stmt->result.buf[i].buffer, sizeof(my_ulonglong)); - if (lval != (long)lval) { - /* even though lval is declared as unsigned, the value - * may be negative. Therefor we cannot use %llu and must - * use %lld. - */ - sprintf((char *)&tmp, "%lld", lval); - ZVAL_STRING(stmt->result.vars[i], tmp, 1); - } else { - ZVAL_LONG(stmt->result.vars[i], lval); - } - } else { - if (stmt->result.vars[i]->type == IS_STRING) { - efree(stmt->result.vars[i]->value.str.val); - } - ZVAL_STRING(stmt->result.vars[i], stmt->result.buf[i].buffer, 1); - } - break; - default: - break; - } - } else { - stmt->result.vars[i]->type = IS_NULL; - } - } - } else { - MYSQLI_REPORT_STMT_ERROR(stmt->stmt); - } - - switch (ret) { - case 0: - RETURN_TRUE; - break; - case 1: - RETURN_FALSE; - break; - default: - RETURN_LONG(ret); - break; - } -} -/* }}} */ - -/* {{{ proto object mysqli_fetch_field (object result) - Get column information from a result and return as an object */ -PHP_FUNCTION(mysqli_fetch_field) -{ - MYSQL_RES *result; - zval *mysql_result; - MYSQL_FIELD *field; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_result, mysqli_result_class_entry) == FAILURE) { - return; - } - - MYSQLI_FETCH_RESOURCE(result, MYSQL_RES *, &mysql_result, "mysqli_result"); - - if (!(field = mysql_fetch_field(result))) { - RETURN_FALSE; - } - - object_init(return_value); - - add_property_string(return_value, "name",(field->name ? field->name : ""), 1); - add_property_string(return_value, "orgname",(field->org_name ? field->org_name : ""), 1); - add_property_string(return_value, "table",(field->table ? field->table : ""), 1); - add_property_string(return_value, "orgtable",(field->org_table ? field->org_table : ""), 1); - add_property_string(return_value, "def",(field->def ? field->def : ""), 1); - add_property_long(return_value, "max_length", field->max_length); - add_property_long(return_value, "flags", field->flags); - add_property_long(return_value, "type", field->type); - add_property_long(return_value, "decimals", field->decimals); -} -/* }}} */ - -/* {{{ proto array mysqli_fetch_fields (object result) - Return array of objects containing field meta-data */ -PHP_FUNCTION(mysqli_fetch_fields) -{ - MYSQL_RES *result; - zval *mysql_result; - MYSQL_FIELD *field; - zval *obj; - - unsigned int i; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_result, mysqli_result_class_entry) == FAILURE) { - return; - } - - MYSQLI_FETCH_RESOURCE(result, MYSQL_RES *, &mysql_result, "mysqli_result"); - - if (!(field = mysql_fetch_field(result))) { - RETURN_FALSE; - } - - array_init(return_value); - - for (i = 0; i < mysql_num_fields(result); i++) { - field = mysql_fetch_field_direct(result, i); - - - MAKE_STD_ZVAL(obj); - object_init(obj); - - add_property_string(obj, "name",(field->name ? field->name : ""), 1); - add_property_string(obj, "orgname",(field->org_name ? field->org_name : ""), 1); - add_property_string(obj, "table",(field->table ? field->table : ""), 1); - add_property_string(obj, "orgtable",(field->org_table ? field->org_table : ""), 1); - add_property_string(obj, "def",(field->def ? field->def : ""), 1); - add_property_long(obj, "max_length", field->max_length); - add_property_long(obj, "flags", field->flags); - add_property_long(obj, "type", field->type); - add_property_long(obj, "decimals", field->decimals); - - add_index_zval(return_value, i, obj); - } -} -/* }}} */ - -/* {{{ proto array mysqli_fetch_field_direct (object result, int offset) - Fetch meta-data for a single field */ -PHP_FUNCTION(mysqli_fetch_field_direct) -{ - MYSQL_RES *result; - zval *mysql_result; - MYSQL_FIELD *field; - int offset; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "Ol", &mysql_result, mysqli_result_class_entry, &offset) == FAILURE) { - return; - } - - MYSQLI_FETCH_RESOURCE(result, MYSQL_RES *, &mysql_result, "mysqli_result"); - - if (!(field = mysql_fetch_field_direct(result,offset))) { - RETURN_FALSE; - } - - object_init(return_value); - - add_property_string(return_value, "name",(field->name ? field->name : ""), 1); - add_property_string(return_value, "orgname",(field->org_name ? field->org_name : ""), 1); - add_property_string(return_value, "table",(field->table ? field->table : ""), 1); - add_property_string(return_value, "orgtable",(field->org_table ? field->org_table : ""), 1); - add_property_string(return_value, "def",(field->def ? field->def : ""), 1); - add_property_long(return_value, "max_length", field->max_length); - add_property_long(return_value, "flags", field->flags); - add_property_long(return_value, "type", field->type); - add_property_long(return_value, "decimals", field->decimals); -} -/* }}} */ - -/* {{{ proto array mysqli_fetch_lengths (object result) - Get the length of each output in a result */ -PHP_FUNCTION(mysqli_fetch_lengths) -{ - MYSQL_RES *result; - zval *mysql_result; - unsigned int i; - unsigned long *ret; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_result, mysqli_result_class_entry) == FAILURE) { - return; - } - - MYSQLI_FETCH_RESOURCE(result, MYSQL_RES *, &mysql_result, "mysqli_result"); - - if (!(ret = mysql_fetch_lengths(result))) { - RETURN_FALSE; - } - - array_init(return_value); - - for (i = 0; i < mysql_num_fields(result); i++) { - add_index_long(return_value, i, ret[i]); - } -} -/* }}} */ - -/* {{{ proto array mysqli_fetch_row (object result) - Get a result row as an enumerated array */ -PHP_FUNCTION(mysqli_fetch_row) -{ - php_mysqli_fetch_into_hash(INTERNAL_FUNCTION_PARAM_PASSTHRU, MYSQLI_NUM, 0); -} -/* }}} */ - -/* {{{ proto int mysqli_field_count(object link) - Fetch the number of fields returned by the last query for the given link -*/ -PHP_FUNCTION(mysqli_field_count) -{ - MYSQL *mysql; - zval *mysql_link; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - RETURN_LONG(mysql_field_count(mysql)); -} -/* }}} */ - -/* {{{ proto int mysqli_field_seek(object result, int fieldnr) - Set result pointer to a specified field offset -*/ -PHP_FUNCTION(mysqli_field_seek) -{ - MYSQL_RES *result; - zval *mysql_result; - unsigned int fieldnr; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "Ol", &mysql_result, mysqli_result_class_entry, &fieldnr) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(result, MYSQL_RES *, &mysql_result, "mysqli_result"); - - if (fieldnr < 0 || fieldnr >= mysql_num_fields(result)) { - php_error_docref(NULL TSRMLS_CC, E_WARNING, "Field offset is invalid for resultset"); - RETURN_FALSE; - } - - mysql_field_seek(result, fieldnr); - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto int mysqli_field_tell(object result) - Get current field offset of result pointer */ -PHP_FUNCTION(mysqli_field_tell) -{ - MYSQL_RES *result; - zval *mysql_result; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_result, mysqli_result_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(result, MYSQL_RES *, &mysql_result, "mysqli_result"); - - RETURN_LONG(mysql_field_tell(result)); -} -/* }}} */ - -/* {{{ proto int mysqli_free_result(object result) - Free query result memory for the given result handle */ -PHP_FUNCTION(mysqli_free_result) -{ - MYSQL_RES *result; - zval *mysql_result; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_result, mysqli_result_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(result, MYSQL_RES *, &mysql_result, "mysqli_result"); - - mysql_free_result(result); - MYSQLI_CLEAR_RESOURCE(&mysql_result); - - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto string mysqli_get_client_info(void) - Get MySQL client info */ -PHP_FUNCTION(mysqli_get_client_info) -{ - RETURN_STRING((char *)mysql_get_client_info(), 1); -} -/* }}} */ - -/* {{{ proto string mysqli_get_host_info (object link) - Get MySQL host info */ -PHP_FUNCTION(mysqli_get_host_info) -{ - MYSQL *mysql; - zval *mysql_link = NULL; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - RETURN_STRING((mysql->host_info) ? mysql->host_info : empty_string, 1); -} -/* }}} */ - -/* {{{ proto int mysqli_get_proto_info(object link) - Get MySQL protocol information */ -PHP_FUNCTION(mysqli_get_proto_info) -{ - MYSQL *mysql; - zval *mysql_link = NULL; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - RETURN_LONG(mysql_get_proto_info(mysql)); -} -/* }}} */ - -/* {{{ proto string mysqli_get_server_info(object link) - Get MySQL server info */ -PHP_FUNCTION(mysqli_get_server_info) -{ - MYSQL *mysql; - zval *mysql_link = NULL; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - RETURN_STRING((char *)mysql_get_server_info(mysql), 1); -} - -/* }}} */ - -/* {{{ proto int mysqli_get_server_version(object link) - Return the MySQL version for the server referenced by the given link */ -PHP_FUNCTION(mysqli_get_server_version) -{ - MYSQL *mysql; - zval *mysql_link = NULL; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - RETURN_LONG(mysql_get_server_version(mysql)); -} - -/* }}} */ - -/* {{{ proto string mysqli_info(object link) - Get information about the most recent query */ -PHP_FUNCTION(mysqli_info) -{ - MYSQL *mysql; - zval *mysql_link = NULL; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - RETURN_STRING((mysql->info) ? mysql->info : empty_string, 1); -} -/* }}} */ - -/* {{{ proto resource mysqli_init(void) - Initialize mysqli and return a resource for use with mysql_real_connect */ -PHP_FUNCTION(mysqli_init) -{ - MYSQLI_RESOURCE *mysqli_resource = (MYSQLI_RESOURCE *)ecalloc (1, sizeof(MYSQLI_RESOURCE)); - mysqli_resource->ptr = (void *)mysql_init(NULL); - MYSQLI_RETURN_RESOURCE(mysqli_resource, mysqli_link_class_entry); -} -/* }}} */ - -/* {{{ proto mixed mysqli_insert_id(object link) - Get the ID generated from the previous INSERT operation */ -PHP_FUNCTION(mysqli_insert_id) -{ - MYSQL *mysql; - my_ulonglong rc; - zval *mysql_link; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - rc = mysql_insert_id(mysql); - MYSQLI_RETURN_LONG_LONG(rc) -} -/* }}} */ - -/* {{{ proto bool mysqli_kill(object link, int processid) - Kill a mysql process on the server */ -PHP_FUNCTION(mysqli_kill) -{ - MYSQL *mysql; - zval *mysql_link; - int processid; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "Ol", &mysql_link, mysqli_link_class_entry, &processid) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - if (mysql_kill(mysql, processid)) { - MYSQLI_REPORT_MYSQL_ERROR(mysql); - RETURN_FALSE; - } - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto bool mysqli_master_query(object link, string query) - Enforce execution of a query on the master in a master/slave setup */ -PHP_FUNCTION(mysqli_master_query) { - MYSQL *mysql; - zval *mysql_link; - char *query = NULL; - unsigned int query_len; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "Os", &mysql_link, mysqli_link_class_entry, &query, &query_len) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - if (mysql_master_query(mysql, query, query_len)) { - RETURN_FALSE; - } - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto bool mysqli_more_results(object link) - check if there any more query results from a multi query */ -PHP_FUNCTION(mysqli_more_results) { - MYSQL *mysql; - zval *mysql_link; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - if (!mysql_more_results(mysql)) { - RETURN_FALSE; - } - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto bool mysqli_next_result(object link) - read next result from multi_query */ -PHP_FUNCTION(mysqli_next_result) { - MYSQL *mysql; - zval *mysql_link; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - if (mysql_next_result(mysql)) { - RETURN_FALSE; - } - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto int mysqli_num_fields(object result) - Get number of fields in result */ -PHP_FUNCTION(mysqli_num_fields) -{ - MYSQL_RES *result; - zval *mysql_result; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_result, mysqli_result_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(result, MYSQL_RES *, &mysql_result, "mysqli_result"); - - RETURN_LONG(mysql_num_fields(result)); -} -/* }}} */ - -/* {{{ proto mixed mysqli_num_rows(object result) - Get number of rows in result */ -PHP_FUNCTION(mysqli_num_rows) -{ - MYSQL_RES *result; - zval *mysql_result; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_result, mysqli_result_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(result, MYSQL_RES *, &mysql_result, "mysqli_result"); - - if (result->handle && result->handle->status == MYSQL_STATUS_USE_RESULT) { - php_error_docref(NULL TSRMLS_CC, E_WARNING, "Function cannot be used with MYSQL_USE_RESULT"); - RETURN_LONG(0); - } - - MYSQLI_RETURN_LONG_LONG(mysql_num_rows(result)); -} -/* }}} */ - -/* {{{ proto bool mysqli_options(object link, int flags, mixed values) - Set options */ -PHP_FUNCTION(mysqli_options) -{ - MYSQL *mysql; - zval *mysql_link = NULL; - zval *mysql_value; - long mysql_option; - unsigned int l_value; - long ret; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "Olz", &mysql_link, mysqli_link_class_entry, &mysql_option, &mysql_value) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - switch (Z_TYPE_PP(&mysql_value)) { - case IS_STRING: - ret = mysql_options(mysql, mysql_option, Z_STRVAL_PP(&mysql_value)); - break; - default: - convert_to_long_ex(&mysql_value); - l_value = Z_LVAL_PP(&mysql_value); - ret = mysql_options(mysql, mysql_option, (char *)&l_value); - break; - } - - if (ret != 0) { - RETURN_FALSE; - } else { - RETURN_TRUE; - } -} -/* }}} */ - -/* {{{ proto int mysqli_param_count(object stmt) { - Return the number of parameter for the given statement */ -PHP_FUNCTION(mysqli_param_count) -{ - STMT *stmt; - zval *mysql_stmt; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(stmt, STMT *, &mysql_stmt, "mysqli_stmt"); - - RETURN_LONG(mysql_param_count(stmt->stmt)); -} -/* }}} */ - -/* {{{ proto int mysqli_ping(object link) - Ping a server connection or reconnect if there is no connection */ -PHP_FUNCTION(mysqli_ping) -{ - MYSQL *mysql; - zval *mysql_link; - long rc; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - rc = mysql_ping(mysql); - MYSQLI_REPORT_MYSQL_ERROR(mysql); - RETURN_LONG(rc); -} -/* }}} */ - -/* {{{ proto resource mysqli_prepare(object link, string query) - Prepare a SQL statement for execution */ -PHP_FUNCTION(mysqli_prepare) -{ - MYSQL *mysql; - STMT *stmt; - char *query = NULL; - unsigned int query_len; - zval *mysql_link; - MYSQLI_RESOURCE *mysqli_resource; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "Os",&mysql_link, mysqli_link_class_entry, &query, &query_len) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - stmt = (STMT *)ecalloc(1,sizeof(STMT)); - - stmt->stmt = mysql_prepare(mysql, query, query_len); - - if (!stmt->stmt) { - MYSQLI_REPORT_MYSQL_ERROR(mysql); - efree(stmt); - RETURN_FALSE; - } - - mysqli_resource = (MYSQLI_RESOURCE *)ecalloc (1, sizeof(MYSQLI_RESOURCE)); - mysqli_resource->ptr = (void *)stmt; - MYSQLI_RETURN_RESOURCE(mysqli_resource, mysqli_stmt_class_entry); -} -/* }}} */ - -/* {{{ proto resource mysqli_get_metadata(object stmt) - return result set from statement */ -PHP_FUNCTION(mysqli_get_metadata) -{ - STMT *stmt; - MYSQL_RES *result; - zval *mysql_stmt; - MYSQLI_RESOURCE *mysqli_resource; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(stmt, STMT *, &mysql_stmt, "mysqli_stmt"); - - if (!(result = mysql_get_metadata(stmt->stmt))){ - MYSQLI_REPORT_STMT_ERROR(stmt->stmt); - RETURN_FALSE; - } - - mysqli_resource = (MYSQLI_RESOURCE *)ecalloc (1, sizeof(MYSQLI_RESOURCE)); - mysqli_resource->ptr = (void *)result; - MYSQLI_RETURN_RESOURCE(mysqli_resource, mysqli_result_class_entry); -} -/* }}} */ - -/* {{{ proto bool mysqli_read_query_result(object link) -*/ -PHP_FUNCTION(mysqli_read_query_result) -{ - MYSQL *mysql; - zval *mysql_link; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - if (mysql_read_query_result(mysql)) { - RETURN_FALSE; - } - - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto bool mysqli_real_connect(object link [,string hostname [,string username [,string passwd [,string dbname [,int port [,string socket [,int flags]]]]]]]) - Open a connection to a mysql server */ -PHP_FUNCTION(mysqli_real_connect) -{ - MYSQL *mysql; - char *hostname = NULL, *username=NULL, *passwd=NULL, *dbname=NULL, *socket=NULL; - unsigned int hostname_len, username_len, passwd_len, dbname_len, socket_len; - unsigned int port=0, flags=0; - zval *mysql_link; - zval *object = getThis(); - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O|sssslsl", &mysql_link, mysqli_link_class_entry, - &hostname, &hostname_len, &username, &username_len, &passwd, &passwd_len, &dbname, &dbname_len, &port, &socket, &socket_len, - &flags) == FAILURE) { - return; - } - - if (!socket_len) { - socket = NULL; - } - - /* TODO: safe mode handling */ - if (PG(sql_safe_mode)) { - } else { - if (!passwd) { - passwd = MyG(default_pw); - if (!username){ - username = MyG(default_user); - if (!hostname) { - hostname = MyG(default_host); - } - } - } - } - - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - /* remove some insecure options */ - flags ^= CLIENT_MULTI_STATEMENTS; /* don't allow multi_queries via connect parameter */ - if (PG(open_basedir) && strlen(PG(open_basedir))) { - flags ^= CLIENT_LOCAL_FILES; - } - - if (mysql_real_connect(mysql,hostname,username,passwd,dbname,port,socket,flags) == NULL) { - - MYSQLI_REPORT_MYSQL_ERROR(mysql); - php_mysqli_set_error(mysql_errno(mysql), (char *) mysql_error(mysql) TSRMLS_CC); - - if (!(MyG(report_mode) & MYSQLI_REPORT_ERROR)) { - php_error_docref(NULL TSRMLS_CC, E_WARNING, "%s", mysql_error(mysql)); - } - RETURN_FALSE; - } - php_mysqli_set_error(mysql_errno(mysql), (char *)mysql_error(mysql) TSRMLS_CC); - - if (object) { - ((mysqli_object *) zend_object_store_get_object(object TSRMLS_CC))->valid = 1; - } - - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto bool mysqli_real_query(object link, string query) - Binary-safe version of mysql_query() */ -PHP_FUNCTION(mysqli_real_query) -{ - MYSQL *mysql; - zval *mysql_link; - char *query = NULL; - unsigned int query_len; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "Os", &mysql_link, mysqli_link_class_entry, &query, &query_len) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - MYSQLI_DISABLE_MQ; /* disable multi statements/queries */ - - if (mysql_real_query(mysql, query, query_len)) { - MYSQLI_REPORT_MYSQL_ERROR(mysql); - RETURN_FALSE; - } - - if (!mysql_field_count(mysql)) { - if (MyG(report_mode) & MYSQLI_REPORT_INDEX) { - php_mysqli_report_index(query, mysql->server_status TSRMLS_CC); - } - } - - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto string mysqli_real_escape_string(object link, string escapestr) - Escapes special characters in a string for use in a SQL statement, taking into account the current charset of the connection */ -PHP_FUNCTION(mysqli_real_escape_string) { - MYSQL *mysql; - zval *mysql_link = NULL; - char *escapestr, *newstr; - int escapestr_len, newstr_len; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "Os", &mysql_link, mysqli_link_class_entry, &escapestr, &escapestr_len) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - newstr = safe_emalloc(2, escapestr_len, 1); - newstr_len = mysql_real_escape_string(mysql, newstr, escapestr, escapestr_len); - newstr = erealloc(newstr, newstr_len + 1); - - RETURN_STRING(newstr, 0); -} -/* }}} */ - -/* {{{ proto bool mysqli_rollback(object link) - Undo actions from current transaction */ -PHP_FUNCTION(mysqli_rollback) -{ - MYSQL *mysql; - zval *mysql_link; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - RETURN_BOOL(mysql_rollback(mysql)); -} -/* }}} */ - -/* {{{ proto int mysqli_rpl_parse_enabled(object link) -*/ -PHP_FUNCTION(mysqli_rpl_parse_enabled) -{ - MYSQL *mysql; - zval *mysql_link; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - RETURN_LONG(mysql_rpl_parse_enabled(mysql)); -} -/* }}} */ - -/* {{{ proto bool mysqli_rpl_probe(object link) -*/ -PHP_FUNCTION(mysqli_rpl_probe) -{ - MYSQL *mysql; - zval *mysql_link; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - - if (mysql_rpl_probe(mysql)) { - RETURN_FALSE; - } - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto int mysqli_rpl_query_type(string query) -*/ -PHP_FUNCTION(mysqli_rpl_query_type) -{ - MYSQL *mysql; - zval *mysql_link; - char *query; - int query_len; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "Os", &mysql_link, mysqli_link_class_entry, &query, &query_len) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - RETURN_LONG(mysql_rpl_query_type(query, query_len)); -} -/* }}} */ - -/* {{{ proto bool mysqli_send_long_data(object stmt, int param_nr, string data) -*/ -PHP_FUNCTION(mysqli_send_long_data) -{ - STMT *stmt; - zval *mysql_stmt; - char *data; - long param_nr, data_len; - - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "Ols", &mysql_stmt, mysqli_stmt_class_entry, ¶m_nr, &data, &data_len) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(stmt, STMT *, &mysql_stmt, "mysqli_stmt"); - - if (!param_nr) { - php_error_docref(NULL TSRMLS_CC, E_WARNING, "Invalid parameter number"); - RETURN_FALSE; - } - param_nr--; - - if (mysql_send_long_data(stmt->stmt, param_nr, data, data_len)) { - RETURN_FALSE; - } - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto bool mysqli_send_query(object link, string query) -*/ -PHP_FUNCTION(mysqli_send_query) -{ - MYSQL *mysql; - zval *mysql_link; - char *query = NULL; - unsigned int query_len; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "Os", &mysql_link, mysqli_link_class_entry, &query, &query_len) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - if (mysql_send_query(mysql, query, query_len)) { - RETURN_FALSE; - } - RETURN_TRUE; -} -/* }}} */ - -#ifdef HAVE_EMBEDDED_MYSQLI -/* {{{ proto bool mysqli_server_init(void) - initialize embedded server */ -PHP_FUNCTION(mysqli_server_init) -{ - zval *server; - zval *groups; - - if (MyG(embedded)) { - php_error_docref(NULL TSRMLS_CC, E_WARNING, "Embedded server already initialized."); - RETURN_FALSE; - } - - if (zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "|aa", &server, &groups) == FAILURE) { - return; - } - - if (mysql_server_init(0, NULL, NULL)) { - RETURN_FALSE; - } - MyG(embedded) = 1; - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto void mysqli_server_end(void) -*/ -PHP_FUNCTION(mysqli_server_end) -{ - mysql_server_end(); -} -/* }}} */ -#endif - -/* {{{ proto bool mysqli_slave_query(object link, string query) - Enforce execution of a query on a slave in a master/slave setup */ -PHP_FUNCTION(mysqli_slave_query) -{ - MYSQL *mysql; - zval *mysql_link; - char *query = NULL; - unsigned int query_len; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "Os", &mysql_link, mysqli_link_class_entry, &query, &query_len) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - if (mysql_slave_query(mysql, query, query_len)) { - RETURN_FALSE; - } - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto mixed mysqli_stmt_affected_rows(object stmt) - Return the number of rows affected in the last query for the given link */ -PHP_FUNCTION(mysqli_stmt_affected_rows) -{ - STMT *stmt; - zval *mysql_stmt; - my_ulonglong rc; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(stmt, STMT *, &mysql_stmt, "mysqli_stmt"); - - rc = mysql_stmt_affected_rows(stmt->stmt); - MYSQLI_RETURN_LONG_LONG(rc) -} -/* }}} */ - -/* {{{ proto bool mysqli_stmt_close(object stmt) - Close statement */ -PHP_FUNCTION(mysqli_stmt_close) -{ - STMT *stmt; - zval *mysql_stmt; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(stmt, STMT *, &mysql_stmt, "mysqli_stmt"); - mysql_stmt_close(stmt->stmt); - stmt->stmt = NULL; - php_clear_stmt_bind(stmt); - MYSQLI_CLEAR_RESOURCE(&mysql_stmt); - RETURN_TRUE; - -} -/* }}} */ - -/* {{{ proto void mysqli_stmt_data_seek(object stmt, int offset) - Move internal result pointer */ -PHP_FUNCTION(mysqli_stmt_data_seek) -{ - STMT *stmt; - zval *mysql_stmt; - long offset; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "Ol", &mysql_stmt, mysqli_stmt_class_entry, &offset) == FAILURE) { - return; - } - - MYSQLI_FETCH_RESOURCE(stmt, STMT *, &mysql_stmt, "mysqli_stmt"); - - mysql_stmt_data_seek(stmt->stmt, offset); - return; -} -/* }}} */ - -/* {{{ proto mixed mysqli_stmt_num_rows(object stmt) - Return the number of rows in statements result set */ -PHP_FUNCTION(mysqli_stmt_num_rows) -{ - STMT *stmt; - zval *mysql_stmt; - my_ulonglong rc; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) { - return; - } - - MYSQLI_FETCH_RESOURCE(stmt, STMT *, &mysql_stmt, "mysqli_stmt"); - - rc = mysql_stmt_num_rows(stmt->stmt); - MYSQLI_RETURN_LONG_LONG(rc) -} -/* }}} */ - -/* {{{ proto string mysqli_select_db(object link, string dbname) - Select a MySQL database */ -PHP_FUNCTION(mysqli_select_db) -{ - MYSQL *mysql; - zval *mysql_link; - char *dbname; - int dbname_len; - - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "Os", &mysql_link, mysqli_link_class_entry, &dbname, &dbname_len) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - if (!mysql_select_db(mysql, dbname)) { - RETURN_TRUE; - } - - MYSQLI_REPORT_MYSQL_ERROR(mysql); - RETURN_FALSE; -} -/* }}} */ - -/* {{{ proto string mysqli_sqlstate(object link) - Returns the SQLSTATE error from previous MySQL operation */ -#if MYSQL_VERSION_ID >= 40101 -PHP_FUNCTION(mysqli_sqlstate) -{ - MYSQL *mysql; - zval *mysql_link; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - RETURN_STRING((char *)mysql_sqlstate(mysql),1); -} -#endif -/* }}} */ - -/* {{{ proto bool mysqli_ssl_set(object link ,string key ,string cert ,string ca ,string capath ,string cipher]) -*/ -PHP_FUNCTION(mysqli_ssl_set) -{ - MYSQL *mysql; - zval *mysql_link; - char *key=NULL, *cert=NULL, *ca=NULL, *capath=NULL, *cipher=NULL; - int key_len, cert_len, ca_len, capath_len, cipher_len; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "Osssss", &mysql_link, mysqli_link_class_entry, - &key, &key_len, &cert, &cert_len, &ca, &ca_len, &capath, &capath_len, &cipher, &cipher_len) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - mysql_ssl_set(mysql, key, cert, ca, capath, cipher); - - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto string mysqli_stat(object link) - Get current system status */ -PHP_FUNCTION(mysqli_stat) -{ - MYSQL *mysql; - zval *mysql_link; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - RETURN_STRING((char *)mysql_stat(mysql), 1); -} - -/* }}} */ - -/* {{{ proto int mysqli_stmt_errno(object stmt) -*/ -PHP_FUNCTION(mysqli_stmt_errno) -{ - STMT *stmt; - zval *mysql_stmt; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(stmt, STMT *, &mysql_stmt, "mysqli_stmt"); - - RETURN_LONG(mysql_stmt_errno(stmt->stmt)); -} -/* }}} */ - -/* {{{ proto string mysqli_stmt_error(object stmt) -*/ -PHP_FUNCTION(mysqli_stmt_error) -{ - STMT *stmt; - zval *mysql_stmt; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(stmt, STMT *, &mysql_stmt, "mysqli_stmt"); - - RETURN_STRING((char *)mysql_stmt_error(stmt->stmt),1); -} -/* }}} */ - -/* {{{ proto object mysqli_stmt_store_result(stmt) -*/ -PHP_FUNCTION(mysqli_stmt_store_result) -{ - STMT *stmt; - zval *mysql_stmt; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(stmt, STMT *, &mysql_stmt, "mysqli_stmt"); - - if (mysql_stmt_store_result(stmt->stmt)){ - MYSQLI_REPORT_STMT_ERROR(stmt->stmt); - RETURN_FALSE; - } - RETURN_TRUE; -} -/* }}} */ - -/* {{{ proto string mysqli_stmt_sqlstate(object stmt) -*/ -#if MYSQL_VERSION_ID >= 40101 -PHP_FUNCTION(mysqli_stmt_sqlstate) -{ - STMT *stmt; - zval *mysql_stmt; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(stmt, STMT *, &mysql_stmt, "mysqli_stmt"); - - RETURN_STRING((char *)mysql_stmt_sqlstate(stmt->stmt),1); -} -#endif -/* }}} */ - -/* {{{ proto object mysqli_store_result(object link) - Buffer result set on client */ -PHP_FUNCTION(mysqli_store_result) -{ - MYSQL *mysql; - MYSQL_RES *result; - zval *mysql_link; - MYSQLI_RESOURCE *mysqli_resource; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - if (!(result = mysql_store_result(mysql))) { - MYSQLI_REPORT_MYSQL_ERROR(mysql); - MYSQLI_DISABLE_MQ; - RETURN_FALSE; - } - if (MyG(report_mode) & MYSQLI_REPORT_INDEX) { - php_mysqli_report_index("from previous mysql_real_connect", mysql->server_status TSRMLS_CC); - } - MYSQLI_DISABLE_MQ; - mysqli_resource = (MYSQLI_RESOURCE *)ecalloc (1, sizeof(MYSQLI_RESOURCE)); - mysqli_resource->ptr = (void *)result; - MYSQLI_RETURN_RESOURCE(mysqli_resource, mysqli_result_class_entry); -} -/* }}} */ - -/* {{{ proto int mysqli_thread_id(object link) - Return the current thread ID */ -PHP_FUNCTION(mysqli_thread_id) -{ - MYSQL *mysql; - zval *mysql_link; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - RETURN_LONG(mysql_thread_id(mysql)); -} -/* }}} */ - -/* {{{ proto bool mysqli_thread_safe(void) - Return whether thread safety is given or not */ -PHP_FUNCTION(mysqli_thread_safe) -{ - RETURN_BOOL(mysql_thread_safe()); -} - -/* }}} */ - -/* {{{ proto object mysqli_use_result(object link) - Directly retrieve query results - do not buffer results on client side */ -PHP_FUNCTION(mysqli_use_result) -{ - MYSQL *mysql; - MYSQL_RES *result; - zval *mysql_link; - MYSQLI_RESOURCE *mysqli_resource; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - if (!(result = mysql_use_result(mysql))) { - MYSQLI_REPORT_MYSQL_ERROR(mysql); - MYSQLI_DISABLE_MQ; - RETURN_FALSE; - } - - if (MyG(report_mode) & MYSQLI_REPORT_INDEX) { - php_mysqli_report_index("from previous mysql_real_connect", mysql->server_status TSRMLS_CC); - } - - mysqli_resource = (MYSQLI_RESOURCE *)ecalloc (1, sizeof(MYSQLI_RESOURCE)); - mysqli_resource->ptr = (void *)result; - MYSQLI_RETURN_RESOURCE(mysqli_resource, mysqli_result_class_entry); -} -/* }}} */ - -/* {{{ proto int mysqli_warning_count (object link) - Return number of warnings from the last query for the given link */ -PHP_FUNCTION(mysqli_warning_count) -{ - MYSQL *mysql; - zval *mysql_link; - - if (zend_parse_method_parameters(ZEND_NUM_ARGS() TSRMLS_CC, getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) { - return; - } - MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, &mysql_link, "mysqli_link"); - - RETURN_LONG(mysql_warning_count(mysql)); -} -/* }}} */ - -/* - * Local variables: - * tab-width: 4 - * c-basic-offset: 4 - * End: - * vim600: noet sw=4 ts=4 fdm=marker - * vim<600: noet sw=4 ts=4 - */ |