PHP MYSQLi Functions

Function

Description

mysqli_affected_rows()

Returns the number of affected rows in the previous MySQL operation

mysqli_autocommit()

Turns on or off auto-committing 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 the last connection error

mysqli_connect_error()

Returns the error description from the last connection error

mysqli_connect()

Opens a new connection to the MySQL server

mysqli_data_seek()

Adjusts the result pointer to an arbitrary row in the result-set

mysqli_debug()

Performs debugging operations

mysqli_dump_debug_info()

Dumps debugging info into the log

mysqli_errno()

Returns the last error code for the most recent function call

mysqli_error_list()

Returns a list of errors for the most recent function call

mysqli_error()

Returns the last error description for the most recent function call

mysqli_fetch_all()

Fetches all result rows as an associative array, a numeric array, or both

mysqli_fetch_array()

Fetches a result row as an associative, a numeric array, or both

mysqli_fetch_assoc()

Fetches a result row as an associative array

mysqli_fetch_field_direct()

Returns meta-data for a single field in the result set, as an object

mysqli_fetch_field()

Returns the next field in the result set, as an object

mysqli_fetch_fields()

Returns an array of objects that represent 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()

Fetches one row from a result-set and returns it as an enumerated array

mysqli_field_count()

Returns the number of columns for the most recent query

mysqli_field_seek()

Sets the field cursor to the given field offset

mysqli_field_tell()

Returns the position of the field cursor

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 library version

mysqli_get_client_stats()

Returns statistics about client per-process

mysqli_get_client_version()

Returns the MySQL client library version as an integer

mysqli_get_connection_stats()

Returns statistics about the client connection

mysqli_get_host_info()

Returns the MySQL server hostname and the connection type

mysqli_get_proto_info()

Returns the MySQL protocol version

mysqli_get_server_info()

Returns the MySQL server version

mysqli_get_server_version()

Returns the MySQL server version as an integer

mysqli_info()

Returns 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()

Checks if there are more results from a multi query

mysqli_multi_query()

Performs one or more queries on the database

mysqli_next_result()

Prepares the next result set from mysqli_multi_query()

mysqli_num_fields()

Returns the number of fields in a result set

mysqli_num_rows()

Returns the number of rows in a result set

mysqli_options()

Sets extra connect options and affect behavior for a connection

mysqli_ping()

Pings a server connection, or tries to reconnect if the connection has gone down

mysqli_prepare()

Prepares an SQL statement for execution

mysqli_query()

Performs a query against the database

mysqli_real_connect()

Opens a new connection to the MySQL server

mysqli_real_escape_string()

Escapes special characters in a string for use in an SQL statement

mysqli_real_query()

Executes an SQL query

mysqli_reap_async_query()

Returns the result from async query

mysqli_refresh()

Refreshes tables or caches, or resets the replication server information

mysqli_rollback()

Rolls back the current transaction for the database

mysqli_select_db()

Changes the default database for the connection

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 code for the last MySQL operation

mysqli_ssl_set()

Used to establish secure connections using SSL

mysqli_stat()

Returns 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 the client library is compiled as thread-safe

mysqli_use_result()

Initiates the retrieval of a result set from the last query executed using the mysqli_real_query()

mysqli_warning_count()

Returns the number of warnings from the last query in the connection

Share Share on Facebook Share on Twitter Share on Google+ Share on LinkedIn Pin on Pinterest Share on Stumbleupon Share on Tumblr Share on Reddit Share on Diggit