PHP MySQLi Introduction
PHP MySQLi = PHP MySQL Improved!
The MySQLi functions allows you to access MySQL database servers.
Note: The MySQLi extension is designed to work with MySQL version 4.1.13 or newer.
Installation / Runtime Configuration
For the MySQLi functions to be available, you must compile PHP with support for the MySQLi extension.
The MySQLi extension was introduced with PHP version 5.0.0. The MySQL Native Driver was included in PHP version 5.3.0.
For installation details, go to: http://php.net/manual/en/mysqli.installation.php
For runtime configuration details, go to: http://php.net/manual/en/mysqli.configuration.php
PHP 5 MySQLi Functions
The mysqli functions are designed to communicate with MySQL 4.1 or later.
Using the mysqli functions you can take advantage of all the latest and advanced features of MySQL, which you may not be able to do with the earlier MySQL functions. However the MySQLi functions are available only with PHP 5 or later.
Function Description mysqli_affected_rows() Returns the number of affected rows in the previous MySQL operation mysqli_autocommit() Turns on or off auto-committing 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 the last connect call mysqli_connect_error() Returns the error description from the last connection error mysqli_connect() Opens a new connection to the MySQL server mysqli_data_seek() Adjusts the result pointer to an arbitrary row in the result-set 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_list() Returns a array of errors for the most recent MySQLi function call mysqli_error() Returns the last error message for the most recent MySQLi function call mysqli_fetch_all() Fetches all result rows as an associative array, a numeric array, or both mysqli_fetch_array() Fetches a result row as an associative, a numeric array, or both mysqli_fetch_assoc() Fetches a result row as an associative array mysqli_fetch_field_direct() Fetch meta-data for a single field as an object mysqli_fetch_field() Returns the next field in the result set, as an object 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() Fetches one row of data from the result set and returns it as an enumerated array mysqli_field_count() Returns the number of columns for the most recent query mysqli_field_seek() Sets the result pointer to a specified field offset mysqli_field_tell() Returns the position of the field cursor used for the last mysqli_fetch_field() call 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_stats() Returns client per-process statistics. mysqli_get_client_version() Returns the MySQL client version as an integer mysqli_get_connection_stats() Returns client connection statistics. mysqli_get_host_info() Returns a string representing the type of connection used including the MySQL server hostname 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_info() Returns information about the last query executed 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 one or multiple queries on the database mysqli_next_result() Prepares the next result set from mysqli_multi_query() mysqli_num_fields() Returns the number of fields in a result set mysqli_num_rows() Returns the number of rows in a result set mysqli_options() Sets extra connect options and affect behavior for a connection mysqli_ping() Pings a server connection, or tries to reconnect if the connection has gone down mysqli_prepare() Prepares an 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 an SQL statement mysqli_real_query() Executes an SQL query mysqli_refresh() Refreshes tables or caches, or resets the replication server information mysqli_rollback() Rollbacks the current transaction for the database 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 code from the previous MySQL operation mysqli_ssl_set() Used to establish secure connections using SSL mysqli_stat() Returns 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 the client library is compiled as thread-safe mysqli_use_result() Initiates the retrieval of a result set from the last query executed using the mysqli_real_query() mysqli_warning_count() Returns the number of warnings from the last query in the connection
| Function | Description |
|---|---|
| mysqli_affected_rows() | Returns the number of affected rows in the previous MySQL operation |
| mysqli_autocommit() | Turns on or off auto-committing 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 the last connect call |
| mysqli_connect_error() | Returns the error description from the last connection error |
| mysqli_connect() | Opens a new connection to the MySQL server |
| mysqli_data_seek() | Adjusts the result pointer to an arbitrary row in the result-set |
| 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_list() | Returns a array of errors for the most recent MySQLi function call |
| mysqli_error() | Returns the last error message for the most recent MySQLi function call |
| mysqli_fetch_all() | Fetches all result rows as an associative array, a numeric array, or both |
| mysqli_fetch_array() | Fetches a result row as an associative, a numeric array, or both |
| mysqli_fetch_assoc() | Fetches a result row as an associative array |
| mysqli_fetch_field_direct() | Fetch meta-data for a single field as an object |
| mysqli_fetch_field() | Returns the next field in the result set, as an object |
| 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() | Fetches one row of data from the result set and returns it as an enumerated array |
| mysqli_field_count() | Returns the number of columns for the most recent query |
| mysqli_field_seek() | Sets the result pointer to a specified field offset |
| mysqli_field_tell() | Returns the position of the field cursor used for the last mysqli_fetch_field() call |
| 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_stats() | Returns client per-process statistics. |
| mysqli_get_client_version() | Returns the MySQL client version as an integer |
| mysqli_get_connection_stats() | Returns client connection statistics. |
| mysqli_get_host_info() | Returns a string representing the type of connection used including the MySQL server hostname |
| 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_info() | Returns information about the last query executed |
| 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 one or multiple queries on the database |
| mysqli_next_result() | Prepares the next result set from mysqli_multi_query() |
| mysqli_num_fields() | Returns the number of fields in a result set |
| mysqli_num_rows() | Returns the number of rows in a result set |
| mysqli_options() | Sets extra connect options and affect behavior for a connection |
| mysqli_ping() | Pings a server connection, or tries to reconnect if the connection has gone down |
| mysqli_prepare() | Prepares an 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 an SQL statement |
| mysqli_real_query() | Executes an SQL query |
| mysqli_refresh() | Refreshes tables or caches, or resets the replication server information |
| mysqli_rollback() | Rollbacks the current transaction for the database |
| 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 code from the previous MySQL operation |
| mysqli_ssl_set() | Used to establish secure connections using SSL |
| mysqli_stat() | Returns 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 the client library is compiled as thread-safe |
| mysqli_use_result() | Initiates the retrieval of a result set from the last query executed using the mysqli_real_query() |
| mysqli_warning_count() | Returns the number of warnings from the last query in the connection |
Posts
![IVRAMANA](https://draft.blogger.com/img/profile_blank_gray.jpg" title="IVRAMANA)
0 comments:
Post a Comment