Copyright 1997-2008 the PHP Documentation Group.
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-commiting 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. Available only with mysqlnd. |
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. Available only with mysqlnd. |
mysqli->get_cache_stats |
mysqli_get_cache_stats |
N/A | Returns client Zval cache statistics. Available only with mysqlnd. |
mysqli->get_server_info |
mysqli_get_server_info |
N/A | NOT DOCUMENTED |
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 a 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 a SQL statement, taking into account the current charset of the connection |
mysqli->real_query |
mysqli_real_query |
N/A | Execute an SQL query |
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 | NOT DOCUMENTED Available only with mysqlnd. |
mysqli_stmt->get_warnings |
mysqli_stmt_get_warnings |
N/A | NOT DOCUMENTED |
$mysqli_stmt->more_results() | mysqli_stmt_more_results() | N/A | NOT DOCUMENTED Available only with mysqlnd. |
$mysqli_stmt->next_result() | mysqli_stmt_next_result() | N/A | NOT DOCUMENTED Available only with mysqlnd. |
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 a 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 arbitary 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. Available only with mysqlnd. |
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 |
Alias functions are provided for backward compatibility purposes only. Do not use them in new projects.
User Comments
Add your own comment.