MySQL Improved Extension

• Introduction
• Overview
• Installing/Configuring
  • Requirements
  • Installation
  • Runtime Configuration
  • Resource Types
• Predefined Constants
• The MySQLi Extension Function Summary
• MySQLi ⬠The MySQLi class
  • mysqli->affected_rows ⬠Gets the number of affected rows in a previous MySQL operation
  • mysqli::autocommit ⬠Turns on or off auto-commiting database modifications
  • mysqli::change_user ⬠Changes the user of the specified database connection
  • mysqli::character_set_name ⬠Returns the default character set for the database connection
  • mysqli::close ⬠Closes a previously opened database connection
  • mysqli::commit ⬠Commits the current transaction
  • mysqli->connect_errno ⬠Returns the error code from last connect call
  • mysqli->connect_error ⬠Returns a string description of the last connect error
  • mysqli::__construct ⬠Open a new connection to the MySQL server
  • mysqli::debug ⬠Performs debugging operations
  • mysqli::dump_debug_info ⬠Dump debugging information into the log
  • mysqli->errno ⬠Returns the error code for the most recent function call
  • mysqli->error ⬠Returns a string description of the last error
  • mysqli->field_count ⬠Returns the number of columns for the most recent query
  • mysqli::get_charset ⬠Returns a character set object
  • mysqli::get_client_info ⬠Returns the MySQL client version as a string
  • mysqli::get_client_version ⬠Get MySQL client info
  • mysqli::get_connection_stats ⬠Returns statistics about the zval cache
  • mysqli->host_info ⬠Returns a string representing the type of connection used
  • mysqli->protocol_version ⬠Returns the version of the MySQL protocol used
  • mysqli->server_info ⬠Returns the version of the MySQL server
  • mysqli->server_version ⬠Returns the version of the MySQL server as an integer
  • mysqli::get_warnings ⬠Description
  • mysqli->info ⬠Retrieves information about the most recently executed query
  • mysqli::init ⬠Initializes MySQLi and returns a resource for use with mysqli_real_connect()
  • mysqli->insert_id ⬠Returns the auto generated id used in the last query
  • mysqli::kill ⬠Asks the server to kill a MySQL thread
  • mysqli::more_results ⬠Check if there are any more query results from a multi query
  • mysq mysqli::reap_async_query — Get result from async query
  • mysqli::rollback — Rolls back current transaction
  • mysqli::select_db — Selects the default database for database queries
  • mysqli::set_charset — Sets the default client character set
  • mysqli::set_local_infile_default — Unsets user defined handler for load local infile command
  • mysqli::set_local_infile_handler — Set callback function for LOAD DATA LOCAL INFILE command
  • mysqli->sqlstate — Returns the SQLSTATE error from previous MySQL operation
  • mysqli::ssl_set — Used for establishing secure connections using SSL
  • mysqli::stat — Gets the current system status
  • mysqli::stmt_init — Initializes a statement and returns an object for use with mysqli_stmt_prepare
  • mysqli::store_result — Transfers a result set from the last query
  • mysqli::thread_id — Returns the thread ID for the current connection
  • mysqli::thread_safe — Returns whether thread safety is given or not
  • mysqli::use_result — Initiate a result set retrieval
  • mysqli::warning_count — Returns the number of warnings from the last query for the given link
• MySQLi_STMT — The MySQLi_STMT class
  • mysqli_stmt->affected_rows — Returns the total number of rows changed, deleted, or inserted by the last executed statement
  • mysqli_stmt::attr_get ⬠Used to get the current value of a statement attribute
  • mysqli_stmt::attr_set ⬠Used to modify the behavior of a prepared statement
  • mysqli_stmt::bind_param ⬠Binds variables to a prepared statement as parameters
  • mysqli_stmt::bind_result ⬠Binds variables to a prepared statement for result storage
  • mysqli_stmt::close ⬠Closes a prepared statement
  • mysqli_stmt::data_seek ⬠Seeks to an arbitrary row in statement result set
  • mysqli_stmt->errno ⬠Returns the error code for the most recent statement call
  • mysqli_stmt->error ⬠Returns a string description for last statement error
  • mysqli_stmt->execute ⬠Executes a prepared Query
  • mysqli_stmt::fetch ⬠Fetch results from a prepared statement into the bound variables
  • mysqli_stmt->field_count ⬠Returns the number of field in the given statement
  • stmt::free_result ⬠Frees stored result memory for the given statement handle
  • mysqli_stmt::get_warnings ⬠Description
  • mysqli_stmt->insert_id ⬠Get the ID generated from the previous INSERT operation
  • mysqli_stmt::num_rows ⬠Return the number of rows in statements result set
  • mysqli_stmt->param_count ⬠Returns the number of parameter for the given statement
  • mysqli_stmt::prepare ⬠Prepare a SQL statement for execution
  • mysqli_stmt::reset ⬠Resets a prepared statement
  • mysqli_stmt::result_metadata ⬠Returns result set metadata from a prepared statement
  • mysqli_stmt::send_long_data ⬠Send data in blocks
  • mysqli_stmt::sqlstate ⬠Returns SQLSTATE error from previous statement operation
  • mysqli_stmt::store_result ⬠Transfers a result set from a prepared statement
• MySQLi_Result ⬠The MySQLi_Result class
  • mysqli_result->current_field ⬠Get current field offset of a result pointer
  • mysqli_result::data_seek ⬠Adjusts the result pointer to an arbitary row in the result
  • mysqli_result::fetch_all ⬠Fetches all result rows as an associative array, a numeric array, or both
  • mysqli_result::fetch_array ⬠Fetch a result row as an associative, a numeric array, or both
  • mysqli_result::fetch_assoc ⬠Fetch a result row as an associative array
  • mysqli_result::fetch_field_direct ⬠Fetch meta-data for a single field
  • mysqli_result::fetch_field ⬠Returns the next field in the result set
  • mysqli_result::fetch_fields ⬠Returns an array of objects representing the fields in a result set
  • mysqli_result::fetch_object ⬠Returns the c server
• Aliases and deprecated Mysqli Functions
  • mysqli_bind_param — Alias for mysqli_stmt_bind_param
  • mysqli_bind_result — Alias for mysqli_stmt_bind_result
  • mysqli_client_encoding — Alias of mysqli_character_set_name
  • mysqli_disable_reads_from_master — Disable reads from master
  • mysqli_disable_rpl_parse — Disable RPL parse
  • mysqli_enable_reads_from_master — Enable reads from master
  • mysqli_enable_rpl_parse — Enable RPL parse
  • mysqli_escape_string — Alias of mysqli_real_escape_string
  • mysqli_execute — Alias for mysqli_stmt_execute
  • mysqli_fetch — Alias for mysqli_stmt_fetch
  • mysqli_get_metadata — Alias for mysqli_stmt_result_metadata
  • mysqli_master_query — Enforce execution of a query on the master in a master/slave setup
  • mysqli_param_count — Alias for mysqli_stmt_param_count
  • mysqli_report — Enables or disables internal report functions
  • mysqli_rpl_parse_enabled — Check if RPL parse is enabled
  • mysqli_rpl_probe — RPL probe
  • mysqli_rpl_query_type — Returns RPL query type
  • mysqli_send_long_data — Alias for mysqli_stmt_send_long_data
  • mysqli_send_query — Send the query and return
  • mysqli_set_opt — Alias of mysqli_options
  • mysqli_slave_query — Force execution of a query on a slave in a master/slave setup