Mysqli

Front 1

mysqli_affected_rows

Back 1

Returns the number of rows affected by the last INSERT, UPDATE, REPLACE or DELETE query.

Front 2

mysqli_autocommit

Back 2

Turns on or off auto-commit mode on queries for the database connection.

To determine the current state of autocommit use the SQL command SELECT @@autocommit.

Front 3

mysqli_change_user

Back 3

Changes the user of the specified database connection and sets the current database.

In order to successfully change users a valid username and password parameters must be provided and that user must have sufficient permissions to access the desired database. If for any reason authorization fails, the current user authentication will remain.

Front 4

mysqli_character_set_name

Back 4

Returns the current character set for the database connection.

Front 5

mysqli_get_client_info

Back 5

Returns a string that represents the MySQL client library version.

Front 6

mysqli_get_client_version

Back 6

Returns client version number as an integer.

Front 7

mysqli_close

Back 7

Closes a previously opened database connection.

Front 8

mysqli_commit

Back 8

Commits the current transaction for the database connection.

Front 9

mysqli_connect_errno

Back 9

Returns the last error code number from the last call to mysqli_connect().

Front 10

mysqli_connect_error

Back 10

Returns the last error message string from the last call to mysqli_connect().

Front 11

mysqli_connect

Back 11

Opens a connection to the MySQL Server running on.

Front 12

mysqli_debug

Back 12

Performs debugging operations using the Fred Fish debugging library.

Front 13

mysqli_dump_debug_info

Back 13

This function is designed to be executed by an user with the SUPER privilege and is used to dump debugging information into the log for the MySQL Server relating to the connection.

Front 14

mysqli_errno

Back 14

Returns the last error code for the most recent MySQLi function call that can succeed or fail.

Client error message numbers are listed in the MySQL errmsg.h header file, server error message numbers are listed in mysqld_error.h. In the MySQL source distribution you can find a complete list of error messages and error numbers in the file Docs/mysqld_error.txt.

Front 15

mysqli_error

Back 15

Returns the last error message for the most recent MySQLi function call that can succeed or fail.

Front 16

mysqli_field_count

Back 16

Returns the number of columns for the most recent query on the connection represented by the link parameter. This function can be useful when using the mysqli_store_result() function to determine if the query should have produced a non-empty result set or not without knowing the nature of the query.

Front 17

mysqli_get_charset

Back 17

Returns a character set object providing several properties of the current active character set.

Front 18

mysqli_get_client_info

Back 18

Returns a string that represents the MySQL client library version.

Front 19

mysqli_get_client_version

Back 19

Returns client version number as an integer.

Front 20

mysqli_get_host_info

Back 20

Returns a string describing the connection represented by the link parameter (including the server host name).

Front 21

mysqli_get_proto_info

Back 21

Returns an integer representing the MySQL protocol version used by the connection represented by the link parameter.

Front 22

mysqli_get_server_info

Back 22

Returns a string representing the version of the MySQL server that the MySQLi extension is connected to.

Front 23

mysqli_get_server_version

Back 23

The mysqli_get_server_version() function returns the version of the server connected to (represented by the link parameter) as an integer.

Front 24

mysqli_info

Back 24

The mysqli_info() function returns a string providing information about the last query executed. The nature of this string is provided below:

Front 25

mysqli_init

Back 25

Initializes MySQLi and returns a resource for use with mysqli_real_connect()

Front 26

mysqli_insert_id

Back 26

The mysqli_insert_id() function returns the ID generated by a query on a table with a column having the AUTO_INCREMENT attribute. If the last query wasn't an INSERT or UPDATE statement or if the modified table does not have a column with the AUTO_INCREMENT attribute, this function will return zero.

Front 27

mysqli_kill

Back 27

This function is used to ask the server to kill a MySQL thread specified by the processid parameter. This value must be retrieved by calling the mysqli_thread_id() function.

To stop a running query you should use the SQL command KILL QUERY processid.

Front 28

mysqli_more_results

Back 28

Indicates if one or more result sets are available from a previous call to mysqli_multi_query().

Front 29

mysqli_multi_query

Back 29

Executes one or multiple queries which are concatenated by a semicolon.

To retrieve the resultset from the first query you can use mysqli_use_result() or mysqli_store_result(). All subsequent query results can be processed using mysqli_more_results() and mysqli_next_result().

Front 30

mysqli_next_result

Back 30

Prepares next result set from a previous call to mysqli_multi_query() which can be retrieved by mysqli_store_result() or mysqli_use_result().

Front 31

