Skip to Main Content
The world's most popular open source database
Contact MySQL
|
Login
|
Register
MySQL.com
Downloads
Documentation
Developer Zone
Developer Zone
Downloads
MySQL.com
Documentation
MySQL Server
MySQL Enterprise
Workbench
InnoDB Cluster
MySQL NDB Cluster
Connectors
More
MySQL.com
Downloads
Developer Zone
Section Menu:
Documentation Home
Connectors and APIs Manual
Preface and Legal Notices
Introduction
MySQL Connector/C++ Developer Guide
MySQL Connector/J Developer Guide
MySQL Connector/NET Developer Guide
MySQL Connector/ODBC Developer Guide
MySQL Connector/Python Developer Guide
MySQL and PHP
Introduction to the MySQL PHP API
Overview of the MySQL PHP drivers
Introduction
Terminology overview
Choosing an API
Choosing a library
Concepts
Buffered and Unbuffered queries
Character sets
MySQL Improved Extension
Overview
Quick start guide
Dual procedural and object-oriented interface
Connections
Executing statements
Prepared Statements
Stored Procedures
Multiple Statements
API support for transactions
Metadata
Installing/Configuring
Requirements
Installation
Runtime Configuration
Resource Types
The mysqli Extension and Persistent Connections
Predefined Constants
Notes
The MySQLi Extension Function Summary
The mysqli class
mysqli::$affected_rows, mysqli_affected_rows
mysqli::autocommit, mysqli_autocommit
mysqli::begin_transaction, mysqli_begin_transaction
mysqli::change_user, mysqli_change_user
mysqli::character_set_name, mysqli_character_set_name
mysqli::close, mysqli_close
mysqli::commit, mysqli_commit
mysqli::$connect_errno, mysqli_connect_errno
mysqli::$connect_error, mysqli_connect_error
mysqli::__construct, mysqli::connect, mysqli_connect
mysqli::debug, mysqli_debug
mysqli::dump_debug_info, mysqli_dump_debug_info
mysqli::$errno, mysqli_errno
mysqli::$error_list, mysqli_error_list
mysqli::$error, mysqli_error
mysqli::$field_count, mysqli_field_count
mysqli::get_charset, mysqli_get_charset
mysqli::$client_info, mysqli::get_client_info, mysqli_get_client_info
mysqli::$client_version, mysqli_get_client_version
mysqli::get_connection_stats, mysqli_get_connection_stats
mysqli::$host_info, mysqli_get_host_info
mysqli::$protocol_version, mysqli_get_proto_info
mysqli::$server_info, mysqli::get_server_info, mysqli_get_server_info
mysqli::$server_version, mysqli_get_server_version
mysqli::get_warnings, mysqli_get_warnings
mysqli::$info, mysqli_info
mysqli::init, mysqli_init
mysqli::$insert_id, mysqli_insert_id
mysqli::kill, mysqli_kill
mysqli::more_results, mysqli_more_results
mysqli::multi_query, mysqli_multi_query
mysqli::next_result, mysqli_next_result
mysqli::options, mysqli_options
mysqli::ping, mysqli_ping
mysqli::poll, mysqli_poll
mysqli::prepare, mysqli_prepare
mysqli::query, mysqli_query
mysqli::real_connect, mysqli_real_connect
mysqli::real_escape_string, mysqli_real_escape_string
mysqli::real_query, mysqli_real_query
mysqli::reap_async_query, mysqli_reap_async_query
mysqli::refresh, mysqli_refresh
mysqli::release_savepoint, mysqli_release_savepoint
mysqli::rollback, mysqli_rollback
mysqli::savepoint, mysqli_savepoint
mysqli::select_db, mysqli_select_db
mysqli::set_charset, mysqli_set_charset
mysqli::$sqlstate, mysqli_sqlstate
mysqli::ssl_set, mysqli_ssl_set
mysqli::stat, mysqli_stat
mysqli::stmt_init, mysqli_stmt_init
mysqli::store_result, mysqli_store_result
mysqli::$thread_id, mysqli_thread_id
mysqli::thread_safe, mysqli_thread_safe
mysqli::use_result, mysqli_use_result
mysqli::$warning_count, mysqli_warning_count
The mysqli_stmt class
mysqli_stmt::$affected_rows, mysqli_stmt_affected_rows
mysqli_stmt::attr_get, mysqli_stmt_attr_get
mysqli_stmt::attr_set, mysqli_stmt_attr_set
mysqli_stmt::bind_param, mysqli_stmt_bind_param
mysqli_stmt::bind_result, mysqli_stmt_bind_result
mysqli_stmt::close, mysqli_stmt_close
mysqli_stmt::__construct
mysqli_stmt::data_seek, mysqli_stmt_data_seek
mysqli_stmt::$errno, mysqli_stmt_errno
mysqli_stmt::$error_list, mysqli_stmt_error_list
mysqli_stmt::$error, mysqli_stmt_error
mysqli_stmt::execute, mysqli_stmt_execute
mysqli_stmt::fetch, mysqli_stmt_fetch
mysqli_stmt::$field_count, mysqli_stmt_field_count
mysqli_stmt::free_result, mysqli_stmt_free_result
mysqli_stmt::get_result, mysqli_stmt_get_result
mysqli_stmt::get_warnings, mysqli_stmt_get_warnings
mysqli_stmt::$insert_id, mysqli_stmt_insert_id
mysqli_stmt::more_results, mysqli_stmt_more_results
mysqli_stmt::next_result, mysqli_stmt_next_result
mysqli_stmt::$num_rows, mysqli_stmt::num_rows, mysqli_stmt_num_rows
mysqli_stmt::$param_count, mysqli_stmt_param_count
mysqli_stmt::prepare, mysqli_stmt_prepare
mysqli_stmt::reset, mysqli_stmt_reset
mysqli_stmt::result_metadata, mysqli_stmt_result_metadata
mysqli_stmt::send_long_data, mysqli_stmt_send_long_data
mysqli_stmt::$sqlstate, mysqli_stmt_sqlstate
mysqli_stmt::store_result, mysqli_stmt_store_result
The mysqli_result class
mysqli_result::__construct
mysqli_result::$current_field, mysqli_field_tell
mysqli_result::data_seek, mysqli_data_seek
mysqli_result::fetch_all, mysqli_fetch_all
mysqli_result::fetch_array, mysqli_fetch_array
mysqli_result::fetch_assoc, mysqli_fetch_assoc
mysqli_result::fetch_column, mysqli_fetch_column
mysqli_result::fetch_field_direct, mysqli_fetch_field_direct
mysqli_result::fetch_field, mysqli_fetch_field
mysqli_result::fetch_fields, mysqli_fetch_fields
mysqli_result::fetch_object, mysqli_fetch_object
mysqli_result::fetch_row, mysqli_fetch_row
mysqli_result::$field_count, mysqli_num_fields
mysqli_result::field_seek, mysqli_field_seek
mysqli_result::free, mysqli_result::close, mysqli_result::free_result, mysqli_free_result
mysqli_result::getIterator
mysqli_result::$lengths, mysqli_fetch_lengths
mysqli_result::$num_rows, mysqli_num_rows
The mysqli_driver class
mysqli_driver::embedded_server_end, mysqli_embedded_server_end
mysqli_driver::embedded_server_start, mysqli_embedded_server_start
mysqli_driver::$report_mode, mysqli_report
The mysqli_warning class
mysqli_warning::__construct
mysqli_warning::next
The mysqli_sql_exception class
mysqli_sql_exception::getSqlState
Aliases and deprecated Mysqli Functions
mysqli_connect
mysqli::escape_string, mysqli_escape_string
mysqli_execute
mysqli_get_client_stats
mysqli_get_links_stats
mysqli_report
mysqli::set_opt, mysqli_set_opt
Changelog
MySQL Functions (PDO_MYSQL)
PDO_MYSQL DSN
Original MySQL API
Installing/Configuring
Requirements
Installation
Runtime Configuration
Resource Types
Changelog
Predefined Constants
Examples
MySQL extension overview example
MySQL Functions
mysql_affected_rows
mysql_client_encoding
mysql_close
mysql_connect
mysql_create_db
mysql_data_seek
mysql_db_name
mysql_db_query
mysql_drop_db
mysql_errno
mysql_error
mysql_escape_string
mysql_fetch_array
mysql_fetch_assoc
mysql_fetch_field
mysql_fetch_lengths
mysql_fetch_object
mysql_fetch_row
mysql_field_flags
mysql_field_len
mysql_field_name
mysql_field_seek
mysql_field_table
mysql_field_type
mysql_free_result
mysql_get_client_info
mysql_get_host_info
mysql_get_proto_info
mysql_get_server_info
mysql_info
mysql_insert_id
mysql_list_dbs
mysql_list_fields
mysql_list_processes
mysql_list_tables
mysql_num_fields
mysql_num_rows
mysql_pconnect
mysql_ping
mysql_query
mysql_real_escape_string
mysql_result
mysql_select_db
mysql_set_charset
mysql_stat
mysql_tablename
mysql_thread_id
mysql_unbuffered_query
MySQL Native Driver
Overview
Installation
Runtime Configuration
Incompatibilities
Persistent Connections
Statistics
Notes
Memory management
MySQL Native Driver Plugin API
A comparison of mysqlnd plugins with MySQL Proxy
Obtaining the mysqlnd plugin API
MySQL Native Driver Plugin Architecture
The mysqlnd plugin API
Getting started building a mysqlnd plugin
Common Problems with MySQL and PHP
Download this Manual
PDF (US Ltr)
- 5.3Mb
PDF (A4)
- 5.3Mb
Connectors and APIs Manual
/
MySQL and PHP
/ Overview of the MySQL PHP drivers
7.2 Overview of the MySQL PHP drivers
7.2.1 Introduction
7.2.2 Terminology overview
7.2.3 Choosing an API
7.2.4 Choosing a library
7.2.5 Concepts
Copyright 1997-2022 the PHP Documentation Group.
PREV
HOME
UP
NEXT
Download this Manual
PDF (US Ltr)
- 5.3Mb
PDF (A4)
- 5.3Mb