1.

List of all important MySQLi function

Answer»

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



Discussion

No Comment Found