| Below are the list of different MySQLi function and explained some details below
(1)mysqli_affected_rows - It gives the information about no. of affected rows in a previous MySQL operation
(2)mysqli_autocommit - It used to turn on/off auto-committing database operation
(3)mysqli_begin_transaction - Start a transaction
(4)mysqli_change_user - Used for changing the user of the specified database connection
(5)mysqli_character_set_name - Returns default character set for the database connection.
(6)mysqli_client_info - Used to get MySQL client info.
(7)mysqli_client_version - Returns the MySQL client version as a string.
(8)mysqli_close - Closes a previously opened database connection.
(9)mysqli_commit - Commits the current transaction.
(10)mysqli_connect_errno - Returns the error code from last connect call.
(11)mysqli_connect_error - Returns a string description of the last connect error.
(12)mysqli__construct - It used to open a new connection to the MySQL server
(13)mysqli_debug - Used to performs debugging operations
(14)mysqli_dump_debug_info - Used to dump debugging information into the log
(15)mysqli_errno - It will return the error code for the most recent function call
(16)mysqli_error_list - Returns a list of errors from the last command executed
(17)mysqli_error - Returns a string description of the last error
(18)mysqli_field_count - It returns the number of columns for the most recent query
(19)mysqli_get_charset - Returns a character set object
(20)mysqli_get_client_info - Used to get MySQL client info
(21)mysqli_get_client_stats - It returns client per-process statistics
(22)mysqli_get_client_version - Returns the MySQL client version as an integer
(23)mysqli_get_connection_stats - Returns statistics about the client connection
(24)mysqli_host_info - Returns a string representing the type of connection used
(25)mysqli_protocol_version - Returns the version of the MySQL protocol used
(26)mysqli_server_info - Returns the version of the MySQL server
(27)mysqli_server_version - Returns the version of the MySQL server as integer
(28)mysqli_get_warnings - Used for getting result of SHOW WARNINGS
(29)mysqli_info - Retrieves information of most recently executed query
(30)mysqli_insert_id - Returns auto generated id used in the latest query
(31)mysqli_kill - Will ask the server to kill a MySQL thread
(32)mysqli_more_results - Used for checking if there are any more query results from a multi query
(33)mysqli_multi_query - It will perform a query on the database
(34)mysqli_next_result - It prepares next result from multi_query
(35)mysqli_options - Used to set options
(36)mysqli_ping - Used to ping a server
(37)mysqli_poll - Used to poll connections
(38)mysqli_prepare - Prepare an SQL statement for execution.
(39)mysqli_query - Used for performing a query on the database.
(40)mysqli_real_connect - It opens a connection to a mysql server.
(41)mysqli_real_escape_string - It escapes special characters in a string for use in an SQL statement
(42)mysqli_real_query - Used to execute an SQL query.
(43)mysqli_real_async_query - Used to get result from async query
(44)mysqli_refresh - Used to refresh an SQL statement for execution.
(45)mysqli_release_savepoint - Removes the named savepoint from the set of savepoints of the current transaction
(46)mysqli_rollback - It rolls back current transaction
(47)mysqli_rpl_query_type - It will return RPL query type
(48)mysqli_select_db - Used to selects the default database for database queries
(49)mysqli_send_query - Used to send the query and return
(50)mysqli_set_charset - It sets the default client character set
(51)mysqli_set_local_infile_default - Used to unsets user defined handler for load local infile command
(52)mysqli_set_local_infile_handler - Used to set callback function for LOAD DATA LOCAL INFILE command
(53)mysqli_sqlstate - It returns the SQLSTATE error from previous MySQL operation.
(54)mysqli_ssl_set - Used for establishing secure connections using SSL
(55)mysqli_stat - Used to set callback function for LOAD DATA LOCAL INFILE command
(55)mysqli_stmt_init - Used to initialize a statement and returns an object for use with mysqli_stmt_prepare.
(56)mysqli_thread_id - It returns the thread ID for the current connection
(57)mysqli_thread_safe - It returns whether thread safety is given or not.
(58)mysqli_use_result - Used to initiate a result set retrieval
(59)mysqli_warning_count - It will return the number of warnings from the last query for the given link | | |