summaryrefslogtreecommitdiff
path: root/ext/mysqli
diff options
context:
space:
mode:
authorGeorg Richter <georg@php.net>2003-11-22 21:20:07 +0000
committerGeorg Richter <georg@php.net>2003-11-22 21:20:07 +0000
commit230b207849e883a08e361b250eb4a0fd367b3e01 (patch)
tree65651b4158f90b9c0b31e3703a09d089eae7336f /ext/mysqli
parent28b6c35d80bcdaab0cce5652550f2233c4e9577b (diff)
downloadphp-git-230b207849e883a08e361b250eb4a0fd367b3e01.tar.gz
- Added multiquery support:
mysqli_multi_query mysqli_more_results mysqli_next_results - added read-only properties (and removed methods) object mysql affected_rows client_flags client_version errno, error, host, host_info, info server_capabilities, server_version sqlstate, port, protocol_version, server_language thread_id, user, warning_count object result current_field, field_count, lengths, num_rows, type object stmt query, param_count, field_count, id, errno, error, sqlstate - added constructor - minor fixes, prototypes
Diffstat (limited to 'ext/mysqli')
-rw-r--r--ext/mysqli/config.m42
-rw-r--r--ext/mysqli/mysqli.c131
-rw-r--r--ext/mysqli/mysqli_api.c46
-rw-r--r--ext/mysqli/mysqli_fe.c27
-rw-r--r--ext/mysqli/mysqli_nonapi.c35
-rw-r--r--ext/mysqli/mysqli_prop.c181
-rw-r--r--ext/mysqli/php_mysqli.h48
7 files changed, 437 insertions, 33 deletions
diff --git a/ext/mysqli/config.m4 b/ext/mysqli/config.m4
index 6c1bee819b..ddb97bd9a9 100644
--- a/ext/mysqli/config.m4
+++ b/ext/mysqli/config.m4
@@ -57,5 +57,5 @@ if test "$PHP_MYSQLI" != "no" || test "$PHP_EMBEDDED_MYSQLI" != "no"; then
])
PHP_SUBST(MYSQLI_SHARED_LIBADD)
- PHP_NEW_EXTENSION(mysqli, mysqli.c mysqli_api.c mysqli_nonapi.c mysqli_fe.c mysqli_profiler.c mysqli_profiler_com.c, $ext_shared)
+ PHP_NEW_EXTENSION(mysqli, mysqli.c mysqli_api.c mysqli_prop.c mysqli_nonapi.c mysqli_fe.c mysqli_profiler.c mysqli_profiler_com.c, $ext_shared)
fi
diff --git a/ext/mysqli/mysqli.c b/ext/mysqli/mysqli.c
index 8e0cfc2911..30a0c13eb8 100644
--- a/ext/mysqli/mysqli.c
+++ b/ext/mysqli/mysqli.c
@@ -36,7 +36,20 @@
ZEND_DECLARE_MODULE_GLOBALS(mysqli)
static zend_object_handlers mysqli_object_handlers;
+static HashTable classes;
+static HashTable mysqli_link_properties;
+static HashTable mysqli_result_properties;
+static HashTable mysqli_stmt_properties;
PR_MAIN *prmain;
+extern void php_mysqli_connect(INTERNAL_FUNCTION_PARAMETERS);
+
+typedef int (*mysqli_read_t)(mysqli_object *obj, zval **retval TSRMLS_DC);
+typedef int (*mysqli_write_t)(mysqli_object *obj, zval *member, zval *newval TSRMLS_DC);
+
+typedef struct _mysqli_prop_handler {
+ mysqli_read_t read_func;
+ mysqli_write_t write_func;
+} mysqli_prop_handler;
/* {{{ php_free_stmt_bind_buffer */
void php_free_stmt_bind_buffer(BIND_BUFFER bbuf, int type)
@@ -96,6 +109,9 @@ static void mysqli_objects_dtor(void *object, zend_object_handle handle TSRMLS_D
mysqli_object *intern = (mysqli_object *)object;
MYSQLI_RESOURCE *my_res = (MYSQLI_RESOURCE *)intern->ptr;
+ zend_hash_destroy(intern->zo.properties);
+ FREE_HASHTABLE(intern->zo.properties);
+
/* link object */
if (intern->zo.ce == mysqli_link_class_entry) {
if (my_res && my_res->ptr) {
@@ -111,7 +127,7 @@ static void mysqli_objects_dtor(void *object, zend_object_handle handle TSRMLS_D
}
}
my_efree(my_res);
- zend_objects_destroy_object(object, handle TSRMLS_CC);
+ efree(object);
}
/* }}} */
@@ -122,7 +138,85 @@ static void mysqli_objects_clone(void *object, void **object_clone TSRMLS_DC)
/* TODO */
}
/* }}} */
-
+
+/* {{{ mysqli_read_na */
+static int mysqli_read_na(mysqli_object *obj, zval **retval TSRMLS_DC)
+{
+ *retval = NULL;
+ php_error_docref(NULL TSRMLS_CC, E_ERROR, "Cannot read property");
+ return FAILURE;
+}
+/* }}} */
+
+/* {{{ mysqli_write_na */
+static int mysqli_write_na(mysqli_object *obj, zval *member, zval *newval TSRMLS_DC)
+{
+ php_error_docref(NULL TSRMLS_CC, E_ERROR, "Cannot write property");
+ return FAILURE;
+}
+/* }}} */
+
+/* {{{ mysqli_read_property */
+zval *mysqli_read_property(zval *object, zval *member, zend_bool silent TSRMLS_DC)
+{
+ zval tmp_member;
+ zval *retval;
+ mysqli_object *obj;
+ mysqli_prop_handler *hnd;
+ zend_object_handlers *std_hnd;
+ int ret;
+
+ if (member->type != IS_STRING) {
+ tmp_member = *member;
+ zval_copy_ctor(&tmp_member);
+ convert_to_string(&tmp_member);
+ member = &tmp_member;
+ }
+
+ ret = FAILURE;
+ obj = (mysqli_object *)zend_objects_get_address(object TSRMLS_CC);
+
+ if (obj->prop_handler != NULL) {
+ ret = zend_hash_find(obj->prop_handler, Z_STRVAL_P(member), Z_STRLEN_P(member)+1, (void **) &hnd);
+ }
+ if (ret == SUCCESS) {
+ ret = hnd->read_func(obj, &retval TSRMLS_CC);
+ if (ret == SUCCESS) {
+ /* ensure we're creating a temporary variable */
+ retval->refcount = 0;
+ } else {
+ retval = EG(uninitialized_zval_ptr);
+ }
+ } else {
+ std_hnd = zend_get_std_object_handlers();
+ retval = std_hnd->read_property(object, member, silent TSRMLS_CC);
+ }
+
+ if (member == &tmp_member) {
+ zval_dtor(member);
+ }
+
+
+ return(retval);
+}
+/* }}} */
+
+/* {{{ mysqli_write_property */
+void mysqli_write_property(zval *object, zval *member, zval *value TSRMLS_DC)
+{
+ return;
+}
+/* }}} */
+
+void mysqli_add_property(HashTable *h, char *pname, mysqli_read_t r_func, mysqli_write_t w_func TSRMLS_DC) {
+ mysqli_prop_handler p;
+
+ p.read_func = (r_func) ? r_func : mysqli_read_na;
+ p.write_func = (w_func) ? w_func : mysqli_write_na;
+
+ zend_hash_add(h, pname, strlen(pname) + 1, &p, sizeof(mysqli_prop_handler), NULL);
+}
+
/* {{{ mysqli_objects_new
*/
PHP_MYSQLI_EXPORT(zend_object_value) mysqli_objects_new(zend_class_entry *class_type TSRMLS_DC)
@@ -136,6 +230,9 @@ PHP_MYSQLI_EXPORT(zend_object_value) mysqli_objects_new(zend_class_entry *class_
intern->zo.in_get = 0;
intern->zo.in_set = 0;
intern->ptr = NULL;
+ intern->prop_handler = NULL;
+
+ zend_hash_find(&classes, class_type->name, class_type->name_length + 1, (void **) &intern->prop_handler);
ALLOC_HASHTABLE(intern->zo.properties);
zend_hash_init(intern->zo.properties, 0, NULL, ZVAL_PTR_DTOR, 0);
@@ -197,6 +294,7 @@ static void php_mysqli_init_globals(zend_mysqli_globals *mysqli_globals)
mysqli_globals->default_pw = NULL;
mysqli_globals->default_socket = NULL;
mysqli_globals->profiler = 0;
+ mysqli_globals->multi_query = 0;
}
/* }}} */
@@ -204,16 +302,40 @@ static void php_mysqli_init_globals(zend_mysqli_globals *mysqli_globals)
*/
PHP_MINIT_FUNCTION(mysqli)
{
+ zend_class_entry *ce;
ZEND_INIT_MODULE_GLOBALS(mysqli, php_mysqli_init_globals, NULL);
REGISTER_INI_ENTRIES();
memcpy(&mysqli_object_handlers, zend_get_std_object_handlers(), sizeof(zend_object_handlers));
mysqli_object_handlers.clone_obj = zend_objects_store_clone_obj;
+ mysqli_object_handlers.read_property = mysqli_read_property;
+ mysqli_object_handlers.write_property = mysqli_write_property;
+ mysqli_object_handlers.get_property_ptr_ptr = NULL;
+// mysqli_object_handlers.call_method = php_mysqli_connect;
+
+/* todo: call method */
+
+ zend_hash_init(&classes, 0, NULL, NULL, 1);
REGISTER_MYSQLI_CLASS_ENTRY("mysqli", mysqli_link_class_entry, mysqli_link_methods);
+
+ ce = mysqli_link_class_entry;
+ zend_hash_init(&mysqli_link_properties, 0, NULL, NULL, 1);
+ MYSQLI_ADD_PROPERTIES(&mysqli_link_properties, mysqli_link_property_entries);
+ zend_hash_add(&classes, ce->name, ce->name_length+1, &mysqli_link_properties, sizeof(mysqli_link_properties), NULL);
+
REGISTER_MYSQLI_CLASS_ENTRY("mysqli_result", mysqli_result_class_entry, mysqli_result_methods);
+ ce = mysqli_result_class_entry;
+ zend_hash_init(&mysqli_result_properties, 0, NULL, NULL, 1);
+ MYSQLI_ADD_PROPERTIES(&mysqli_result_properties, mysqli_result_property_entries);
+ zend_hash_add(&classes, ce->name, ce->name_length+1, &mysqli_result_properties, sizeof(mysqli_result_properties), NULL);
+
REGISTER_MYSQLI_CLASS_ENTRY("mysqli_stmt", mysqli_stmt_class_entry, mysqli_stmt_methods);
+ ce = mysqli_stmt_class_entry;
+ zend_hash_init(&mysqli_stmt_properties, 0, NULL, NULL, 1);
+ MYSQLI_ADD_PROPERTIES(&mysqli_stmt_properties, mysqli_stmt_property_entries);
+ zend_hash_add(&classes, ce->name, ce->name_length+1, &mysqli_stmt_properties, sizeof(mysqli_stmt_properties), NULL);
/* mysqli_options */
REGISTER_LONG_CONSTANT("MYSQLI_READ_DEFAULT_GROUP", MYSQL_READ_DEFAULT_GROUP, CONST_CS | CONST_PERSISTENT);
@@ -310,6 +432,9 @@ PHP_MINIT_FUNCTION(mysqli)
*/
PHP_MSHUTDOWN_FUNCTION(mysqli)
{
+ zend_hash_destroy(&mysqli_link_properties);
+ zend_hash_destroy(&classes);
+
UNREGISTER_INI_ENTRIES();
return SUCCESS;
}
@@ -421,7 +546,7 @@ void php_mysqli_fetch_into_hash(INTERNAL_FUNCTION_PARAMETERS, int override_flags
fields = mysql_fetch_fields(result);
if (!(row = mysql_fetch_row(result))) {
- RETURN_FALSE;
+ RETURN_NULL();
}
array_init(return_value);
diff --git a/ext/mysqli/mysqli_api.c b/ext/mysqli/mysqli_api.c
index 6c90bb63c0..f01ba5c79c 100644
--- a/ext/mysqli/mysqli_api.c
+++ b/ext/mysqli/mysqli_api.c
@@ -372,6 +372,7 @@ PHP_FUNCTION(mysqli_change_user)
MYSQLI_PROFILER_COMMAND_START(prcommand, prmysql);
rc = mysql_change_user(mysql, user, password, dbname);
MYSQLI_PROFILER_COMMAND_RETURNLONG(prcommand, rc);
+
if (rc) {
RETURN_FALSE;
}
@@ -1014,7 +1015,7 @@ PHP_FUNCTION(mysqli_get_host_info)
}
/* }}} */
-/* {{{ proto int mysqli_get_proto_info(object link)
+/* {{{ proto int mysqli_get_proto_info(object link)
Get MySQL protocol information */
PHP_FUNCTION(mysqli_get_proto_info)
{
@@ -1160,6 +1161,44 @@ PHP_FUNCTION(mysqli_master_query) {
}
/* }}} */
+/* {{{ 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;
+ PR_MYSQL *prmysql;
+
+ 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 *, prmysql, PR_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;
+ PR_MYSQL *prmysql;
+
+ 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 *, prmysql, PR_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)
@@ -1413,7 +1452,7 @@ PHP_FUNCTION(mysqli_real_connect)
MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, prmysql, PR_MYSQL *, &mysql_link, "mysqli_link");
/* remove some insecure options */
- flags ^= CLIENT_MULTI_QUERIES; /* don't allow multi_queries via connect parameter */
+ flags ^= CLIENT_MULTI_STATEMENTS; /* don't allow multi_queries via connect parameter */
if (PG(open_basedir) && strlen(PG(open_basedir))) {
flags ^= CLIENT_LOCAL_FILES;
}
@@ -1446,6 +1485,7 @@ PHP_FUNCTION(mysqli_real_query)
}
MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, prmysql, PR_MYSQL *, &mysql_link, "mysqli_link");
+ MYSQLI_DISABLE_MQ;
if (mysql_real_query(mysql, query, query_len)) {
RETURN_FALSE;
}
@@ -1925,8 +1965,10 @@ PHP_FUNCTION(mysqli_store_result)
MYSQLI_FETCH_RESOURCE(mysql, MYSQL *, prmysql, PR_MYSQL *, &mysql_link, "mysqli_link");
if (!(result = mysql_store_result(mysql))) {
+ MYSQLI_DISABLE_MQ;
RETURN_FALSE;
}
+// 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);
diff --git a/ext/mysqli/mysqli_fe.c b/ext/mysqli/mysqli_fe.c
index 93b5aaaac4..7e8eb87595 100644
--- a/ext/mysqli/mysqli_fe.c
+++ b/ext/mysqli/mysqli_fe.c
@@ -87,6 +87,7 @@ function_entry mysqli_functions[] = {
PHP_FE(mysqli_free_result, NULL)
PHP_FE(mysqli_get_client_info, NULL)
PHP_FE(mysqli_get_host_info, NULL)
+ PHP_FE(mysqli_get_metadata, NULL)
PHP_FE(mysqli_get_proto_info, NULL)
PHP_FE(mysqli_get_server_info, NULL)
PHP_FE(mysqli_get_server_version, NULL)
@@ -95,13 +96,14 @@ function_entry mysqli_functions[] = {
PHP_FE(mysqli_insert_id, NULL)
PHP_FE(mysqli_kill, NULL)
PHP_FE(mysqli_master_query, NULL)
+ PHP_FE(mysqli_more_results, NULL)
+ PHP_FE(mysqli_next_result, NULL)
PHP_FE(mysqli_num_fields, NULL)
PHP_FE(mysqli_num_rows, NULL)
PHP_FE(mysqli_options, NULL)
PHP_FE(mysqli_param_count, NULL)
PHP_FE(mysqli_ping, NULL)
PHP_FE(mysqli_prepare, NULL)
- PHP_FE(mysqli_get_metadata, NULL)
PHP_FE(mysqli_profiler, NULL)
PHP_FE(mysqli_query, NULL)
PHP_FE(mysqli_read_query_result, NULL)
@@ -153,7 +155,6 @@ function_entry mysqli_functions[] = {
* Every user visible function must have an entry in mysqli_functions[].
*/
function_entry mysqli_link_methods[] = {
- PHP_FALIAS(affected_rows,mysqli_affected_rows,NULL)
PHP_FALIAS(autocommit,mysqli_autocommit,NULL)
PHP_FALIAS(change_user,mysqli_change_user,NULL)
PHP_FALIAS(character_set_name,mysqli_character_set_name,NULL)
@@ -167,18 +168,18 @@ function_entry mysqli_link_methods[] = {
PHP_FALIAS(dump_debug_info,mysqli_dump_debug_info,NULL)
PHP_FALIAS(enable_reads_from_master,mysqli_enable_reads_from_master,NULL)
PHP_FALIAS(enable_rpl_parse,mysqli_enable_rpl_parse,NULL)
- PHP_FALIAS(errno,mysqli_errno,NULL)
- PHP_FALIAS(error,mysqli_error,NULL)
PHP_FALIAS(get_client_info,mysqli_get_client_info,NULL)
PHP_FALIAS(get_host_info,mysqli_get_host_info,NULL)
- PHP_FALIAS(get_proto_info,mysqli_get_proto_info,NULL)
PHP_FALIAS(get_server_info,mysqli_get_server_info,NULL)
- PHP_FALIAS(get_server_version,mysqli_get_server_version,NULL)
PHP_FALIAS(init,mysqli_init,NULL)
PHP_FALIAS(info,mysqli_info,NULL)
PHP_FALIAS(insert_id,mysqli_insert_id,NULL)
PHP_FALIAS(kill,mysqli_kill,NULL)
PHP_FALIAS(master_query,mysqli_master_query,NULL)
+ PHP_FALIAS(mysqli, mysqli_connect, NULL)
+ PHP_FALIAS(multi_query,mysqli_multi_query,NULL)
+ PHP_FALIAS(more_results,mysqli_more_results, NULL)
+ PHP_FALIAS(next_result, mysqli_next_result, NULL)
PHP_FALIAS(options,mysqli_options,NULL)
PHP_FALIAS(ping,mysqli_ping,NULL)
PHP_FALIAS(prepare,mysqli_prepare,NULL)
@@ -196,16 +197,11 @@ function_entry mysqli_link_methods[] = {
PHP_FALIAS(select_db,mysqli_select_db,NULL)
PHP_FALIAS(set_opt, mysqli_options,NULL)
PHP_FALIAS(slave_query,mysqli_slave_query,NULL)
-#if MYSQL_VERSION_ID >= 40101
- PHP_FALIAS(sqlstate, mysqli_sqlstate,NULL)
-#endif
PHP_FALIAS(ssl_set,mysqli_ssl_set,NULL)
PHP_FALIAS(stat,mysqli_stat,NULL)
PHP_FALIAS(store_result,mysqli_store_result,NULL)
- PHP_FALIAS(thread_id, mysqli_thread_id,NULL)
PHP_FALIAS(thread_safe,mysqli_thread_safe,NULL)
PHP_FALIAS(use_result,mysqli_use_result,NULL)
- PHP_FALIAS(warning_count,mysqli_warning_count,NULL)
{NULL, NULL, NULL}
};
/* }}} */
@@ -221,7 +217,6 @@ function_entry mysqli_result_methods[] = {
PHP_FALIAS(fetch_field,mysqli_fetch_field,NULL)
PHP_FALIAS(fetch_fields,mysqli_fetch_fields,NULL)
PHP_FALIAS(fetvh_field_direct,mysqli_fetch_field_direct,NULL)
- PHP_FALIAS(fetch_lengths,mysqli_fetch_lengths,NULL)
PHP_FALIAS(fetch_array,mysqli_fetch_array,NULL)
PHP_FALIAS(fetch_assoc,mysqli_fetch_assoc,NULL)
PHP_FALIAS(fetch_object,mysqli_fetch_object,NULL)
@@ -230,8 +225,6 @@ function_entry mysqli_result_methods[] = {
PHP_FALIAS(field_seek,mysqli_field_seek,NULL)
PHP_FALIAS(field_tell,mysqli_field_tell,NULL)
PHP_FALIAS(free_result,mysqli_free_result,NULL)
- PHP_FALIAS(num_fields,mysqli_num_fields,NULL)
- PHP_FALIAS(num_rows,mysqli_num_rows,NULL)
{NULL, NULL, NULL}
};
/* }}} */
@@ -246,18 +239,12 @@ function_entry mysqli_stmt_methods[] = {
PHP_FALIAS(bind_result,mysqli_bind_result, all_args_by_ref)
PHP_FALIAS(close,mysqli_stmt_close,NULL)
PHP_FALIAS(data_seek,mysqli_stmt_data_seek,NULL)
- PHP_FALIAS(errno,mysqli_stmt_errno,NULL)
- PHP_FALIAS(error,mysqli_stmt_error,NULL)
PHP_FALIAS(execute,mysqli_execute,NULL)
PHP_FALIAS(fetch,mysqli_fetch,NULL)
PHP_FALIAS(get_metadata, mysqli_get_metadata,NULL)
PHP_FALIAS(num_rows, mysqli_stmt_num_rows,NULL)
- PHP_FALIAS(param_count,mysqli_param_count,NULL)
PHP_FALIAS(send_long_data,mysqli_send_long_data,NULL)
PHP_FALIAS(store_result,mysqli_stmt_store_result,NULL)
-#if MYSQL_VERSION_ID >= 40101
- PHP_FALIAS(sqlstate, mysqli_stmt_sqlstate,NULL)
-#endif
{NULL, NULL, NULL}
};
/* }}} */
diff --git a/ext/mysqli/mysqli_nonapi.c b/ext/mysqli/mysqli_nonapi.c
index d5c8f22b3f..ed09af20e5 100644
--- a/ext/mysqli/mysqli_nonapi.c
+++ b/ext/mysqli/mysqli_nonapi.c
@@ -171,7 +171,11 @@ PHP_FUNCTION(mysqli_connect_errno)
Returns the text of the error message from previous MySQL operation */
PHP_FUNCTION(mysqli_connect_error)
{
- RETURN_STRING(MyG(error_msg),1);
+ if (MyG(error_msg)) {
+ RETURN_STRING(MyG(error_msg),1);
+ } else {
+ RETURN_NULL();
+ }
}
/* }}} */
@@ -199,8 +203,31 @@ PHP_FUNCTION(mysqli_fetch_object)
}
/* }}} */
-/* {{{ proto resource mysqli_query(object link, string query [,int resultmode])
- Send a MySQL query */
+/* {{{ proto bool mysqli_multi_query(object link, string query)
+ Binary-safe version of mysql_query() */
+PHP_FUNCTION(mysqli_multi_query)
+{
+ MYSQL *mysql;
+ zval *mysql_link;
+ char *query = NULL;
+ unsigned int query_len;
+ PR_MYSQL *prmysql;
+
+ 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 *, prmysql, PR_MYSQL *, &mysql_link, "mysqli_link");
+
+ MYSQLI_ENABLE_MQ;
+ if (mysql_real_query(mysql, query, query_len)) {
+ MYSQLI_DISABLE_MQ;
+ RETURN_FALSE;
+ }
+ RETURN_TRUE;
+}
+/* }}} */
+
+/* {{{ proto resource mysqli_query(object link, string query [,int resultmode]) */
PHP_FUNCTION(mysqli_query)
{
MYSQL *mysql;
@@ -231,6 +258,8 @@ PHP_FUNCTION(mysqli_query)
}
}
+ MYSQLI_DISABLE_MQ;
+
if (mysql_real_query(mysql, query, query_len)) {
RETURN_FALSE;
}
diff --git a/ext/mysqli/mysqli_prop.c b/ext/mysqli/mysqli_prop.c
new file mode 100644
index 0000000000..cfb2fa2c91
--- /dev/null
+++ b/ext/mysqli/mysqli_prop.c
@@ -0,0 +1,181 @@
+/*
+ +----------------------------------------------------------------------+
+ | PHP Version 5 |
+ +----------------------------------------------------------------------+
+ | Copyright (c) 1997-2002 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"
+
+#define MYSQLI_MAP_PROPERTY_LONG(__func, __type, __val)\
+int __func(mysqli_object *obj, zval **retval TSRMLS_DC) \
+{\
+ __type *p = (__type *)((MYSQLI_RESOURCE *)(obj->ptr))->ptr;\
+ ALLOC_ZVAL(*retval);\
+ if (!p) {\
+ ZVAL_NULL(*retval);\
+ } else {\
+ ZVAL_LONG(*retval, (long)p->__val);\
+ }\
+ return SUCCESS;\
+}\
+
+#define MYSQLI_MAP_PROPERTY_STRING(__func, __type, __val)\
+int __func(mysqli_object *obj, zval **retval TSRMLS_DC) \
+{\
+ __type *p = (__type *)((MYSQLI_RESOURCE *)(obj->ptr))->ptr;\
+ ALLOC_ZVAL(*retval);\
+ if (!p) {\
+ ZVAL_NULL(*retval);\
+ } else {\
+ if (!p->__val) {\
+ ZVAL_NULL(*retval);\
+ } else {\
+ ZVAL_STRING(*retval, p->__val, 1);\
+ }\
+ }\
+ return SUCCESS;\
+}\
+
+/* {{{ property link_client_version_read */
+int link_client_version_read(mysqli_object *obj, zval **retval TSRMLS_DC) {
+ ALLOC_ZVAL(*retval);
+ ZVAL_STRING(*retval, MYSQL_SERVER_VERSION, 1);
+ return SUCCESS;
+}
+/* }}} */
+
+/* link properties */
+MYSQLI_MAP_PROPERTY_LONG(link_affected_rows_read, MYSQL, affected_rows);
+MYSQLI_MAP_PROPERTY_LONG(link_client_flags_read, MYSQL, client_flag);
+MYSQLI_MAP_PROPERTY_LONG(link_errno_read, MYSQL, net.last_errno);
+MYSQLI_MAP_PROPERTY_STRING(link_error_read, MYSQL, net.last_error);
+MYSQLI_MAP_PROPERTY_LONG(link_field_count_read, MYSQL, field_count);
+MYSQLI_MAP_PROPERTY_STRING(link_host_read, MYSQL, host);
+MYSQLI_MAP_PROPERTY_STRING(link_host_info_read, MYSQL, host_info);
+MYSQLI_MAP_PROPERTY_STRING(link_info_read, MYSQL, info);
+MYSQLI_MAP_PROPERTY_LONG(link_port_read, MYSQL, port);
+MYSQLI_MAP_PROPERTY_LONG(link_protocol_version_read, MYSQL, protocol_version);
+MYSQLI_MAP_PROPERTY_LONG(link_server_capabilities_read, MYSQL, server_capabilities);
+MYSQLI_MAP_PROPERTY_LONG(link_server_language_read, MYSQL, server_language);
+MYSQLI_MAP_PROPERTY_STRING(link_server_version_read, MYSQL, server_version);
+MYSQLI_MAP_PROPERTY_STRING(link_sqlstate_read, MYSQL, net.sqlstate);
+MYSQLI_MAP_PROPERTY_LONG(link_thread_id_read, MYSQL, thread_id);
+MYSQLI_MAP_PROPERTY_STRING(link_user_read, MYSQL, user);
+MYSQLI_MAP_PROPERTY_LONG(link_warning_count_read, MYSQL, warning_count);
+
+/* result properties */
+
+/* {{{ property result_type_read */
+int result_type_read(mysqli_object *obj, zval **retval TSRMLS_DC) {
+ MYSQL_RES *p = (MYSQL_RES *)((MYSQLI_RESOURCE *)(obj->ptr))->ptr;
+
+ ALLOC_ZVAL(*retval);
+ if (!p) {
+ ZVAL_NULL(*retval);
+ } else {
+ ZVAL_LONG(*retval, (p->data) ? MYSQLI_STORE_RESULT : MYSQLI_USE_RESULT);
+ }
+ return SUCCESS;
+}
+/* }}} */
+
+/* {{{ property result_lengths_read */
+int result_lengths_read(mysqli_object *obj, zval **retval TSRMLS_DC) {
+ MYSQL_RES *p = (MYSQL_RES *)((MYSQLI_RESOURCE *)(obj->ptr))->ptr;
+
+ ALLOC_ZVAL(*retval);
+ if (!p || !p->field_count) {
+ ZVAL_NULL(*retval);
+ } else {
+ ulong i;
+ zval *l;
+
+ array_init(*retval);
+
+ for (i=0; i < p->field_count; i++) {
+ MAKE_STD_ZVAL(l);
+ ZVAL_LONG(l, p->lengths[i]);
+ add_index_zval(*retval, i, l);
+ }
+ }
+ return SUCCESS;
+}
+/* }}} */
+
+MYSQLI_MAP_PROPERTY_LONG(result_current_field_read, MYSQL_RES, current_field);
+MYSQLI_MAP_PROPERTY_LONG(result_field_count_read, MYSQL_RES, field_count);
+MYSQLI_MAP_PROPERTY_LONG(result_num_rows_read, MYSQL_RES, row_count);
+
+/* statement properties */
+MYSQLI_MAP_PROPERTY_STRING(stmt_query_read, MYSQL_STMT, query);
+MYSQLI_MAP_PROPERTY_LONG(stmt_param_count_read, MYSQL_STMT, param_count);
+MYSQLI_MAP_PROPERTY_LONG(stmt_field_count_read, MYSQL_STMT, field_count);
+MYSQLI_MAP_PROPERTY_LONG(stmt_id_read, MYSQL_STMT, stmt_id);
+MYSQLI_MAP_PROPERTY_LONG(stmt_errno_read, MYSQL_STMT, last_errno);
+MYSQLI_MAP_PROPERTY_STRING(stmt_error_read, MYSQL_STMT, last_error);
+MYSQLI_MAP_PROPERTY_STRING(stmt_sqlstate_read, MYSQL_STMT, sqlstate);
+
+mysqli_property_entry mysqli_link_property_entries[] = {
+ {"affected_rows", link_affected_rows_read, NULL},
+ {"client_flags", link_client_flags_read, NULL},
+ {"client_version", link_client_version_read, NULL},
+ {"errno", link_errno_read, NULL},
+ {"error", link_error_read, NULL},
+ {"field_count", link_field_count_read, NULL},
+ {"host", link_host_read, NULL},
+ {"host_info", link_host_info_read, NULL},
+ {"info", link_info_read, NULL},
+ {"server_capabilities", link_server_capabilities_read, NULL},
+ {"server_version", link_server_version_read, NULL},
+ {"sqlstate", link_sqlstate_read, NULL},
+ {"port", link_port_read, NULL},
+ {"protocol_version", link_protocol_version_read, NULL},
+ {"server_language", link_protocol_version_read, NULL},
+ {"thread_id", link_thread_id_read, NULL},
+ {"user", link_user_read, NULL},
+ {"warning_count", link_warning_count_read, NULL},
+ {NULL, NULL, NULL}
+};
+
+mysqli_property_entry mysqli_result_property_entries[] = {
+ {"current_field", result_current_field_read, NULL},
+ {"field_count", result_field_count_read, NULL},
+ {"lengths", result_lengths_read, NULL},
+ {"num_rows", result_num_rows_read, NULL},
+ {"type", result_type_read, NULL},
+ {NULL, NULL, NULL}
+};
+
+mysqli_property_entry mysqli_stmt_property_entries[] = {
+ {"query", stmt_query_read, NULL},
+ {"param_count", stmt_param_count_read, NULL},
+ {"field_count", stmt_field_count_read, NULL},
+ {"id", stmt_id_read, NULL},
+ {"errno", stmt_errno_read, NULL},
+ {"error", stmt_error_read, NULL},
+ {"sqlstate", stmt_sqlstate_read, NULL},
+ {NULL, NULL, NULL}
+};
diff --git a/ext/mysqli/php_mysqli.h b/ext/mysqli/php_mysqli.h
index 0d0f15f1dd..2b35876723 100644
--- a/ext/mysqli/php_mysqli.h
+++ b/ext/mysqli/php_mysqli.h
@@ -57,10 +57,17 @@ typedef struct {
} MYSQLI_RESOURCE;
typedef struct _mysqli_object {
- zend_object zo;
- void *ptr;
+ zend_object zo;
+ void *ptr;
+ HashTable *prop_handler;
} mysqli_object; /* extends zend_object */
+typedef struct _mysqli_property_entry {
+ char *pname;
+ int (*r_func)(mysqli_object *obj, zval **retval TSRMLS_DC);
+ int (*w_func)(mysqli_object *obj, zval **retval TSRMLS_DC);
+} mysqli_property_entry;
+
#define MYSQLI_PR_MAIN 0
#define MYSQLI_PR_MYSQL 1
#define MYSQLI_PR_QUERY 2
@@ -90,6 +97,10 @@ extern function_entry mysqli_functions[];
extern function_entry mysqli_link_methods[];
extern function_entry mysqli_stmt_methods[];
extern function_entry mysqli_result_methods[];
+extern mysqli_property_entry mysqli_link_property_entries[];
+extern mysqli_property_entry mysqli_result_property_entries[];
+extern mysqli_property_entry mysqli_stmt_property_entries[];
+
extern void php_mysqli_fetch_into_hash(INTERNAL_FUNCTION_PARAMETERS, int override_flag, int into_object);
extern void php_clear_stmt_bind(STMT *stmt);
extern void php_free_stmt_bind_buffer(BIND_BUFFER bbuf, int type);
@@ -104,6 +115,16 @@ zend_class_entry _mysqli_result_class_entry;
PHP_MYSQLI_EXPORT(zend_object_value) mysqli_objects_new(zend_class_entry * TSRMLS_DC);
+#define MYSQLI_DISABLE_MQ if (MyG(multi_query)) { \
+ mysql_set_server_option(mysql, MYSQL_OPTION_MULTI_STATEMENTS_OFF); \
+ MyG(multi_query) = 0; \
+}
+
+#define MYSQLI_ENABLE_MQ if (!MyG(multi_query)) { \
+ mysql_set_server_option(mysql, MYSQL_OPTION_MULTI_STATEMENTS_ON); \
+ MyG(multi_query) = 1; \
+}
+
#define REGISTER_MYSQLI_CLASS_ENTRY(name, mysqli_entry, class_functions) { \
INIT_CLASS_ENTRY(_##mysqli_entry,name,class_functions); \
_##mysqli_entry.create_object = mysqli_objects_new; \
@@ -165,11 +186,20 @@ PHP_MYSQLI_EXPORT(zend_object_value) mysqli_objects_new(zend_class_entry * TSRML
} \
}
-#define MYSQLI_STORE_RESULT 0
+#define MYSQLI_ADD_PROPERTIES(a,b) \
+{ \
+ int i = 0; \
+ while (b[i].pname != NULL) { \
+ mysqli_add_property(a, b[i].pname, (mysqli_read_t)b[i].r_func, NULL TSRMLS_CC); \
+ i++; \
+ }\
+}
+
+#define MYSQLI_STORE_RESULT 0
#define MYSQLI_USE_RESULT 1
/* for mysqli_fetch_assoc */
-#define MYSQLI_ASSOC 1
+#define MYSQLI_ASSOC 1
#define MYSQLI_NUM 2
#define MYSQLI_BOTH 3
@@ -194,6 +224,7 @@ PHP_RINIT_FUNCTION(mysqli);
PHP_RSHUTDOWN_FUNCTION(mysqli);
PHP_MINFO_FUNCTION(mysqli);
+PHP_FUNCTION(mysqli);
PHP_FUNCTION(mysqli_affected_rows);
PHP_FUNCTION(mysqli_autocommit);
PHP_FUNCTION(mysqli_bind_param);
@@ -241,6 +272,9 @@ PHP_FUNCTION(mysqli_insert_id);
PHP_FUNCTION(mysqli_init);
PHP_FUNCTION(mysqli_kill);
PHP_FUNCTION(mysqli_master_query);
+PHP_FUNCTION(mysqli_more_results);
+PHP_FUNCTION(mysqli_multi_query);
+PHP_FUNCTION(mysqli_next_result);
PHP_FUNCTION(mysqli_num_fields);
PHP_FUNCTION(mysqli_num_rows);
PHP_FUNCTION(mysqli_options);
@@ -301,11 +335,17 @@ ZEND_BEGIN_MODULE_GLOBALS(mysqli)
long error_no;
char *error_msg;
unsigned int profiler;
+ unsigned int multi_query;
#ifdef HAVE_EMBEDDED_MYSQLI
unsigned int embedded;
#endif
ZEND_END_MODULE_GLOBALS(mysqli)
+
+#define MYSQLI_PROPERTY(a) extern int a(mysqli_object *obj, zval **retval TSRMLS_DC)
+
+MYSQLI_PROPERTY(my_prop_link_host);
+
#ifdef ZTS
#define MyG(v) TSRMG(mysqli_globals_id, zend_mysqli_globals *, v)
#else