mysqli_options

Back 31

Used to set extra connect options and affect behavior for a connection.

This function may be called multiple times to set several options.

mysqli_options() should be called after mysqli_init() and before mysqli_real_connect().

Front 32

mysqli_ping

Back 32

Checks whether the connection to the server is working. If it has gone down, and global option mysqli.reconnect is enabled an automatic reconnection is attempted.

This function can be used by clients that remain idle for a long while, to check whether the server has closed the connection and reconnect if necessary.

Front 33

mysqli_prepare

Back 33

Prepares the SQL query pointed to by the null-terminated string query, and returns a statement handle to be used for further operations on the statement. The query must consist of a single SQL statement.

The parameter markers must be bound to application variables using mysqli_stmt_bind_param() and/or mysqli_stmt_bind_result() before executing the statement or fetching rows.

Front 34

mysqli_query

Back 34

Performs a query against the database.

Functionally, using this function is identical to calling mysqli_real_query() followed either by mysqli_use_result() or mysqli_store_result().

Front 35

mysqli_real_connect

Back 35

Establish a connection to a MySQL database engine.

This function differs from mysqli_connect():

*mysqli_real_connect() needs a valid object which has to be created by function mysqli_init().

*With the mysqli_options() function you can set various options for connection.

*There is a flags parameter.

Front 36

mysqli_real_escape_string

Back 36

This function is used to create a legal SQL string that you can use in an SQL statement. The given string is encoded to an escaped SQL string, taking into account the current character set of the connection.

Front 37

mysqli_real_query

Back 37

Executes a single query against the database whose result can then be retrieved or stored using the mysqli_store_result() or mysqli_use_result() functions.

In order to determine if a given query should return a result set or not, see mysqli_field_count().

Front 38

mysqli_rollback

Back 38

Rollbacks the current transaction for the database.

Front 39

mysqli_select_db

Back 39

Selects the default database to be used when performing queries against the database connection.

Front 40

mysqli_set_charset

Back 40

Sets the default character set to be used when sending data from and to the database server.

Front 41

mysqli_set_local_infile_default

Back 41

Deactivates a LOAD DATA INFILE LOCAL handler previously set with mysqli_set_local_infile_handler().

Front 42

mysqli_set_local_infile_handler

Back 42

Set callback function for LOAD DATA LOCAL INFILE command

The callbacks task is to read input from the file specified in the LOAD DATA LOCAL INFILE and to reformat it into the format understood by LOAD DATA INFILE.

The returned data needs to match the format specified in the LOAD DATA

Front 43

mysqli_sqlstate

Back 43

Returns a string containing the SQLSTATE error code for the last error. The error code consists of five characters. '00000' means no error. The values are specified by ANSI SQL and ODBC. For a list of possible values, see » http://dev.mysql.com/doc/mysql/en/error-handling.html.

Front 44

mysqli_ssl_set

Back 44

Used for establishing secure connections using SSL. It must be called before mysqli_real_connect(). This function does nothing unless OpenSSL support is enabled.

Note that MySQL Native Driver does not support SSL, so calling this function when using MySQL Native Driver will result in an error. MySQL Native Driver is enabled by default on Microsoft Windows from PHP version 5.3 onwards.

Front 45

mysqli_stat

Back 45

mysqli_stat() returns a string containing information similar to that provided by the 'mysqladmin status' command. This includes uptime in seconds and the number of running threads, questions, reloads, and open tables.

Front 46

mysqli_stmt_init

Back 46

Initializes a statement and returns an object for use with mysqli_stmt_prepare

Note: Any subsequent calls to any mysqli_stmt function will fail until mysqli_stmt_prepare() was called.

Front 47

mysqli_store_result

Back 47

Transfers the result set from the last query on the database connection represented by the link parameter to be used with the mysqli_data_seek() function.

Front 48

mysqli_thread_id

Back 48

The mysqli_thread_id() function returns the thread ID for the current connection which can then be killed using the mysqli_kill() function. If the connection is lost and you reconnect with mysqli_ping(), the thread ID will be other. Therefore you should get the thread ID only when you need it.

Front 49

mysqli_thread_safe

Back 49

Tells whether the client library is compiled as thread-safe.

Front 50

mysqli_use_result

Back 50

Used to initiate the retrieval of a result set from the last query executed using the mysqli_real_query() function on the database connection.

Either this or the mysqli_store_result() function must be called before the results of a query can be retrieved, and one or the other must be called to prevent the next query on that database connection from failing.

Front 51

mysqli_warning_count

Back 51

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