MySQLi
Tässä on erilaisia MySQLi funktiota/ komentoja!
| Funktio | Selite | Esimerkki |
|---|---|---|
| mysqli_affected_rows() | Returns the number of affected rows in the previous MySQL operation | Esim |
| mysqli_autocommit() | Turns on or off auto-committing database modifications | Esim |
| mysqli_change_user() | Changes the user of the specified database connection | Esim |
| mysqli_character_set_name() | Returns the default character set for the database connection | Esim |
| mysqli_close() | Closes a previously opened database connection | Esim |
| mysqli_commit() | Commits the current transaction | Esim |
| mysqli_connect_errno() | Returns the error code from the last connection error | Esim |
| mysqli_connect_error() | Returns the error description from the last connection error | Esim |
| mysqli_connect() | Opens a new connection to the MySQL server | Esim |
| mysqli_data_seek() | Adjusts the result pointer to an arbitrary row in the result-set | Esim |
| mysqli_debug() | Performs debugging operations | Esim |
| mysqli_dump_debug_info() | Dumps debugging info into the log | Esim |
| mysqli_errno() | Returns the last error code for the most recent function call | Esim |
| mysqli_error_list() | Returns a list of errors for the most recent function call | Esim |
| mysqli_error() | Returns the last error description for the most recent function call | Esim |
| mysqli_fetch_all() | Fetches all result rows as an associative array, a numeric array, or both | Esim |
| mysqli_fetch_array() | Fetches a result row as an associative, a numeric array, or both | Esim |
| mysqli_fetch_assoc() | Fetches a result row as an associative array | Esim |
| mysqli_fetch_field_direct() | Returns meta-data for a single field in the result set, as an object | Esim |
| mysqli_fetch_field() | Returns the next field in the result set, as an object | Esim |
| mysqli_fetch_fields() | Returns an array of objects that represent the fields in a result set | Esim |
| mysqli_fetch_lengths() | Returns the lengths of the columns of the current row in the result set | Esim |
| mysqli_fetch_object() | Returns the current row of a result set, as an object | Esim |
| mysqli_fetch_row() | Fetches one row from a result-set and returns it as an enumerated array | Esim |
| mysqli_field_count() | Returns the number of columns for the most recent query | Esim |
| mysqli_field_seek() | Sets the field cursor to the given field offset | Esim |
| mysqli_field_tell() | Returns the position of the field cursor | Esim |
| mysqli_free_result() | Frees the memory associated with a result | Esim |
| mysqli_get_charset() | Returns a character set object | Esim |
| mysqli_get_client_info() | Returns the MySQL client library version | Esim |
| mysqli_get_client_stats() | Returns statistics about client per-process | Esim |
| mysqli_get_client_version() | Returns the MySQL client library version as an integer | Esim |
| mysqli_get_connection_stats() | Returns statistics about the client connection | Esim |
| mysqli_get_host_info() | Returns the MySQL server hostname and the connection type | Esim |
| mysqli_get_proto_info() | Returns the MySQL protocol version | Esim |
| mysqli_get_server_info() | Returns the MySQL server version | Esim |
| mysqli_get_server_version() | Returns the MySQL server version as an integer | Esim |
| mysqli_info() | Returns information about the most recently executed query | Esim |
| mysqli_init() | Initializes MySQLi and returns a resource for use with mysqli_real_connect() | Esim |
| mysqli_insert_id() | Returns the auto-generated id used in the last query | Esim |
| mysqli_kill() | Asks the server to kill a MySQL thread | Esim |
| mysqli_more_results() | Checks if there are more results from a multi query | Esim |
| mysqli_multi_query() | Performs one or more queries on the database | Esim |
| mysqli_next_result() | Prepares the next result set from mysqli_multi_query() | Esim |
| mysqli_num_fields() | Returns the number of fields in a result set | Esim |
| mysqli_num_rows() | Returns the number of rows in a result set | Esim |
| mysqli_options() | Sets extra connect options and affect behavior for a connection | Esim |
| mysqli_ping() | Pings a server connection, or tries to reconnect if the connection has gone down | Esim |
| mysqli_prepare() | Prepares an SQL statement for execution | Esim |
| mysqli_query() | Performs a query against the database | Esim |
| mysqli_real_connect() | Opens a new connection to the MySQL server | Esim |
| mysqli_real_escape_string() | Escapes special characters in a string for use in an SQL statement | Esim |
| mysqli_real_query() | Executes an SQL query | Esim |
| mysqli_reap_async_query() | Returns the result from async query | Esim |
| mysqli_refresh() | Refreshes tables or caches, or resets the replication server information | Esim |
| mysqli_rollback() | Rolls back the current transaction for the database | Esim |
| mysqli_select_db() | Changes the default database for the connection | Esim |
| mysqli_set_charset() | Sets the default client character set | Esim |
| mysqli_set_local_infile_default() | Unsets user defined handler for load local infile command | Esim |
| mysqli_set_local_infile_handler() | Set callback function for LOAD DATA LOCAL INFILE command | Esim |
| mysqli_sqlstate() | Returns the SQLSTATE error code for the last MySQL operation | Esim |
| mysqli_ssl_set() | Used to establish secure connections using SSL | Esim |
| mysqli_stat() | Returns the current system status | Esim |
| mysqli_stmt_init() | Initializes a statement and returns an object for use with mysqli_stmt_prepare() | Esim |
| mysqli_store_result() | Transfers a result set from the last query | Esim |
| mysqli_thread_id() | Returns the thread ID for the current connection | Esim |
| mysqli_thread_safe() | Returns whether the client library is compiled as thread-safe | Esim |
| mysqli_use_result() | Initiates the retrieval of a result set from the last query executed using the mysqli_real_query() | Esim |
| mysqli_warning_count() | Returns the number of warnings from the last query in the connection | Esim |