PHPのお勉強!

PHP TOP

The MySQLi Extension Function Summary

Summary of mysqli methods
mysqli Class
OOP Interface Procedural Interface Alias (Do not use) Description
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. 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. 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
Summary of mysqli_stmt methods
MySQL_STMT
OOP Interface Procedural Interface Alias (Do not use) Description
Properties
$mysqli_stmt::affected_rows mysqli_stmt_affected_rows() N/A Returns the total number of rows changed, deleted, or inserted by the last executed statement