IT. Expert System.

PHP

The MySQLi Extension Function Summary


The MySQLi Extension Function Summary

mysqli Class
OOP Interface Procedural Interface Alias (Do not use) Description
Properties
$mysqli::affected_rows mysqli_affected_rows() N/A Gets the number of affected rows in a previous MySQL operation
$mysqli::client_info mysqli_get_client_info() N/A Returns the MySQL client version as a string
$mysqli::client_version mysqli_get_client_version() N/A Returns MySQL client version info as an integer
$mysqli::connect_errno mysqli_connect_errno() N/A Returns the error code from last connect call
$mysqli::connect_error mysqli_connect_error() N/A Returns a string description of the last connect error
$mysqli::errno mysqli_errno() N/A Returns the error code for the most recent function call
$mysqli::error mysqli_error() N/A Returns a string description of the last error
$mysqli::field_count mysqli_field_count() N/A Returns the number of columns for the most recent query
$mysqli::host_info mysqli_get_host_info() N/A Returns a string representing the type of connection used
$mysqli::protocol_version mysqli_get_proto_info() N/A Returns the version of the MySQL protocol used
$mysqli::server_info mysqli_get_server_info() N/A Returns the version of the MySQL server
$mysqli::server_version mysqli_get_server_version() N/A Returns the version of the MySQL server as an integer
$mysqli::info mysqli_info() N/A Retrieves information about the most recently executed query
$mysqli::insert_id mysqli_insert_id() N/A Returns the auto generated id used in the last query
$mysqli::sqlstate mysqli_sqlstate() N/A Returns the SQLSTATE error from previous MySQL operation
$mysqli::warning_count mysqli_warning_count() N/A Returns the number of warnings from the last query for the given link
Methods
mysqli::autocommit() mysqli_autocommit() N/A Turns on or off auto-commiting database modifications
mysqli::change_user() mysqli_change_user() N/A Changes the user of the specified database connection
mysqli::character_set_name(), mysqli::client_encoding mysqli_character_set_name() mysqli_client_encoding() Returns the default character set for the database connection
mysqli::close() mysqli_close() N/A Closes a previously opened database connection
mysqli::commit() mysqli_commit() N/A Commits the current transaction
mysqli::__construct() mysqli_connect() N/A Open a new connection to the MySQL server [Note: static (i.e. class) method]
mysqli::debug() mysqli_debug() N/A Performs debugging operations
mysqli::dump_debug_info() mysqli_dump_debug_info() N/A Dump debugging information into the log
mysqli::get_charset() mysqli_get_charset() N/A Returns a character set object
mysqli::get_connection_stats() mysqli_get_connection_stats() N/A Returns client connection statistics. Available only with mysqlnd.
mysqli::get_client_info() mysqli_get_client_info() N/A Returns the MySQL client version as a string
mysqli::get_client_stats() mysqli_get_client_stats() N/A Returns client per-process statistics. Available only with mysqlnd.
mysqli::get_cache_stats() mysqli_get_cache_stats() N/A Returns client Zval cache statistics. Available only with mysqlnd.
mysqli::get_server_info() mysqli_get_server_info() N/A NOT DOCUMENTED
mysqli::get_warnings() mysqli_get_warnings() N/A NOT DOCUMENTED
mysqli::init() mysqli_init() N/A Initializes MySQLi and returns a resource for use with mysqli_real_connect. [Not called on an object, as it returns a $mysqli object.]
mysqli::kill() mysqli_kill() N/A Asks the server to kill a MySQL thread
mysqli::more_results() mysqli_more_results() N/A Check if there are any more query results from a multi query
mysqli::multi_query() mysqli_multi_query() N/A Performs a query on the database
mysqli::next_result() mysqli_next_result() N/A Prepare next result from multi_query
mysqli::options() mysqli_options() mysqli_set_opt() Set options
mysqli::ping() mysqli_ping() N/A Pings a server connection, or tries to reconnect if the connection has gone down
mysqli::prepare() mysqli_prepare() N/A Prepare an SQL statement for execution
mysqli::query() mysqli_query() N/A Performs a query on the database
mysqli::real_connect() mysqli_real_connect() N/A Opens a connection to a mysql server
mysqli::real_escape_string(), mysqli::escape_string() mysqli_real_escape_string() mysqli_escape_string() Escapes special characters in a string for use in an SQL statement, taking into account the current charset of the connection
mysqli::real_query() mysqli_real_query() N/A Execute an SQL query
mysqli::refresh() mysqli_refresh() N/A Flushes tables or caches, or resets the replication server information
mysqli::rollback() mysqli_rollback() N/A Rolls back current transaction
mysqli::select_db() mysqli_select_db() N/A Selects the default database for database queries
mysqli::set_charset() mysqli_set_charset() N/A Sets the default client character set
mysqli::set_local_infile_default() mysqli_set_local_infile_default() N/A Unsets user defined handler for load local infile command
mysqli::set_local_infile_handler() mysqli_set_local_infile_handler() N/A Set callback function for LOAD DATA LOCAL INFILE command
mysqli::ssl_set() mysqli_ssl_set() N/A Used for establishing secure connections using SSL
mysqli::stat() mysqli_stat() N/A Gets the current system status
mysqli::stmt_init() mysqli_stmt_init() N/A Initializes a statement and returns an object for use with mysqli_stmt_prepare
mysqli::store_result() mysqli_store_result() N/A Transfers a result set from the last query
mysqli::thread_id() mysqli_thread_id() N/A Returns the thread ID for the current connection
mysqli::thread_safe() mysqli_thread_safe() N/A Returns whether thread safety is given or not
mysqli::use_result() mysqli_use_result() N/A Initiate a result set retrieval
MySQL_STMT
OOP Interface Procedural Interface Alias (Do not use) Description
Properties
$mysqli_stmt::affected_rows mysqli_stmt_affected_rows() N/A Returns the total number of rows changed, deleted, or inserted by the last executed statement
$mysqli_stmt::errno mysqli_stmt_errno() N/A Returns the error code for the most recent statement call
$mysqli_stmt::error mysqli_stmt_error() N/A Returns a string description for last statement error
$mysqli_stmt::field_count mysqli_stmt_field_count() N/A Returns the number of field in the given statement - not documented
$mysqli_stmt::insert_id mysqli_stmt_insert_id() N/A Get the ID generated from the previous INSERT operation
$mysqli_stmt::num_rows mysqli_stmt_num_rows() N/A Return the number of rows in statements result set
$mysqli_stmt::param_count mysqli_stmt_param_count() mysqli_param_count() Returns the number of parameter for the given statement
$mysqli_stmt::sqlstate mysqli_stmt_sqlstate() N/A Returns SQLSTATE error from previous statement operation
Methods
mysqli_stmt::attr_get() mysqli_stmt_attr_get() N/A Used to get the current value of a statement attribute
mysqli_stmt::attr_set() mysqli_stmt_attr_set() N/A Used to modify the behavior of a prepared statement
mysqli_stmt::bind_param() mysqli_stmt_bind_param() mysqli_bind_param() Binds variables to a prepared statement as parameters
mysqli_stmt::bind_result() mysqli_stmt_bind_result() mysqli_bind_result() Binds variables to a prepared statement for result storage
mysqli_stmt::close() mysqli_stmt_close() N/A Closes a prepared statement
mysqli_stmt::data_seek() mysqli_stmt_data_seek() N/A Seeks to an arbitrary row in statement result set
mysqli_stmt::execute() mysqli_stmt_execute() mysqli_execute() Executes a prepared Query
mysqli_stmt::fetch() mysqli_stmt_fetch() mysqli_fetch() Fetch results from a prepared statement into the bound variables
mysqli_stmt::free_result() mysqli_stmt_free_result() N/A Frees stored result memory for the given statement handle
mysqli_stmt::get_result() mysqli_stmt_get_result() N/A Gets a result set from a prepared statement. Available only with mysqlnd.
mysqli_stmt::get_warnings() mysqli_stmt_get_warnings() N/A NOT DOCUMENTED
$mysqli_stmt::more_results() mysqli_stmt_more_results() N/A NOT DOCUMENTED Available only with mysqlnd.
$mysqli_stmt::next_result() mysqli_stmt_next_result() N/A NOT DOCUMENTED Available only with mysqlnd.
mysqli_stmt::num_rows() mysqli_stmt_num_rows() N/A See also property $mysqli_stmt::num_rows
mysqli_stmt::prepare() mysqli_stmt_prepare() N/A Prepare an SQL statement for execution
mysqli_stmt::reset() mysqli_stmt_reset() N/A Resets a prepared statement
mysqli_stmt::result_metadata() mysqli_stmt_result_metadata() mysqli_get_metadata() Returns result set metadata from a prepared statement
mysqli_stmt::send_long_data() mysqli_stmt_send_long_data() mysqli_send_long_data() Send data in blocks
mysqli_stmt::store_result() mysqli_stmt_store_result() N/A Transfers a result set from a prepared statement
mysqli_result
OOP Interface Procedural Interface Alias (Do not use) Description
Properties
$mysqli_result::current_field mysqli_field_tell() N/A Get current field offset of a result pointer
$mysqli_result::field_count mysqli_num_fields() N/A Get the number of fields in a result
$mysqli_result::lengths mysqli_fetch_lengths() N/A Returns the lengths of the columns of the current row in the result set
$mysqli_result::num_rows mysqli_num_rows() N/A Gets the number of rows in a result
Methods
mysqli_result::data_seek() mysqli_data_seek() N/A Adjusts the result pointer to an arbitary row in the result
mysqli_result::fetch_all() mysqli_fetch_all() N/A Fetches all result rows and returns the result set as an associative array, a numeric array, or both. Available only with mysqlnd.
mysqli_result::fetch_array() mysqli_fetch_array() N/A Fetch a result row as an associative, a numeric array, or both
mysqli_result::fetch_assoc() mysqli_fetch_assoc() N/A Fetch a result row as an associative array
mysqli_result::fetch_field_direct() mysqli_fetch_field_direct() N/A Fetch meta-data for a single field
mysqli_result::fetch_field() mysqli_fetch_field() N/A Returns the next field in the result set
mysqli_result::fetch_fields() mysqli_fetch_fields() N/A Returns an array of objects representing the fields in a result set
mysqli_result::fetch_object() mysqli_fetch_object() N/A Returns the current row of a result set as an object
mysqli_result::fetch_row() mysqli_fetch_row() N/A Get a result row as an enumerated array
mysqli_result::field_seek() mysqli_field_seek() N/A Set result pointer to a specified field offset
mysqli_result::free(), mysqli_result::close, mysqli_result::free_result mysqli_free_result() N/A Frees the memory associated with a result
MySQL_Driver
OOP Interface Procedural Interface Alias (Do not use) Description
Properties
N/A
Methods
mysqli_driver::embedded_server_end() mysqli_embedded_server_end() N/A NOT DOCUMENTED
mysqli_driver::embedded_server_start() mysqli_embedded_server_start() N/A NOT DOCUMENTED

Note:

Alias functions are provided for backward compatibility purposes only. Do not use them in new projects.



Content

Android Reference

Java basics

Java Enterprise Edition (EE)

Java Standard Edition (SE)

SQL

HTML

PHP

CSS

Java Script

MYSQL

JQUERY

VBS

REGEX

C

C++

C#

Design patterns

RFC (standard status)

RFC (proposed standard status)

RFC (draft standard status)

RFC (informational status)

RFC (experimental status)

RFC (best current practice status)

RFC (historic status)

RFC (unknown status)

IT dictionary

License.
All information of this service is derived from the free sources and is provided solely in the form of quotations. This service provides information and interfaces solely for the familiarization (not ownership) and under the "as is" condition.
Copyright 2016 © ELTASK.COM. All rights reserved.
Site is optimized for mobile devices.
Downloads: 453 / . Delta: 0.01872 с