Mysqli 简明教程

mysqli::$affected_rows − It used to get the information about number of affected rows in a previous MySQL operation

mysqli::autocommit − It used to turn on or off auto-committing database modifications operation

mysqli::begin_transaction − It used to start a transaction

mysqli::change_user − It used to change the user of the specified database connection

mysqli::character_set_name - It returns the default character set for the database connection.

mysqli::$client_info − It is used to get MySQL client info.

mysqli::$client_version − It returns the MySQL client version as a string.

mysqli::close − It closes a previously opened database connection.

mysqli::commit − It commits the current transaction.

mysqli::$connect_errno − It returns the error code from last connect call.

mysqli::connect_error − It returns a string description of the last connect error.

mysqli::__construct − It used to open a new connection to the MySQL server

mysqli::debug − It used to performs debugging operations

mysqli::dump_debug_info − It is used to dump debugging information into the log

mysqli::$errno − It returns the error code for the most recent function call

mysqli::$error_list − It returns a list of errors from the last command executed

mysqli::$error − It returns a string description of the last error

mysqli::$field_count − It returns the number of columns for the most recent query

mysqli::get_charset − It returns a character set object

mysqli::get_client_info − It is used to get MySQL client info

mysqli::mysqli_get_client_stats − It returns client per-process statistics

mysqli::mysqli_get_client_version − It returns the MySQL client version as an integer

mysqli::get_connection_stats − It returns statistics about the client connection

mysqli::$host_info − It returns a string representing the type of connection used

mysqli::$protocol_version − It returns the version of the MySQL protocol used

mysqli::$server_info − It returns the version of the MySQL server

mysqli::$server_version − It returns the version of the MySQL server as an integer

mysqli::get_warnings − It is used to get result of SHOW WARNINGS

mysqli::$info − It retrieves information about the most recently executed query

mysqli::$insert_id − It returns the auto generated id used in the latest query

mysqli::kill − It asks the server to kill a MySQL thread

mysqli::more_results − It used to check if there are any more query results from a multi query

mysqli::multi_query − It performs a query on the database

mysqli::next_result − It prepares next result from multi_query

mysqli::options − It used to set options

mysqli::ping − It is used to ping a server

mysqli::poll − It used to poll connections

mysqli::prepare − It used to prepare an SQL statement for execution.

mysqli::query − It is used to perform a query on the database.

mysqli::real_connect − It opens a connection to a mysql server.

mysqli::real_escape_string − It escapes special characters in a string for use in an SQL statement

mysqli::real_query − It is used to execute an SQL query.

mysqli::real_async_query − It is used to get result from async query

mysqli::refresh − It used to refresh an SQL statement for execution.

mysqli::release_savepoint − It removes the named savepoint from the set of savepoints of the current transaction

mysqli::rollback − It rolls back current transaction

mysqli::rpl_query_type − It returns RPL query type

mysqli::select_db − It is used to selects the default database for database queries

mysqli::send_query − It is used to send the query and return

mysqli::set_charset − It sets the default client character set

mysqli::set_local_infile_default − It is used to unsets user defined handler for load local infile command

mysqli::set_local_infile_handler − It is used to set callback function for LOAD DATA LOCAL INFILE command

mysqli::$sqlstate − It returns the SQLSTATE error from previous MySQL operation.

mysqli::ssl_set − It is used for establishing secure connections using SSL

mysqli::stat − It is used to set callback function for LOAD DATA LOCAL INFILE command

mysqli::stmt_init − It is used to initialize a statement and returns an object for use with mysqli_stmt_prepare.

mysqli::mysqli::$thread_id − It returns the thread ID for the current connection

mysqli::thread_safe − It returns whether thread safety is given or not.

mysqli::use_result − It is used to initiate a result set retrieval

mysqli::$warning_count − It returns the number of warnings from the last query for the given link