The MySQLi Extension Function Summary
| 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::client_encoding | mysqli_character_set_name() | mysqli_client_encoding() | 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. Nur in mysqlnd verfügbar. |
| mysqli::get_client_info() | mysqli_get_client_info() | N/A | Returns the MySQL client version as a string |
| mysqli::get_client_stats() | mysqli_get_client_stats() | N/A | Returns client per-process statistics. Nur in mysqlnd verfügbar. |
| mysqli::get_cache_stats() | mysqli_get_cache_stats() | N/A | Returns client Zval cache statistics. Nur in mysqlnd verfügbar. |
| 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 a resource for use with mysqli_real_connect. [Not called on an object, as it returns a $mysqli object.] |
| 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::set_local_infile_default() | mysqli_set_local_infile_default() | N/A | Unsets user defined handler for load local infile command |
| mysqli::set_local_infile_handler() | mysqli_set_local_infile_handler() | N/A | Set callback function for LOAD DATA LOCAL INFILE command |
| 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 |
| 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 |
| $mysqli_stmt::errno | mysqli_stmt_errno() | N/A | Returns the error code for the most recent statement call |
| $mysqli_stmt::error | mysqli_stmt_error() | N/A | Returns a string description for last statement error |
| $mysqli_stmt::field_count | mysqli_stmt_field_count() | N/A | Returns the number of field in the given statement - not documented |
| $mysqli_stmt::insert_id | mysqli_stmt_insert_id() | N/A | Get the ID generated from the previous INSERT operation |
| $mysqli_stmt::num_rows | mysqli_stmt_num_rows() | N/A | Return the number of rows in statements result set |
| $mysqli_stmt::param_count | mysqli_stmt_param_count() | mysqli_param_count() | Returns the number of parameter for the given statement |
| $mysqli_stmt::sqlstate | mysqli_stmt_sqlstate() | N/A | Returns SQLSTATE error from previous statement operation |
| Methods | |||
| mysqli_stmt::attr_get() | mysqli_stmt_attr_get() | N/A | Used to get the current value of a statement attribute |
| mysqli_stmt::attr_set() | mysqli_stmt_attr_set() | N/A | Used to modify the behavior of a prepared statement |
| mysqli_stmt::bind_param() | mysqli_stmt_bind_param() | mysqli_bind_param() | Binds variables to a prepared statement as parameters |
| mysqli_stmt::bind_result() | mysqli_stmt_bind_result() | mysqli_bind_result() | Binds variables to a prepared statement for result storage |
| mysqli_stmt::close() | mysqli_stmt_close() | N/A | Closes a prepared statement |
| mysqli_stmt::data_seek() | mysqli_stmt_data_seek() | N/A | Seeks to an arbitrary row in statement result set |
| mysqli_stmt::execute() | mysqli_stmt_execute() | mysqli_execute() | Executes a prepared Query |
| mysqli_stmt::fetch() | mysqli_stmt_fetch() | mysqli_fetch() | Fetch results from a prepared statement into the bound variables |
| mysqli_stmt::free_result() | mysqli_stmt_free_result() | N/A | Frees stored result memory for the given statement handle |
| mysqli_stmt::get_result() | mysqli_stmt_get_result() | N/A | Gets a result set from a prepared statement. Nur in mysqlnd verfügbar. |
| mysqli_stmt::get_warnings() | mysqli_stmt_get_warnings() | N/A | NOT DOCUMENTED |
| mysqli_stmt::more_results() | mysqli_stmt_more_results() | N/A | Checks if there are more query results from a multiple query |
| mysqli_stmt::next_result() | mysqli_stmt_next_result() | N/A | Reads the next result from a multiple query |
| mysqli_stmt::num_rows() | mysqli_stmt_num_rows() | N/A | See also property $mysqli_stmt::num_rows |
| mysqli_stmt::prepare() | mysqli_stmt_prepare() | N/A | Prepare an SQL statement for execution |
| mysqli_stmt::reset() | mysqli_stmt_reset() | N/A | Resets a prepared statement |
| mysqli_stmt::result_metadata() | mysqli_stmt_result_metadata() | mysqli_get_metadata() | Returns result set metadata from a prepared statement |
| mysqli_stmt::send_long_data() | mysqli_stmt_send_long_data() | mysqli_send_long_data() | Send data in blocks |
| mysqli_stmt::store_result() | mysqli_stmt_store_result() | N/A | Transfers a result set from a prepared statement |
| mysqli_result | |||
|---|---|---|---|
| OOP Interface | Procedural Interface | Alias (Do not use) | Description |
| Properties | |||
| $mysqli_result::current_field | mysqli_field_tell() | N/A | Get current field offset of a result pointer |
| $mysqli_result::field_count | mysqli_num_fields() | N/A | Get the number of fields in a result |
| $mysqli_result::lengths | mysqli_fetch_lengths() | N/A | Returns the lengths of the columns of the current row in the result set |
| $mysqli_result::num_rows | mysqli_num_rows() | N/A | Gets the number of rows in a result |
| Methods | |||
| mysqli_result::data_seek() | mysqli_data_seek() | N/A | Adjusts the result pointer to an arbitrary row in the result |
| mysqli_result::fetch_all() | mysqli_fetch_all() | N/A | Fetches all result rows and returns the result set as an associative array, a numeric array, or both. Nur in mysqlnd verfügbar. |
| mysqli_result::fetch_array() | mysqli_fetch_array() | N/A | Fetch a result row as an associative, a numeric array, or both |
| mysqli_result::fetch_assoc() | mysqli_fetch_assoc() | N/A | Fetch a result row as an associative array |
| mysqli_result::fetch_field_direct() | mysqli_fetch_field_direct() | N/A | Fetch meta-data for a single field |
| mysqli_result::fetch_field() | mysqli_fetch_field() | N/A | Returns the next field in the result set |
| mysqli_result::fetch_fields() | mysqli_fetch_fields() | N/A | Returns an array of objects representing the fields in a result set |
| mysqli_result::fetch_object() | mysqli_fetch_object() | N/A | Returns the current row of a result set as an object |
| mysqli_result::fetch_row() | mysqli_fetch_row() | N/A | Get a result row as an enumerated array |
| mysqli_result::field_seek() | mysqli_field_seek() | N/A | Set result pointer to a specified field offset |
| mysqli_result::free(), mysqli_result::close, mysqli_result::free_result | mysqli_free_result() | N/A | Frees the memory associated with a result |
| MySQL_Driver | |||
|---|---|---|---|
| OOP Interface | Procedural Interface | Alias (Do not use) | Description |
| Properties | |||
| N/A | |||
| Methods | |||
| mysqli_driver::embedded_server_end() | mysqli_embedded_server_end() | N/A | NOT DOCUMENTED |
| mysqli_driver::embedded_server_start() | mysqli_embedded_server_start() | N/A | NOT DOCUMENTED |
Hinweis:
Alias functions are provided for backward compatibility purposes only. Do not use them in new projects.
Deutsche Übersetzung
Sie haben gebeten, diese Seite auf Deutsch zu besuchen. Momentan ist nur die Oberfläche übersetzt, aber noch nicht der gesamte Inhalt.Wenn Sie mir bei Übersetzungen helfen wollen, ist Ihr Beitrag willkommen. Alles, was Sie tun müssen, ist, sich auf der Website zu registrieren und mir eine Nachricht zu schicken, in der Sie gebeten werden, Sie der Gruppe der Übersetzer hinzuzufügen, die Ihnen die Möglichkeit gibt, die gewünschten Seiten zu übersetzen. Ein Link am Ende jeder übersetzten Seite zeigt an, dass Sie der Übersetzer sind und einen Link zu Ihrem Profil haben.
Vielen Dank im Voraus.
Dokument erstellt 30/01/2003, zuletzt geändert 26/10/2018
Quelle des gedruckten Dokuments:https://www.gaudry.be/de/php-rf-mysqli.summary.html
Die Infobro ist eine persönliche Seite, deren Inhalt in meiner alleinigen Verantwortung liegt. Der Text ist unter der CreativeCommons-Lizenz (BY-NC-SA) verfügbar. Weitere Informationen auf die Nutzungsbedingungen und dem Autor.
Referenzen
Diese Verweise und Links verweisen auf Dokumente, die während des Schreibens dieser Seite konsultiert wurden, oder die zusätzliche Informationen liefern können, aber die Autoren dieser Quellen können nicht für den Inhalt dieser Seite verantwortlich gemacht werden.
Der Autor Diese Website ist allein dafür verantwortlich, wie die verschiedenen Konzepte und Freiheiten, die mit den Nachschlagewerken gemacht werden, hier dargestellt werden. Denken Sie daran, dass Sie mehrere Quellinformationen austauschen müssen, um das Risiko von Fehlern zu reduzieren.
