Predefined Constants
mysqli->affected_rows
mysqli
PHP Manual

# The MySQLi class

## Introduction

Represents a connection between PHP and a MySQL database.

## Class synopsis

MySQLi
class MySQLi {
/* Properties */
int$affected_rows;
string$connect_errno;
string$connect_error;
int$errno;
string$error;
int$field_count;
string$host_info;
string$protocol_version;
string$server_info;
int$server_version;
string$info;
int$insert_id;
string$sqlstate;
int$thread_id;
int$warning_count;
/* Methods */
int mysqli_affected_rows ( mysqli `$link` )
bool mysqli::autocommit ( bool `$mode` )
bool mysqli::change_user ( string `$user` , string `$password` , string `$database` )
string mysqli::character_set_name ( void )
bool mysqli::close ( void )
bool mysqli::commit ( void )
int mysqli_connect_errno ( void )
string mysqli_connect_error ( void )
mysqli mysqli_connect ([ string `$host` [, string `$username` [, string `$passwd` [, string `$dbname` [, int `$port` [, string `$socket` ]]]]]] )
bool mysqli::debug ( string `$message` )
bool mysqli::dump_debug_info ( void )
int mysqli_errno ( mysqli `$link` )
string mysqli_error ( mysqli `$link` )
int mysqli_field_count ( mysqli `$link` )
object mysqli::get_charset ( void )
string mysqli::get_client_info ( void )
int mysqli::get_client_version ( void )
string mysqli_get_host_info ( mysqli `$link` )
int mysqli_get_proto_info ( mysqli `$link` )
string mysqli_get_server_info ( mysqli `$link` )
int mysqli_get_server_version ( mysqli `$link` )
object mysqli::get_warnings ( void )
string mysqli_info ( mysqli `$link` )
mysqli init ( void )
int mysqli_insert_id ( mysqli `$link` )
bool mysqli::kill ( int `$processid` )
bool mysqli::more_results ( void )
bool mysqli::multi_query ( string `$query` )
bool mysqli::next_result ( void )
bool mysqli::options ( int `$option` , mixed `$value` )
bool mysqli::ping ( void )
mysqli_stmt prepare ( string `$query` )
mixed mysqli::query ( string `$query` [, int `$resultmode` ] )
bool mysqli::real_connect ([ string `$host` [, string `$username` [, string `$passwd` [, string `$dbname` [, int `$port` [, string `$socket` [, int `$flags` ]]]]]]] )
string mysqli::escape_string ( string `$escapestr` )
bool real_query ( string `$query` )
bool mysqli::rollback ( void )
bool mysqli::select_db ( string `$dbname` )
bool mysqli::set_charset ( string `$charset` )
void mysqli_set_local_infile_default ( mysqli `$link` )
bool mysqli_set_local_infile_handler ( mysqli `$link` , callback `$read_func` )
string mysqli_sqlstate ( mysqli `$link` )
bool mysqli::ssl_set ( string `$key` , string `$cert` , string `$ca` , string `$capath` , string `$cipher` )
string mysqli::stat ( void )
mysqli_stmt stmt_init ( void )
mysqli_result store_result ( void )
int mysqli_thread_id ( mysqli `$link` )
bool mysqli_thread_safe ( void )
mysqli_result use_result ( void )
int mysqli_warning_count ( mysqli `$link` )
}

## Table of Contents

- mysqli->affected_rows — Gets the number of affected rows in a previous MySQL operation
- mysqli::autocommit — Turns on or off auto-commiting database modifications
- mysqli::change_user — Changes the user of the specified database connection
- mysqli::character_set_name — Returns the default character set for the database connection
- mysqli::close — Closes a previously opened database connection
- mysqli::commit — Commits the current transaction
- mysqli->connect_errno — Returns the error code from last connect call
- mysqli->connect_error — Returns a string description of the last connect error
- mysqli::__construct — Open a new connection to the MySQL server
- mysqli::debug — Performs debugging operations
- mysqli::dump_debug_info — Dump debugging information into the log
- mysqli->errno — Returns the error code for the most recent function call
- mysqli->error — Returns a string description of the last error
- mysqli->field_count — Returns the number of columns for the most recent query
- mysqli::get_charset — Returns a character set object
- mysqli::get_client_info — Returns the MySQL client version as a string
- mysqli::get_client_version — Get MySQL client info
- mysqli->host_info — Returns a string representing the type of connection used
- mysqli->protocol_version — Returns the version of the MySQL protocol used
- mysqli->server_info — Returns the version of the MySQL server
- mysqli->server_version — Returns the version of the MySQL server as an integer
- mysqli::get_warnings — Description
- mysqli->info — Retrieves information about the most recently executed query
- mysqli::init — Initializes MySQLi and returns a resource for use with mysqli_real_connect()
- mysqli->insert_id — Returns the auto generated id used in the last query
- mysqli::kill — Asks the server to kill a MySQL thread
- mysqli::more_results — Check if there are any more query results from a multi query
- mysqli::multi_query — Performs a query on the database
- mysqli::next_result — Prepare next result from multi_query
- mysqli::options — Set options
- mysqli::ping — Pings a server connection, or tries to reconnect if the connection has gone down
- mysqli::prepare — Prepare a SQL statement for execution
- mysqli::query — Performs a query on the database
- mysqli::real_connect — Opens a connection to a mysql server
- mysqli::real_escape_string — Escapes special characters in a string for use in a SQL statement, taking into account the current charset of the connection
- mysqli::real_query — Execute an SQL query
- mysqli::rollback — Rolls back current transaction
- mysqli::select_db — Selects the default database for database queries
- mysqli::set_charset — Sets the default client character set
- mysqli::set_local_infile_default — Unsets user defined handler for load local infile command
- mysqli::set_local_infile_handler — Set callback function for LOAD DATA LOCAL INFILE command
- mysqli->sqlstate — Returns the SQLSTATE error from previous MySQL operation
- mysqli::ssl_set — Used for establishing secure connections using SSL
- mysqli::stat — Gets the current system status
- mysqli::stmt_init — Initializes a statement and returns an object for use with mysqli_stmt_prepare
- mysqli::store_result — Transfers a result set from the last query
- mysqli::thread_id — Returns the thread ID for the current connection
- mysqli::thread_safe — Returns whether thread safety is given or not
- mysqli::use_result — Initiate a result set retrieval
- mysqli::warning_count — Returns the number of warnings from the last query for the given link

Predefined Constants
mysqli->affected_rows
mysqli
PHP Manual