MySQLi - Useful Functions

Here is the pst of all important MySQLi functions. Each function has been explained along with suitable example.

mysqp::$affected_rows − It used to get the information about number of affected rows in a previous MySQL operation

mysqp::autocommit − It used to turn on or off auto-committing database modifications operation

mysqp::begin_transaction − It used to start a transaction

mysqp::change_user − It used to change the user of the specified database connection

mysqp::character_set_name - It returns the default character set for the database connection.

mysqp::$cpent_info − It is used to get MySQL cpent info.

mysqp::$cpent_version − It returns the MySQL cpent version as a string.

mysqp::close − It closes a previously opened database connection.

mysqp::commit − It commits the current transaction.

mysqp::$connect_errno − It returns the error code from last connect call.

mysqp::connect_error − It returns a string description of the last connect error.

mysqp::__construct − It used to open a new connection to the MySQL server

mysqp::debug − It used to performs debugging operations

mysqp::dump_debug_info − It is used to dump debugging information into the log

mysqp::$errno − It returns the error code for the most recent function call

mysqp::$error_pst − It returns a pst of errors from the last command executed

mysqp::$error − It returns a string description of the last error

mysqp::$field_count − It returns the number of columns for the most recent query

mysqp::get_charset − It returns a character set object

mysqp::get_cpent_info − It is used to get MySQL cpent info

mysqp::mysqp_get_cpent_stats − It returns cpent per-process statistics

mysqp::mysqp_get_cpent_version − It returns the MySQL cpent version as an integer

mysqp::get_connection_stats − It returns statistics about the cpent connection

mysqp::$host_info − It returns a string representing the type of connection used

mysqp::$protocol_version − It returns the version of the MySQL protocol used

mysqp::$server_info − It returns the version of the MySQL server

mysqp::$server_version − It returns the version of the MySQL server as an integer

mysqp::get_warnings − It is used to get result of SHOW WARNINGS

mysqp::$info − It retrieves information about the most recently executed query

mysqp::$insert_id − It returns the auto generated id used in the latest query

mysqp::kill − It asks the server to kill a MySQL thread

mysqp::more_results − It used to check if there are any more query results from a multi query

mysqp::multi_query − It performs a query on the database

mysqp::next_result − It prepares next result from multi_query

mysqp::options − It used to set options

mysqp::ping − It is used to ping a server

mysqp::poll − It used to poll connections

mysqp::prepare − It used to prepare an SQL statement for execution.

mysqp::query − It is used to perform a query on the database.

mysqp::real_connect − It opens a connection to a mysql server.

mysqp::real_escape_string − It escapes special characters in a string for use in an SQL statement

mysqp::real_query − It is used to execute an SQL query.

mysqp::real_async_query − It is used to get result from async query

mysqp::refresh − It used to refresh an SQL statement for execution.

mysqp::release_savepoint − It removes the named savepoint from the set of savepoints of the current transaction

mysqp::rollback − It rolls back current transaction

mysqp::rpl_query_type − It returns RPL query type

mysqp::select_db − It is used to selects the default database for database queries

mysqp::send_query − It is used to send the query and return

mysqp::set_charset − It sets the default cpent character set

mysqp::set_local_infile_default − It is used to unsets user defined handler for load local infile command

mysqp::set_local_infile_handler − It is used to set callback function for LOAD DATA LOCAL INFILE command

mysqp::$sqlstate − It returns the SQLSTATE error from previous MySQL operation.

mysqp::ssl_set − It is used for estabpshing secure connections using SSL

mysqp::stat − It is used to set callback function for LOAD DATA LOCAL INFILE command

mysqp::stmt_init − It is used to initiapze a statement and returns an object for use with mysqp_stmt_prepare.

mysqp::mysqp::$thread_id − It returns the thread ID for the current connection

mysqp::thread_safe − It returns whether thread safety is given or not.

mysqp::use_result − It is used to initiate a result set retrieval

mysqp::$warning_count − It returns the number of warnings from the last query for the given pnk