MySQL and PHP
mysqli::$affected_rows,
mysqli_affected_rowsmysqli::autocommit,
mysqli_autocommitmysqli::begin_transaction,
mysqli_begin_transactionmysqli::change_user,
mysqli_change_usermysqli::character_set_name,
mysqli_character_set_namemysqli::close, mysqli_closemysqli::commit, mysqli_commitmysqli::$connect_errno,
mysqli_connect_errnomysqli::$connect_error,
mysqli_connect_errormysqli::__construct,
mysqli::connect,
mysqli_connectmysqli::debug, mysqli_debugmysqli::dump_debug_info,
mysqli_dump_debug_infomysqli::$errno, mysqli_errnomysqli::$error_list,
mysqli_error_listmysqli::$error, mysqli_errormysqli::$field_count,
mysqli_field_countmysqli::get_charset,
mysqli_get_charsetmysqli::$client_info,
mysqli::get_client_info,
mysqli_get_client_infomysqli::$client_version,
mysqli_get_client_versionmysqli::get_connection_stats,
mysqli_get_connection_statsmysqli::$host_info,
mysqli_get_host_infomysqli::$protocol_version,
mysqli_get_proto_infomysqli::$server_info,
mysqli::get_server_info,
mysqli_get_server_infomysqli::$server_version,
mysqli_get_server_versionmysqli::get_warnings,
mysqli_get_warningsmysqli::$info, mysqli_infomysqli::init, mysqli_initmysqli::$insert_id,
mysqli_insert_idmysqli::kill, mysqli_killmysqli::more_results,
mysqli_more_resultsmysqli::multi_query,
mysqli_multi_querymysqli::next_result,
mysqli_next_resultmysqli::options, mysqli_optionsmysqli::ping, mysqli_pingmysqli::poll, mysqli_pollmysqli::prepare, mysqli_preparemysqli::query, mysqli_querymysqli::real_connect,
mysqli_real_connectmysqli::real_escape_string,
mysqli::escape_string,
mysqli_real_escape_stringmysqli::real_query,
mysqli_real_querymysqli::reap_async_query,
mysqli_reap_async_querymysqli::refresh, mysqli_refreshmysqli::release_savepoint,
mysqli_release_savepointmysqli::rollback, mysqli_rollbackmysqli::savepoint,
mysqli_savepointmysqli::select_db,
mysqli_select_dbmysqli::set_charset,
mysqli_set_charsetmysqli::$sqlstate, mysqli_sqlstatemysqli::ssl_set, mysqli_ssl_setmysqli::stat, mysqli_statmysqli::stmt_init,
mysqli_stmt_initmysqli::store_result,
mysqli_store_resultmysqli::$thread_id,
mysqli_thread_idmysqli::thread_safe,
mysqli_thread_safemysqli::use_result,
mysqli_use_resultmysqli::$warning_count,
mysqli_warning_countmysqli_stmt::$affected_rows,
mysqli_stmt_affected_rowsmysqli_stmt::attr_get,
mysqli_stmt_attr_getmysqli_stmt::attr_set,
mysqli_stmt_attr_setmysqli_stmt::bind_param,
mysqli_stmt_bind_parammysqli_stmt::bind_result,
mysqli_stmt_bind_resultmysqli_stmt::close,
mysqli_stmt_closemysqli_stmt::__constructmysqli_stmt::data_seek,
mysqli_stmt_data_seekmysqli_stmt::$errno,
mysqli_stmt_errnomysqli_stmt::$error_list,
mysqli_stmt_error_listmysqli_stmt::$error,
mysqli_stmt_errormysqli_stmt::execute,
mysqli_stmt_executemysqli_stmt::fetch,
mysqli_stmt_fetchmysqli_stmt::$field_count,
mysqli_stmt_field_countmysqli_stmt::free_result,
mysqli_stmt_free_resultmysqli_stmt::get_result,
mysqli_stmt_get_resultmysqli_stmt::get_warnings,
mysqli_stmt_get_warningsmysqli_stmt::$insert_id,
mysqli_stmt_insert_idmysqli_stmt::more_results,
mysqli_stmt_more_resultsmysqli_stmt::next_result,
mysqli_stmt_next_resultmysqli_stmt::$num_rows,
mysqli_stmt::num_rows,
mysqli_stmt_num_rowsmysqli_stmt::$param_count,
mysqli_stmt_param_countmysqli_stmt::prepare,
mysqli_stmt_preparemysqli_stmt::reset,
mysqli_stmt_resetmysqli_stmt::result_metadata,
mysqli_stmt_result_metadatamysqli_stmt::send_long_data,
mysqli_stmt_send_long_datamysqli_stmt::$sqlstate,
mysqli_stmt_sqlstatemysqli_stmt::store_result,
mysqli_stmt_store_resultmysqli_result::$current_field,
mysqli_field_tellmysqli_result::data_seek,
mysqli_data_seekmysqli_result::fetch_all,
mysqli_fetch_allmysqli_result::fetch_array,
mysqli_fetch_arraymysqli_result::fetch_assoc,
mysqli_fetch_assocmysqli_result::fetch_field_direct,
mysqli_fetch_field_directmysqli_result::fetch_field,
mysqli_fetch_fieldmysqli_result::fetch_fields,
mysqli_fetch_fieldsmysqli_result::fetch_object,
mysqli_fetch_objectmysqli_result::fetch_row,
mysqli_fetch_rowmysqli_result::$field_count,
mysqli_num_fieldsmysqli_result::field_seek,
mysqli_field_seekmysqli_result::free,
mysqli_result::close,
mysqli_result::free_result,
mysqli_free_resultmysqli_result::$lengths,
mysqli_fetch_lengthsmysqli_result::$num_rows,
mysqli_num_rowsCopyright 1997-2021 the PHP Documentation Group.
The mysqli extension allows you to access the
functionality provided by MySQL 4.1 and above. More information
about the MySQL Database server can be found at
http://www.mysql.com/
An overview of software available for using MySQL from PHP can be found at Section 3.1, “Overview”
Documentation for MySQL can be found at http://dev.mysql.com/doc/.
Parts of this documentation included from MySQL manual with permissions of Oracle Corporation.
Examples use either the world or sakila database, which are freely available.