Downloads
Documentation
Get Involved
Help
Getting Started
Introduction
A simple tutorial
Language Reference
Basic syntax
Types
Variables
Constants
Expressions
Operators
Control Structures
Functions
Classes and Objects
Namespaces
Errors
Exceptions
Generators
Attributes
References Explained
Predefined Variables
Predefined Exceptions
Predefined Interfaces and Classes
Context options and parameters
Supported Protocols and Wrappers
Security
Introduction
General considerations
Installed as CGI binary
Installed as an Apache module
Session Security
Filesystem Security
Database Security
Error Reporting
User Submitted Data
Hiding PHP
Keeping Current
Features
HTTP authentication with PHP
Cookies
Sessions
Dealing with XForms
Handling file uploads
Using remote files
Connection handling
Persistent Database Connections
Command line usage
Garbage Collection
DTrace Dynamic Tracing
Function Reference
Affecting PHP's Behaviour
Audio Formats Manipulation
Authentication Services
Command Line Specific Extensions
Compression and Archive Extensions
Cryptography Extensions
Database Extensions
Date and Time Related Extensions
File System Related Extensions
Human Language and Character Encoding Support
Image Processing and Generation
Mail Related Extensions
Mathematical Extensions
Non-Text MIME Output
Process Control Extensions
Other Basic Extensions
Other Services
Search Engine Extensions
Server Specific Extensions
Session Extensions
Text Processing
Variable and Type Related Extensions
Web Services
Windows Only Extensions
XML Manipulation
GUI Extensions
Keyboard Shortcuts
?
This help
j
Next menu item
k
Previous menu item
g p
Previous man page
g n
Next man page
G
Scroll to bottom
g g
Scroll to top
g h
Goto homepage
g s
Goto search
(current page)
/
Focus search box
简介 »
« Character sets
PHP 手册
函数参考
数据库扩展
针对各数据库系统对应的扩展
MySQL
Change language:
English
Brazilian Portuguese
Chinese (Simplified)
French
German
Japanese
Romanian
Russian
Spanish
Turkish
Other
Submit a Pull Request
Report a Bug
MySQL增强版扩展
简介
Overview
Quick start guide
Dual procedural and object-oriented interface
Connections
Executing statements
Prepared Statements
Stored Procedures
Multiple Statements
API support for transactions
Metadata
安装/配置
需求
安装
运行时配置
资源类型
mysqli 扩展和持久化连接
预定义常量
Notes
MySQLi 扩展的功能概述
MySQLi
— MySQLi类
mysqli::$affected_rows
— Gets the number of affected rows in a previous MySQL operation
mysqli::autocommit
— 打开或关闭本次数据库连接的自动命令提交事务模式
mysqli::begin_transaction
— Starts a transaction
mysqli::change_user
— Changes the user of the specified database connection
mysqli::character_set_name
— 返回当前数据库连接的默认字符编码
mysqli::close
— 关闭先前打开的数据库连接
mysqli::commit
— 提交一个事务
mysqli::$connect_errno
— Returns the error code from last connect call
mysqli::$connect_error
— Returns a description of the last connection error
mysqli::__construct
— Open a new connection to the MySQL server
mysqli::debug
— Performs debugging operations
mysqli::dump_debug_info
— 将调试信息输出到日志
mysqli::errno
— 返回最近函数调用的错误代码
mysqli::$error_list
— Returns a list of errors from the last command executed
mysqli::$error
— Returns a string description of the last error
mysqli::$field_count
— Returns the number of columns for the most recent query
mysqli::get_charset
— Returns a character set object
mysqli::$client_info
— 获取 MySQL 客户端信息
mysqli_get_client_version
— 作为一个整数返回MySQL客户端的版本
mysqli::get_connection_stats
— 返回客户端连接的统计数据
mysqli::$host_info
— 返回一个表述使用的连接类型的字符串
mysqli::$protocol_version
— 返回MySQL使用的协议版本号
mysqli::$server_info
— 返回MySQL服务器的版本号
mysqli::$server_version
— 作为一个整数返回MySQL服务器的版本
mysqli::get_warnings
— Get result of SHOW WARNINGS
mysqli::$info
— 返回最近执行的 SQL 语句的信息
mysqli::init
— 初始化 MySQLi 并返回一个资源类型的值,这个值可以作为 mysqli_real_connect() 函数的传入参数
mysqli::$insert_id
— 返回最后一条插入语句产生的自增 ID
mysqli::kill
— 让服务器杀掉一个 MySQL 线程
mysqli::more_results
— 检查批量查询中是否还有查询结果
mysqli::multi_query
— 执行查询
mysqli::next_result
— 为读取 multi_query 执行之后的下一个结果集做准备
mysqli::options
— 设置选项
mysqli::ping
— ping 一个连接,或者如果连接处于断开状态,重新连接
mysqli::poll
— 轮询连接
mysqli::prepare
— 准备执行一个 SQL 语句
mysqli::query
— 对数据库执行一次查询
mysqli::real_connect
— 建立一个 MySQL 服务器连接
mysqli::real_escape_string
— 根据当前连接的字符集,对于 SQL 语句中的特殊字符进行转义
mysqli::real_query
— 执行一个mysql查询
mysqli::reap_async_query
— 获取异步查询的结果
mysqli::refresh
— 刷新
mysqli::release_savepoint
— 从当前事务的保存点中移除一个命名保存点
mysqli::rollback
— 回退当前事务
mysqli::savepoint
— 在当前事务中增加一个命名保存点
mysqli::select_db
— 选择用于数据库查询的默认数据库
mysqli::set_charset
— 设置默认字符编码
mysqli::$sqlstate
— 返回上一次 SQL 操作的 SQLSTATE 错误信息
mysqli::ssl_set
— 使用 SSL 建立到数据库之间的安全连接
mysqli::stat
— 获取当前系统状态信息
mysqli::stmt_init
— 初始化一条语句并返回一个用于mysqli_stmt_prepare(调用)的对象
mysqli::store_result
— 转移上一次查询返回的结果集
mysqli::$thread_id
— 返回当前连接的线程 ID
mysqli::thread_safe
— 返回是否是线程安全的
mysqli::use_result
— Initiate a result set retrieval
mysqli::$warning_count
— Returns the number of warnings from the last query for the given link
MySQLi_STMT
— MySQLi_STMT类
mysqli_stmt::$affected_rows
— Returns the total number of rows changed, deleted, inserted, or matched by the last statement executed
mysqli_stmt::attr_get
— Used to get the current value of a statement attribute
mysqli_stmt::attr_set
— Used to modify the behavior of a prepared statement
mysqli_stmt::bind_param
— Binds variables to a prepared statement as parameters
mysqli_stmt::bind_result
— Binds variables to a prepared statement for result storage
mysqli_stmt::close
— Closes a prepared statement
mysqli_stmt::__construct
— Constructs a new mysqli_stmt object
mysqli_stmt::data_seek
— Seeks to an arbitrary row in statement result set
mysqli_stmt::$errno
— Returns the error code for the most recent statement call
mysqli_stmt::$error_list
— Returns a list of errors from the last statement executed
mysqli_stmt::$error
— Returns a string description for last statement error
mysqli_stmt::execute
— Executes a prepared statement
mysqli_stmt::fetch
— Fetch results from a prepared statement into the bound variables
mysqli_stmt::$field_count
— Returns the number of columns in the given statement
mysqli_stmt::free_result
— Frees stored result memory for the given statement handle
mysqli_stmt::get_result
— Gets a result set from a prepared statement
mysqli_stmt::get_warnings
— Get result of SHOW WARNINGS
mysqli_stmt::$insert_id
— Get the ID generated from the previous INSERT operation
mysqli_stmt::more_results
— Check if there are more query results from a multiple query
mysqli_stmt::next_result
— Reads the next result from a multiple query
mysqli_stmt::$num_rows
— Returns the number of rows fetched from the server
mysqli_stmt::$param_count
— Returns the number of parameters for the given statement
mysqli_stmt::prepare
— Prepares an SQL statement for execution
mysqli_stmt::reset
— Resets a prepared statement
mysqli_stmt::result_metadata
— Returns result set metadata from a prepared statement
mysqli_stmt::send_long_data
— Send data in blocks
mysqli_stmt::$sqlstate
— Returns SQLSTATE error from previous statement operation
mysqli_stmt::store_result
— Stores a result set in an internal buffer
mysqli_result
— mysqli_result类
mysqli_result::$current_field
— Get current field offset of a result pointer
mysqli_result::data_seek
— Adjusts the result pointer to an arbitrary row in the result
mysqli_result::fetch_all
— Fetch all result rows as an associative array, a numeric array, or both
mysqli_result::fetch_array
— Fetch a result row as an associative, a numeric array, or both
mysqli_result::fetch_assoc
— Fetch a result row as an associative array
mysqli_result::fetch_field_direct
— Fetch meta-data for a single field
mysqli_result::fetch_field
— Returns the next field in the result set
mysqli_result::fetch_fields
— Returns an array of objects representing the fields in a result set
mysqli_result::fetch_object
— Returns the current row of a result set as an object
mysqli_result::fetch_row
— Get a result row as an enumerated array
mysqli_result::$field_count
— Get the number of fields in a result
mysqli_result::field_seek
— Set result pointer to a specified field offset
mysqli_result::free
— Frees the memory associated with a result
mysqli_result::$lengths
— Returns the lengths of the columns of the current row in the result set
mysqli_result::$num_rows
— Gets the number of rows in a result
MySQLi_Driver
— MySQLi_Driver类
mysqli_driver::embedded_server_end
— Stop embedded server
mysqli_driver::embedded_server_start
— Initialize and start embedded server
mysqli_driver::$report_mode
— Sets mysqli error reporting mode
MySQLi_Warning
— MySQLi_Warning类
mysqli_warning::next
— Fetch next warning
mysqli_sql_exception
— mysqli异常类
别名和过时的 Mysqli 函数
mysqli_connect
— 别名 mysqli::__construct
mysqli_escape_string
— 别名 mysqli_real_escape_string
mysqli_execute
— mysqli_stmt_execute 的别名
mysqli_get_client_stats
— 返回客户端进程统计信息
mysqli_get_links_stats
— 返回打开和缓存的链接相关信息
mysqli_report
— 别名 mysqli_driver->report_mode
mysqli::set_opt
— Alias of mysqli_options
add a note
User Contributed Notes
There are no user contributed notes for this page.