MySQL Improved Extension

Table of Contents

• 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_bind_param — Alias for mysqli_stmt_bind_param
• mysqli_bind_result — Alias for mysqli_stmt_bind_result
• 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_client_encoding — Alias of mysqli_character_set_name
• 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_connect — Open a new connection to the MySQL server
• mysqli_data_seek — Adjusts the result pointer to an arbitary row in the result
• mysqli_debug — Performs debugging operations
• mysqli_disable_reads_from_master — Disable reads from master
• mysqli_disable_rpl_parse — Disable RPL parse
• mysqli_dump_debug_info — Dump debugging information into the log
• mysqli_embedded_server_end — Description
• mysqli_embedded_server_start — Description
• mysqli_enable_reads_from_master — Enable reads from master
• mysqli_enable_rpl_parse — Enable RPL parse
• mysqli_errno — Returns the error code for the most recent function call
• mysqli_error — Returns a string description of the last error
• mysqli_escape_string — Alias of mysqli_real_escape_string
• mysqli_execute — Alias for mysqli_stmt_execute
• mysqli_fetch_array — Fetch a result row as an associative, a numeric array, or both
• mysqli_fetch_assoc — Fetch a result row as an associative array
• mysqli_fetch_field_direct — Fetch meta-data for a single field
• mysqli_fetch_field — Returns the next field in the result set
• mysqli_fetch_fields — Returns an array of objects representing the fields in a result set
• mysqli_fetch_lengths — Returns the lengths of the columns of the current row in the result set
• mysqli_fetch_object — Returns the current row of a result set as an object
• mysqli_fetch_row — Get a result row as an enumerated array
• mysqli_fetch — Alias for mysqli_stmt_fetch
• mysqli_field_count — Returns the number of columns for the most recent query
• mysqli_field_seek — Set result pointer to a specified field offset
• mysqli_field_tell — Get current field offset of a result pointer
• mysqli_free_result — Frees the memory associated with a result
• 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_host_info — Returns a string representing the type of connection used
• mysqli_get_metadata — Alias for mysqli_stmt_result_metadata
• mysqli_get_proto_info — Returns the version of the MySQL protocol used
• mysqli_get_server_info — Returns the version of the MySQL server
• mysqli_get_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_master_query — Enforce execution of a query on the master in a master/slave setup
• mysqli_more_results — Check if there are any more query results from a multi query
• mysqli_multi_query — Performs a query on the database
• mysqli_next_result — Prepare next result from multi_query
• mysqli_num_fields — Get the number of fields in a result
• mysqli_num_rows — Gets the number of rows in a result
• mysqli_options — Set options
• mysqli_param_count — Alias for mysqli_stmt_param_count
• mysqli_ping — Pings a server connection, or tries to reconnect if the connection has gone down
• mysqli_prepare — Prepare a SQL statement for execution
• mysqli_query — Performs a query on the database
• mysqli_real_connect — Opens a connection to a mysql server
• mysqli_real_escape_string — Escapes special characters in a string for use in a SQL statement, taking into account the current charset of the connection
• mysqli_real_query — Execute an SQL query
• mysqli_report — Enables or disables internal report functions
• mysqli_rollback — Rolls back current transaction
• mysqli_rpl_parse_enabled — Check if RPL parse is enabled
• mysqli_rpl_probe — RPL probe
• mysqli_rpl_query_type — Returns RPL query type
• mysqli_select_db — Selects the default database for database queries
• mysqli_send_long_data — Alias for mysqli_stmt_send_long_data
• mysqli_send_query — Send the query and return
• mysqli_server_end — Shut down the embedded server
• mysqli_server_init — Initialize embedded server
• 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 functions for LOAD DATA LOCAL INFILE command
• mysqli_set_opt — Alias of mysqli_options
• mysqli_slave_query — Force execution of a query on a slave in a master/slave setup
• 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_affected_rows — Returns the total number of rows changed, deleted, or inserted by the last executed statement
• mysqli_stmt_attr_get — Description
• mysqli_stmt_attr_set — Description
• 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 arbitray 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
• mysqli_stmt_free_result — Frees stored result memory for the given statement handle
• mysqli_stmt_get_warnings — Description
• mysqli_stmt_init — Initializes a statement and returns an object for use with mysqli_stmt_prepare
• 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_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

New comment

Use [code] and [php] to display codes, SQL queries or php code correctly!