Einführung

Die mysqli-Erweiterung ermöglicht Ihnen den Zugriff auf Funktionalitäten von MySQL 4.1 und höher. Weitere Informationen über den MySQL Datenbankserver finden Sie unter » http://www.mysql.com/

Die Dokumentation von MySQL finden Sie unter » http://dev.mysql.com/doc/

Anforderungen

Um die Funktionalitäten dieser Erweiterung nutzen zu können, müssen Sie PHP mit Unterstützung für mysqli kompilieren.

Anmerkung: Die mysqli-Erweiterung wurde erstellt, um mit den MySQL-Versionen >= 4.1 zu arbeiten. Wenn Sie eine ältere Version verwenden, sollten Sie einen Blick auf die Dokumentation der mysql-Erweiterung werfen.

Installation

Um die mysqli-Erweiterung für PHP zu installieren, benutzen Sie den Schalter --with-mysqli=mysql_config_path/mysql_config, wobei mysql_config_path auf das Verzeichnis des mysql_config-Programms verweist, das bei MySQL-Versionen größer als 4.1 vorhanden ist.

Wenn Sie die Standard-MySQL-Erweiterung zusammen mit der mysqli-Erweiterung installieren möchten, müssen Sie für beide die gleiche Client-Bibliothek verwenden, um Konflikten vorzubeugen.

Laufzeit Konfiguration

Das Verhalten dieser Funktionen wird durch Einstellungen in der php.ini beeinflusst.

Für weitere Details und Definitionen über die oben genannten PHP_INI_*-Konstanten sehen Sie im Kapitel über Konfigurations-Änderungen nach.

Hier eine kurze Erklärung der Konfigurationsoptionen:

Resource Typen

Vordefinierte Konstanten

Inhaltsverzeichnis

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_bind_param — Alias for mysqli_stmt_bind_param()

mysqli_bind_result — Alias for mysqli_stmt_bind_result()

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_client_encoding — Alias of mysqli_character_set_name()

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_connect — Open a new connection to the MySQL server

mysqli_data_seek — Adjusts the result pointer to an arbitary row in the result

mysqli_debug — Performs debugging operations

mysqli_disable_reads_from_master — Disable reads from master

mysqli_disable_rpl_parse — Disable RPL parse

mysqli_dump_debug_info — Dump debugging information into the log

mysqli_embedded_server_end

mysqli_embedded_server_start

mysqli_enable_reads_from_master — Enable reads from master

mysqli_enable_rpl_parse — Enable RPL parse

mysqli_errno — Returns the error code for the most recent function call

mysqli_error — Returns a string description of the last error

mysqli_escape_string — Alias of mysqli_real_escape_string()

mysqli_execute — Alias for mysqli_stmt_execute()

mysqli_fetch_array — Fetch a result row as an associative, a numeric array, or both

mysqli_fetch_assoc — Fetch a result row as an associative array

mysqli_fetch_field_direct — Fetch meta-data for a single field

mysqli_fetch_field — Returns the next field in the result set

mysqli_fetch_fields — Returns an array of objects representing the fields in a result set

mysqli_fetch_lengths — Returns the lengths of the columns of the current row in the result set

mysqli_fetch_object — Returns the current row of a result set as an object

mysqli_fetch_row — Get a result row as an enumerated array

mysqli_fetch — Alias for mysqli_stmt_fetch()

mysqli_field_count — Returns the number of columns for the most recent query

mysqli_field_seek — Set result pointer to a specified field offset

mysqli_field_tell — Get current field offset of a result pointer

mysqli_free_result — Frees the memory associated with a result

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_get_host_info — Returns a string representing the type of connection used

mysqli_get_metadata — Alias for mysqli_stmt_result_metadata()

mysqli_get_proto_info — Returns the version of the MySQL protocol used

mysqli_get_server_info — Returns the version of the MySQL server

mysqli_get_server_version — Returns the version of the MySQL server as an integer

mysqli_get_warnings

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_master_query — Enforce execution of a query on the master in a master/slave setup

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_num_fields — Get the number of fields in a result

mysqli_num_rows — Gets the number of rows in a result

mysqli_options — Set options

mysqli_param_count — Alias for mysqli_stmt_param_count()

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_report — Enables or disables internal report functions

mysqli_rollback — Rolls back current transaction

mysqli_rpl_parse_enabled — Check if RPL parse is enabled

mysqli_rpl_probe — RPL probe

mysqli_rpl_query_type — Returns RPL query type

mysqli_select_db — Selects the default database for database queries

mysqli_send_long_data — Alias for mysqli_stmt_send_long_data()

mysqli_send_query — Send the query and return

mysqli_server_end — Shut down the embedded server

mysqli_server_init — Initialize embedded server

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 functions for LOAD DATA LOCAL INFILE command

mysqli_set_opt — Alias of mysqli_options()

mysqli_slave_query — Force execution of a query on a slave in a master/slave setup

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_affected_rows — Returns the total number of rows changed, deleted, or inserted by the last executed statement

mysqli_stmt_attr_get

mysqli_stmt_attr_set

mysqli_stmt_bind_param — Binds variables to a prepared statement as parameters

mysqli_stmt_bind_result — Binds variables to a prepared statement for result storage

mysqli_stmt_close — Closes a prepared statement

mysqli_stmt_data_seek — Seeks to an arbitray row in statement result set

mysqli_stmt_errno — Returns the error code for the most recent statement call

mysqli_stmt_error — Returns a string description for last statement error

mysqli_stmt_execute — Executes a prepared Query

mysqli_stmt_fetch — Fetch results from a prepared statement into the bound variables

mysqli_stmt_field_count — Returns the number of field in the given statement

mysqli_stmt_free_result — Frees stored result memory for the given statement handle

mysqli_stmt_get_warnings

mysqli_stmt_init — Initializes a statement and returns an object for use with mysqli_stmt_prepare

mysqli_stmt_insert_id — Get the ID generated from the previous INSERT operation

mysqli_stmt_num_rows — Return the number of rows in statements result set

mysqli_stmt_param_count — Returns the number of parameter for the given statement

mysqli_stmt_prepare — Prepare a SQL statement for execution

mysqli_stmt_reset — Resets a prepared statement

mysqli_stmt_result_metadata — Returns result set metadata from a prepared statement

mysqli_stmt_send_long_data — Send data in blocks

mysqli_stmt_sqlstate — Returns SQLSTATE error from previous statement operation

mysqli_stmt_store_result — Transfers a result set from a prepared statement

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