Contact MySQL
|
Login
|
Register
The world's most popular open source database
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/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
Examples
MySQLi extension basic examples
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::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::rpl_query_type, mysqli_rpl_query_type
mysqli::savepoint, mysqli_savepoint
mysqli::select_db, mysqli_select_db
mysqli::send_query, mysqli_send_query
mysqli::set_charset, mysqli_set_charset
mysqli::set_local_infile_default, mysqli_set_local_infile_default
mysqli::set_local_infile_handler, mysqli_set_local_infile_handler
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::$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_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::$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
Aliases and deprecated Mysqli Functions
mysqli_bind_param
mysqli_bind_result
mysqli_client_encoding
mysqli_connect
mysqli::disable_reads_from_master, mysqli_disable_reads_from_master
mysqli_disable_rpl_parse
mysqli_enable_reads_from_master
mysqli_enable_rpl_parse
mysqli_escape_string
mysqli_execute
mysqli_fetch
mysqli_get_cache_stats
mysqli_get_client_stats
mysqli_get_links_stats
mysqli_get_metadata
mysqli_master_query
mysqli_param_count
mysqli_report
mysqli_rpl_parse_enabled
mysqli_rpl_probe
mysqli_send_long_data
mysqli::set_opt, mysqli_set_opt
mysqli_slave_query
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
Mysqlnd replication and load balancing plugin
Key Features
Limitations
On the name
Quickstart and Examples
Setup
Running statements
Connection state
SQL Hints
Local transactions
XA/Distributed Transactions
Service level and consistency
Global transaction IDs
Cache integration
Failover
Partitioning and Sharding
MySQL Fabric
Concepts
Architecture
Connection pooling and switching
Local transaction handling
Error handling
Transient errors
Failover
Load balancing
Read-write splitting
Filter
Service level and consistency
Global transaction IDs
Cache integration
Supported clusters
XA/Distributed transactions
Installing/Configuring
Requirements
Installation
Runtime Configuration
Plugin configuration file (>=1.1.x)
Predefined Constants
Mysqlnd_ms Functions
mysqlnd_ms_dump_servers
mysqlnd_ms_fabric_select_global
mysqlnd_ms_fabric_select_shard
mysqlnd_ms_get_last_gtid
mysqlnd_ms_get_last_used_connection
mysqlnd_ms_get_stats
mysqlnd_ms_match_wild
mysqlnd_ms_query_is_select
mysqlnd_ms_set_qos
mysqlnd_ms_set_user_pick_server
mysqlnd_ms_xa_begin
mysqlnd_ms_xa_commit
mysqlnd_ms_xa_gc
mysqlnd_ms_xa_rollback
Change History
PECL/mysqlnd_ms 1.6 series
PECL/mysqlnd_ms 1.5 series
PECL/mysqlnd_ms 1.4 series
PECL/mysqlnd_ms 1.3 series
PECL/mysqlnd_ms 1.2 series
PECL/mysqlnd_ms 1.1 series
PECL/mysqlnd_ms 1.0 series
Mysqlnd query result cache plugin
Key Features
Limitations
On the name
Quickstart and Examples
Architecture and Concepts
Setup
Caching queries
Setting the TTL
Pattern based caching
Slam defense
Finding cache candidates
Measuring cache efficiency
Beyond TTL: user-defined storage
Installing/Configuring
Requirements
Installation
Runtime Configuration
Predefined Constants
mysqlnd_qc Functions
mysqlnd_qc_clear_cache
mysqlnd_qc_get_available_handlers
mysqlnd_qc_get_cache_info
mysqlnd_qc_get_core_stats
mysqlnd_qc_get_normalized_query_trace_log
mysqlnd_qc_get_query_trace_log
mysqlnd_qc_set_cache_condition
mysqlnd_qc_set_is_select
mysqlnd_qc_set_storage_handler
mysqlnd_qc_set_user_handlers
Change History
PECL/mysqlnd_qc 1.2 series
PECL/mysqlnd_qc 1.1 series
PECL/mysqlnd_qc 1.0 series
Mysqlnd user handler plugin
Security considerations
Documentation note
On the name
Quickstart and Examples
Setup
How it works
Installing a proxy
Basic query monitoring
Installing/Configuring
Requirements
Installation
Runtime Configuration
Resource Types
Predefined Constants
The MysqlndUhConnection class
MysqlndUhConnection::changeUser
MysqlndUhConnection::charsetName
MysqlndUhConnection::close
MysqlndUhConnection::connect
MysqlndUhConnection::__construct
MysqlndUhConnection::endPSession
MysqlndUhConnection::escapeString
MysqlndUhConnection::getAffectedRows
MysqlndUhConnection::getErrorNumber
MysqlndUhConnection::getErrorString
MysqlndUhConnection::getFieldCount
MysqlndUhConnection::getHostInformation
MysqlndUhConnection::getLastInsertId
MysqlndUhConnection::getLastMessage
MysqlndUhConnection::getProtocolInformation
MysqlndUhConnection::getServerInformation
MysqlndUhConnection::getServerStatistics
MysqlndUhConnection::getServerVersion
MysqlndUhConnection::getSqlstate
MysqlndUhConnection::getStatistics
MysqlndUhConnection::getThreadId
MysqlndUhConnection::getWarningCount
MysqlndUhConnection::init
MysqlndUhConnection::killConnection
MysqlndUhConnection::listFields
MysqlndUhConnection::listMethod
MysqlndUhConnection::moreResults
MysqlndUhConnection::nextResult
MysqlndUhConnection::ping
MysqlndUhConnection::query
MysqlndUhConnection::queryReadResultsetHeader
MysqlndUhConnection::reapQuery
MysqlndUhConnection::refreshServer
MysqlndUhConnection::restartPSession
MysqlndUhConnection::selectDb
MysqlndUhConnection::sendClose
MysqlndUhConnection::sendQuery
MysqlndUhConnection::serverDumpDebugInformation
MysqlndUhConnection::setAutocommit
MysqlndUhConnection::setCharset
MysqlndUhConnection::setClientOption
MysqlndUhConnection::setServerOption
MysqlndUhConnection::shutdownServer
MysqlndUhConnection::simpleCommand
MysqlndUhConnection::simpleCommandHandleResponse
MysqlndUhConnection::sslSet
MysqlndUhConnection::stmtInit
MysqlndUhConnection::storeResult
MysqlndUhConnection::txCommit
MysqlndUhConnection::txRollback
MysqlndUhConnection::useResult
The MysqlndUhPreparedStatement class
MysqlndUhPreparedStatement::__construct
MysqlndUhPreparedStatement::execute
MysqlndUhPreparedStatement::prepare
Mysqlnd_uh Functions
mysqlnd_uh_convert_to_mysqlnd
mysqlnd_uh_set_connection_proxy
mysqlnd_uh_set_statement_proxy
Change History
PECL/mysqlnd_uh 1.0 series
Mysqlnd connection multiplexing plugin
Key Features
Limitations
About the name mysqlnd_mux
Concepts
Architecture
Connection pool
Sharing connections
Installing/Configuring
Requirements
Installation
Runtime Configuration
Predefined Constants
Change History
PECL/mysqlnd_mux 1.0 series
Mysqlnd Memcache plugin
Key Features
Limitations
On the name
Quickstart and Examples
Setup
Usage
Installing/Configuring
Requirements
Installation
Runtime Configuration
Predefined Constants
Mysqlnd_memcache Functions
mysqlnd_memcache_get_config
mysqlnd_memcache_set
Change History
PECL/mysqlnd_memcache 1.0 series
Common Problems with MySQL and PHP
Download this Manual
PDF (US Ltr)
- 6.4Mb
PDF (A4)
- 6.4Mb
HTML Download (TGZ)
- 3.1Mb
HTML Download (Zip)
- 3.2Mb
Connectors and APIs Manual
/
MySQL and PHP
/ Overview of the MySQL PHP drivers
8.2 Overview of the MySQL PHP drivers
[
+/-
]
8.2.1 Introduction
8.2.2 Terminology overview
8.2.3 Choosing an API
8.2.4 Choosing a library
8.2.5 Concepts
Copyright 1997-2019 the PHP Documentation Group.
PREV
HOME
UP
NEXT
Download this Manual
PDF (US Ltr)
- 6.4Mb
PDF (A4)
- 6.4Mb
HTML Download (TGZ)
- 3.1Mb
HTML Download (Zip)
- 3.2Mb