PHP: Hypertext Preprocessor (original) (raw)

Properties

$mysqli::affected_rows

mysqli_affected_rows()

N/A

Gets the number of affected rows in a previous MySQL operation

$mysqli::client_info

mysqli_get_client_info()

N/A

Returns the MySQL client version as a string

$mysqli::client_version

mysqli_get_client_version()

N/A

Returns MySQL client version info as an integer

$mysqli::connect_errno

mysqli_connect_errno()

N/A

Returns the error code from last connect call

$mysqli::connect_error

mysqli_connect_error()

N/A

Returns a string description of the last connect error

$mysqli::errno

mysqli_errno()

N/A

Returns the error code for the most recent function call

$mysqli::error

mysqli_error()

N/A

Returns a string description of the last error

$mysqli::field_count

mysqli_field_count()

N/A

Returns the number of columns for the most recent query

$mysqli::host_info

mysqli_get_host_info()

N/A

Returns a string representing the type of connection used

$mysqli::protocol_version

mysqli_get_proto_info()

N/A

Returns the version of the MySQL protocol used

$mysqli::server_info

mysqli_get_server_info()

N/A

Returns the version of the MySQL server

$mysqli::server_version

mysqli_get_server_version()

N/A

Returns the version of the MySQL server as an integer

$mysqli::info

mysqli_info()

N/A

Retrieves information about the most recently executed query

$mysqli::insert_id

mysqli_insert_id()

N/A

Returns the auto generated id used in the last query

$mysqli::sqlstate

mysqli_sqlstate()

N/A

Returns the SQLSTATE error from previous MySQL operation

$mysqli::warning_count

mysqli_warning_count()

N/A

Returns the number of warnings from the last query for the given link

Methods

mysqli::autocommit()

mysqli_autocommit()

N/A

Turns on or off auto-committing database modifications

mysqli::change_user()

mysqli_change_user()

N/A

Changes the user of the specified database connection

mysqli::character_set_name()

mysqli_character_set_name()

N/A

Returns the default character set for the database connection

mysqli::close()

mysqli_close()

N/A

Closes a previously opened database connection

mysqli::commit()

mysqli_commit()

N/A

Commits the current transaction

mysqli::__construct()

mysqli_connect()

N/A

Open a new connection to the MySQL server [Note: static (i.e. class) method]

mysqli::debug()

mysqli_debug()

N/A

Performs debugging operations

mysqli::dump_debug_info()

mysqli_dump_debug_info()

N/A

Dump debugging information into the log

mysqli::get_charset()

mysqli_get_charset()

N/A

Returns a character set object

mysqli::get_connection_stats()

mysqli_get_connection_stats()

N/A

Returns client connection statistics. Available only with mysqlnd.

mysqli::get_client_info()

mysqli_get_client_info()

N/A

Returns the MySQL client version as a string

N/A

mysqli_get_client_stats()

N/A

Returns client per-process statistics. Available only with mysqlnd.

mysqli::get_server_info()

mysqli_get_server_info()

N/A

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

mysqli::get_warnings()

mysqli_get_warnings()

N/A

NOT DOCUMENTED

mysqli::init()

mysqli_init()

N/A

Initializes MySQLi and returns an object for use with mysqli_real_connect.

mysqli::kill()

mysqli_kill()

N/A

Asks the server to kill a MySQL thread

mysqli::more_results()

mysqli_more_results()

N/A

Check if there are any more query results from a multi query

mysqli::multi_query()

mysqli_multi_query()

N/A

Performs a query on the database

mysqli::next_result()

mysqli_next_result()

N/A

Prepare next result from multi_query

mysqli::options()

mysqli_options()

mysqli_set_opt()

Set options

mysqli::ping()

mysqli_ping()

N/A

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

mysqli::prepare()

mysqli_prepare()

N/A

Prepare an SQL statement for execution

mysqli::query()

mysqli_query()

N/A

Performs a query on the database

mysqli::real_connect()

mysqli_real_connect()

N/A

Opens a connection to a mysql server

mysqli::real_escape_string(),mysqli::escape_string()

mysqli_real_escape_string()

mysqli_escape_string()

Escapes special characters in a string for use in an SQL statement, taking into account the current charset of the connection

mysqli::real_query()

mysqli_real_query()

N/A

Execute an SQL query

mysqli::refresh()

mysqli_refresh()

N/A

Flushes tables or caches, or resets the replication server information

mysqli::rollback()

mysqli_rollback()

N/A

Rolls back current transaction

mysqli::select_db()

mysqli_select_db()

N/A

Selects the default database for database queries

mysqli::set_charset()

mysqli_set_charset()

N/A

Sets the default client character set

mysqli::ssl_set()

mysqli_ssl_set()

N/A

Used for establishing secure connections using SSL

mysqli::stat()

mysqli_stat()

N/A

Gets the current system status

mysqli::stmt_init()

mysqli_stmt_init()

N/A

Initializes a statement and returns an object for use with mysqli_stmt_prepare

mysqli::store_result()

mysqli_store_result()

N/A

Transfers a result set from the last query

mysqli::thread_id()

mysqli_thread_id()

N/A

Returns the thread ID for the current connection

mysqli::thread_safe()

mysqli_thread_safe()

N/A

Returns whether thread safety is given or not

mysqli::use_result()

mysqli_use_result()

N/A

Initiate a result set retrieval