mysql php api.

抽象的

本手册介绍了可以与MySQL一起使用的PHP扩展和接口。

有关法律信息,请参阅法律声明

有关使用MySQL的帮助,请访问MySQL论坛,您可以在其中讨论其他MySQL用户的问题。

文件生成:2021-04-01(修订版:69186)


表的内容

序言及法律公告
1介绍MySQL PHP API
MySQL PHP驱动程序概述
2.1介绍
2.2术语概述
2.3选择API
2.4选择图书馆
2.5概念
2.5.1缓冲和无缓冲的查询
2.5.2字符集
3 MySQL改进了扩展
3.1概述
3.2快速入门指南
3.2.1双程和面向对象的界面
3.2.2连接
3.2.3执行陈述
3.2.4准备的陈述
3.2.5存储过程
3.2.6多个陈述
3.2.7 API支持交易
3.2.8元数据
3.3安装/配置
3.3.1要求
3.3.2安装
3.3.3运行时配置
3.3.4资源类型
3.4 mysqli扩展和持久连接
3.5预定义常数
3.6笔记
3.7 MySQLI扩展功能摘要
3.8 mysqli课程
3.8.1.mysqli: affected_rows美元mysqli_affected_rows.
3.8.2mysqli:自动提交mysqli_autocommit
3.8.3mysqli: begin_transactionmysqli_begin_transaction.
3.8.4mysqli :: change_user.mysqli_change_user.
3.8.5mysqli :: character_set_name.mysqli_character_set_name.
3.8.6mysqli ::关闭mysqli_close.
3.8.7mysqli ::犯罪mysqli_commit.
3.8.8mysqli: connect_errno美元mysqli_connect_erno.
3.8.9mysqli :: $ connect_errormysqli_connect_error.
3.8.10mysqli :: __构造mysqli :: connect.mysqli_connect.
3.8.11mysqli :: debug.mysqli_debug.
3.8.12mysqli: dump_debug_infomysqli_dump_debug_info.
3.8.13mysqli :: $ errnomysqli_errno.
3.8.14mysqli :: $ error_listmysqli_error_list
3.8.15mysqli :: $错误mysqli_error.
3.8.16mysqli: field_count美元mysqli_field_count.
3.8.17mysqli: get_charsetmysqli_get_charset.
3.8.18mysqli :: $ client_infomysqli :: get_client_info.mysqli_get_client_info.
3.8.19mysqli :: $ client_versionmysqli_get_client_version.
3.8.20.mysqli: get_connection_statsmysqli_get_connection_stats.
3.8.21mysqli :: $ host_infomysqli_get_host_info
3.8.22mysqli: protocol_version美元mysqli_get_proto_info.
3.8.23mysqli :: $ server_infomysqli :: get_server_info.mysqli_get_server_info.
3.8.24mysqli :: $ server_versionmysqli_get_server_version.
3.8.25mysqli :: get_warnings.mysqli_get_warnings
3.8.26mysqli :: $信息mysqli_info.
3.8.27mysqli :: init.mysqli_init.
3.8.28mysqli :: $ insert_idmysqli_insert_id.
3.8.29mysqli ::杀人mysqli_kill.
3.8.30.mysqli :: more_results.mysqli_more_results.
3.8.31mysqli: multi_querymysqli_multi_query.
3.8.32mysqli :: next_resultmysqli_next_result
3.8.33mysqli:选项mysqli_options
3.8.34mysqli:萍mysqli_ping.
3.8.35Mysqli ::民意调查mysqli_poll.
3.8.36mysqli ::准备mysqli_prepare.
3.8.37mysqli ::查询mysqli_query.
3.8.38mysqli: real_connectmysqli_real_connect.
3.8.39mysqli: real_escape_stringmysqli_real_escape_string
3.8.40mysqli: real_querymysqli_real_query
3.8.41mysqli :: reap_async_query.mysqli_reap_async_query.
3.8.42mysqli ::刷新mysqli_refresh.
3.8.43MySQLI :: Refoy_SavePoint.mysqli_release_savepoint.
3.8.44mysqli ::回滚mysqli_rollback
3.8.45mysqli:保存点mysqli_savepoint.
3.8.46mysqli :: select_db.mysqli_select_db.
3.8.47mysqli :: set_charset.mysqli_set_charset.
3.8.48mysqli :: $ sqlstatemysqli_sqlstate.
3.8.49mysqli :: ssl_set.mysqli_ssl_set.
3.8.50mysqli :: stat.mysqli_stat.
3.8.51mysqli :: stmt_init.mysqli_stmt_init.
3.8.52mysqli :: store_result.mysqli_store_result.
3.8.53mysqli :: $ thread_idmysqli_thread_id
3.8.54mysqli :: thread_safe.mysqli_thread_safe
3.8.55mysqli :: devery_result.mysqli_use_result.
3.8.56mysqli :: $ warning_countmysqli_warning_count.
3.9 mysqli_stmt类
3.9.1mysqli_stmt: affected_rows美元mysqli_stmt_affected_rows
3.9.2mysqli_stmt :: attr_get.mysqli_stmt_attr_get
3.9.3mysqli_stmt: attr_setmysqli_stmt_attr_set.
3.9.4mysqli_stmt :: bind_param.mysqli_stmt_bind_param.
3.9.5mysqli_stmt :: bind_result.mysqli_stmt_bind_result
3.9.6mysqli_stmt ::关闭mysqli_stmt_close
3.9.7mysqli_stmt :: __构造
3.9.8mysqli_stmt :: data_seek.mysqli_stmt_data_seek
3.9.9mysqli_stmt :: $ errnomysqli_stmt_errno.
3.9.10mysqli_stmt :: $ error_listmysqli_stmt_error_list.
3.9.11mysqli_stmt :: $错误mysqli_stmt_error
3.9.12mysqli_stmt:执行mysqli_stmt_execute.
3.9.13mysqli_stmt:取mysqli_stmt_fetch.
3.9.14mysqli_stmt :: $ field_countmysqli_stmt_field_count
3.9.15mysqli_stmt: free_resultmysqli_stmt_free_result.
3.9.16mysqli_stmt :: get_resultmysqli_stmt_get_result
3.9.17mysqli_stmt: get_warningsmysqli_stmt_get_warnings
3.9.18mysqli_stmt :: $ insert_idmysqli_stmt_insert_id.
3.9.19mysqli_stmt :: more_results.mysqli_stmt_more_results.
3.9.20mysqli_stmt :: next_result.mysqli_stmt_next_result.
3.9.21mysqli_stmt :: $ num_rowsmysqli_stmt :: num_rows.mysqli_stmt_num_rows
3.9.22mysqli_stmt: param_count美元mysqli_stmt_param_count.
3.9.23mysqli_stmt ::准备mysqli_stmt_prepare
3.9.24mysqli_stmt ::重置mysqli_stmt_reset.
3.9.25mysqli_stmt :: Result_Metadata.mysqli_stmt_result_metadata.
3.9.26mysqli_stmt :: send_long_data.mysqli_stmt_send_long_data.
3.9.27mysqli_stmt :: $ sqlstatemysqli_stmt_sqlstate
3.9.28mysqli_stmt: store_resultmysqli_stmt_store_result
3.10 mysqli_result类
3.10.1mysqli_result :: $ current_fieldmysqli_field_tell.
3.10.2mysqli_result :: data_seek.mysqli_data_seek.
3.10.3mysqli_result :: fetch_all.mysqli_fetch_all.
3.10.4mysqli_result :: fetch_array.mysqli_fetch_array.
3.10.5mysqli_result: fetch_assocmysqli_fetch_assoc.
3.10.6mysqli_result :: fetch_field_direct.mysqli_fetch_field_direct.
3.10.7mysqli_result :: fetch_field.mysqli_fetch_field
3.10.8mysqli_result :: fetch_fields.mysqli_fetch_fields.
3.10.9mysqli_result :: fetch_object.mysqli_fetch_object
3.10.10mysqli_result :: fetch_rowmysqli_fetch_row
3.10.11mysqli_result: field_count美元mysqli_num_fields.
3.10.12mysqli_result: field_seekmysqli_field_seeek.
3.10.13mysqli_result :: freemysqli_result ::关闭mysqli_result :: free_result.mysqli_free_result
3.10.14mysqli_result :: $ loglesmysqli_fetch_lengths
3.10.15mysqli_result :: $ num_rowsmysqli_num_rows.
3.11 mysqli_driver类
3.11.1.mysqli_driver :: embedded_server_end.mysqli_embedded_server_end.
3.11.2mysqli_driver: embedded_server_startmysqli_embedded_server_start.
3.11.3.mysqli_driver :: $ eport_modemysqli_report.
3.12 mysqli_warning类
3.12.1mysqli_warning ::下一个
3.13 mysqli_sql_exception类
3.14别名和弃用MySQLI函数
3.14.1mysqli_connect.
3.14.2mysqli: escape_stringmysqli_escape_string
3.14.3.mysqli_execute.
3.14.4mysqli_get_client_stats.
3.14.5mysqli_get_links_stats
3.14.6mysqli_report.
3.14.7mysqli :: set_opt.mysqli_set_opt.
3.15更新日志
4 MySQL函数(PDO_MYSQL)
4.1pdo_mysql dsn.
5 Mysql_xdevapi
5.1安装/配置
5.1.1需求
5.1.2安装
5.1.3运行时配置
5.1.4从来源建设/编译
5.2预定义常数
5.3例子
5.4 Mysql_xdevapi函数
5.4.1表达
5.4.2getSession
5.5 BaseResult接口
5.5.1.BaseResult :: GetWarnings.
5.5.2BaseResult: getWarningsCount
5.6客户类
5.6.1mysql_xdevapi \客户:关闭
5.6.2客户:__construct
5.6.3客户:: GetClient.
5.7集合类
5.7.1集合::添加
5.7.2Collection :: AddOrePlaceone.
5.7.3.收藏:__construct
5.7.4集合::算法
5.7.5集合:: createIndex.
5.7.6集合:: DropIndex.
5.7.7收藏:existsInDatabase
5.7.8收藏:找到
5.7.9集合:: getName.
5.7.10收藏:getOne
5.7.11集合:: GetSchema.
5.7.12收藏:getSession
5.7.13集合::修改
5.7.14集合::删除
5.7.15收藏:removeOne
5.7.16集合:: Reployone.
5.8 Collectionadd类
5.8.1.CollectionAdd :: __构造
5.8.2collectionadd ::执行
5.9 CollectionFind类
5.9.1collectionfind :: bind.
5.9.2CollectionFind :: __构造
5.9.3CollectionFind:执行
5.9.4CollectionFind :: Fields.
5.9.5.CollectionFind :: GroupBy.
5.9.6CollectionFind ::拥有
5.9.7CollectionFind ::限制
5.9.8CollectionFind: lockExclusive
5.9.9.CollectionFind: lockShared
5.9.10CollectionFind :: Offset.
5.9.11CollectionFind :: Sort.
5.10 CollectionModify类
5.10.1CollectionModify: arrayAppend
5.10.2CollectionModify :: Arrayinsert.
5.10.3collectionmodify :: bind.
5.10.4CollectionModify :: __构造
5.10.5CollectionModify :: Execute.
5.10.6CollectionModify ::限制
5.10.7CollectionModify:补丁
5.10.8CollectionModify ::替换
5.10.9CollectionModify :: Set.
5.10.10CollectionModify :: Skip.
5.10.11CollectionModify :: Sort.
5.10.12CollectionModify ::未设置
5.11集合式重放类
5.11.1.CleastingRemove :: bind.
5.11.2CollectionRemove: __construct
5.11.3.CleastingRemove ::执行
5.11.4CleastingRemove ::限制
5.11.5CleastingRemove :: Sort.
5.12 ColumnResult类
5.12.1columnresult :: __构造
5.12.2ColumNResult :: GetCaracterSetName.
5.12.3ColumnResult: getCollationName
5.12.4columnresult :: getColumnLabel.
5.12.5columnresult :: getColumnName.
5.12.6columnresult :: getFactionalDigits.
5.12.7columnresult :: getLength.
5.12.8columnresult :: getschemaname.
5.12.9columnresult :: gettableLabel.
5.12.10columnresult :: gettableName.
5.12.11columnresult :: gettype.
5.12.12ColumnResult: isNumberSigned
5.12.13ColumnResult: isPadded
5.13 CrudOperationBindable界面
5.13.1CrudoperationBindable :: bind.
5.14 CrudoperationLimitable接口
5.14.1CrudoperationLimitable ::限制
5.15粗鲁化kippable接口
5.15.1.Crudoperationskippable ::跳过
5.16粗鲁化接口
5.16.1.rudoperationstable :: sort.
5.17 DatabaseObject接口
5.17.1DatabaseObject: existsInDatabase
5.17.2databaseObject :: getName.
5.17.3DatabaseObject :: Gotsession.
5.18 DocreSult类
5.18.1DocreSult :: __构造
5.18.2Docresult :: fetchall.
5.18.3.DocResult: fetchOne
5.18.4DocreSult :: GetWarnings.
5.18.5Docresult :: GetWarningsCount.
5.19例外类
5.20执行界面
5.20.1可执行文件::执行
5.21 ExecutionStatus类
5.21.1.ExecutionStatus :: __构造
5.22表达类
5.22.1表达:: __构造
5.23结果类
5.23.1.结果:: __构造
5.23.2结果::getAffectedItemsCount
5.23.3.结果::getAutoIncrementValue
5.23.4结果:: GetGeneratedIds.
5.23.5.结果:: GetWarnings.
5.23.6结果::getWarningsCount
5.24 Rowresult类
5.24.1Rowresult :: __构造
5.24.2Rowresult :: fetchall.
5.24.3.RowResult: fetchOne
5.24.4RowResult: getColumnsCount
5.24.5RowResult :: GetColumnNames.
5.24.6RowResult :: GetColumns.
5.24.7Rowresult :: GetWarnings.
5.24.8.RowResult: getWarningsCount
5.25架构类
5.25.1架构:: __构造
5.25.2架构:: CreateCollection.
5.25.3模式:dropCollection
5.25.4架构::存在的indsindatabase.
5.25.5架构:: GetCollection.
5.25.6架构:: getCollectionable.
5.25.7架构:: getCollections.
5.25.8架构:: getName.
5.25.9架构:: Gotsession.
5.25.10架构:: gettable.
5.25.11架构:: gettables.
5.26 SchemaObject界面
5.26.1.SchemaObject :: GetSchema.
5.27会话类
5.27.1会话::关闭
5.27.2会话:提交
5.27.3.会议:: __构造
5.27.4会话:createSchema
5.27.5会议:: Dropschema.
5.27.6会话:: generateuuid.
5.27.7会话:: getDefaultschema.
5.27.8会议:: GetSchema.
5.27.9会议:: getSchemas
5.27.10会话:: geterverversion.
5.27.11会话:: listclients.
5.27.12会话:: QuoteName.
5.27.13会话:releaseSavepoint
5.27.14会话:回滚
5.27.15会话::回滚托
5.27.16会话:: setsavepoint.
5.27.17会话:sql
5.27.18会话:: StartTransaction.
5.28 SQLStatement类
5.28.1.sqlstatement :: bind.
5.28.2sqlstatement :: __构造
5.28.3.sqlstatement ::执行
5.28.4sqlstatement :: getnextresult.
5.28.5sqlstatement :: getresult
5.28.6.SqlStatement: hasMoreResults
5.29 SqlStatementResult类
5.29.1sqlstatementResult :: __构造
5.29.2sqlstatementResult :: fetchall.
5.29.3.SqlStatementResult: fetchOne
5.29.4sqlstatementResult :: getaffectedItemscount.
5.29.5SqlStatementResult: getColumnsCount
5.29.6SqlStatementResult: getcolumnname
5.29.7sqlstatementResult :: getColumns.
5.29.8sqlstatementResult :: GetGeneratedIds.
5.29.9SqlStatementResult: getLastInsertId
5.29.10sqlstatementResult :: GetWarnings.
5.29.11sqlstatementResult :: getWarningsCount.
5.29.12SqlStatementResult: hasData
5.29.13SqlStatementResult: nextResult
5.30声明类
5.30.1声明::__construct
5.30.2声明:: GetNextresult.
5.30.3声明:: GetResult.
5.30.4声明:: hasmoreResults.
5.31表类
5.31.1表:: __构造
5.31.2表::算法
5.31.3表::删除
5.31.4表::存在存在
5.31.5表:: getName.
5.31.6表:: getSchema.
5.31.7表::getSession
5.31.8表::插入
5.31.9表::isView
5.31.10表::选择
5.31.11表::更新
5.32 Tabledelete类
5.32.1tableedelete :: bind.
5.32.2TableDelete :: __构建
5.32.3.tableedelete ::执行
5.32.4TableDelete:限制
5.32.5Tabledelete :: Orderby.
5.32.6tableedelete ::哪里
5.33 TableInsert类
5.33.1TableInsert: __construct
5.33.2tableinsert ::执行
5.33.3tableiner ::值
5.34 TableSelect类
5.34.1.tableselect :: bind.
5.34.2.TableSelect: __construct
5.34.3.TableSelect:执行
5.34.4tableselect :: groupby.
5.34.5tableselect ::拥有
5.34.6Tableselect :: limit.
5.34.7tableselect :: lockexclusive.
5.34.8Tableselect ::锁定分子
5.34.9TableSelect:抵消
5.34.10TableSelect: orderby
5.34.11tableselect ::
5.35 TableUpdate类
5.35.1.tableupdate :: bind.
5.35.2TableUpdate: __construct
5.35.3.tableupdate ::执行
5.35.4TableUpdate :: limit.
5.35.5.TableUpdate :: Orderby.
5.35.6TableUpdate:集
5.35.7TableUpdate ::哪里
5.36警告类
5.36.1警告:: __构造
6原始MySQL API
6.1安装/配置
但是需求
6.1.2安装
6.1.3运行时配置
6.1.4资源类型
6.2变更乐
6.3预定义常数
6.4例子
6.4.1 MySQL扩展简介示例
6.5 MySQL功能
6.5.1.mysql_affected_rows
6.5.2mysql_client_encoding
6.5.3mysql_close.
6.5.4首先
6.5.5.mysql_create_db.
6.5.6mysql_data_seek.
6.5.7mysql_db_name.
6.5.8mysql_db_query.
6.5.9mysql_drop_db.
6.5.10mysql_errno.
6.5.11mysql_error.
6.5.12mysql_escape_string
6.5.13mysql_fetch_array.
6.5.14作用是
6.5.15mysql_fetch_field.
6.5.16mysql_fetch_lengths
6.5.17mysql_fetch_object.
6.5.18mysql_fetch_row.
6.5.19mysql_field_flags.
6.5.20作用是
6.5.21mysql_field_name.
6.5.22mysql_field_seek
6.5.23mysql_field_table
6.5.24作用是
6.5.25mysql_free_result.
6.5.26mysql_get_client_info
6.5.27mysql_get_host_info
6.5.28mysql_get_proto_info.
6.5.29mysql_get_server_info.
6.5.30mysql_info
6.5.31mysql_insert_id.
6.5.32mysql_list_dbs
6.5.33mysql_list_fields.
6.5.34mysql_list_processes.
6.5.35mysql_list_tables
6.5.36mysql_num_fields
6.5.37mysql_num_rows.
6.5.38mysql_pconnect.
6.5.39mysql_ping.
6.5.40mysql_query.
6.5.41mysql_real_escape_string
6.5.42mysql_result.
6.5.43mysql_select_db.
6.5.44mysql_set_charset.
6.5.45mysql_stat
6.5.46mysql_tableName.
6.5.47mysql_thread_id.
6.5.48mysql_unbuffered_query.
7 MySQL本地驱动
7.1概述
7.2安装
7.3运行时配置
7.4不兼容
7.5持久连接
7.6统计学
7.7笔记
7.8内存管理
7.9 MySQL本机驱动程序插件API
7.9.1 MySQLND插件与MySQL代理的比较
7.9.2获取mysqlnd plugin API
7.9.3 MySQL本机驱动程序插件架构
7.9.4 MySQLND插件API
7.9.5开始构建mysqlnd插件
MySQL和PHP的常见问题