MySQL and PHP

1 MySQL and PHPA bstractThis manual describes the PHP extensions and interfaces that can be used with legal information, see the Legal help with using MySQL , please visit the MySQL Forums, where you can discuss your issues with other generated on: 2022-02-15 (revision: 71961)Table of ContentsPreface and Legal xiii1 Introduction to the MySQL PHP 12 Overview of the MySQL PHP Terminology Choosing an Choosing a Buffered and Unbuffered Character 83 MySQL Improved Quick start Dual procedural and object-oriented Executing Prepared Stored Multiple API support for Runtime Resource The mysqli Extension and Persistent Predefined The MySQLi Extension Function The mysqli mysqli::$affected_rows, mysqli::autocommit, mysqli::begin_transaction, mysqli::change_user, mysqli::character_set_name, mysqli::close, mysqli::commit, mysqli::$connect_errno, mysqli::$connect_error, mysqli::__construct, mysqli::connect, mysqli::debug, mysqli::dump_debug_info, mysqli::$errno, mysqli::$error_list, mysqli::$error, mysqli::$field_count, mysqli::get_charset, mysqli::$client_info, mysqli::get_client_info, mysqli::$client_version, 90iiiMySQL and mysqli::get_connection_stats, mysqli::$host_info, mysqli::$protocol_version, mysqli::$server_info, mysqli::get_server_info, mysqli::$server_version, mysqli::get_warnings, mysqli::$info, mysqli::init, mysqli::$insert_id, mysqli::kill, mysqli::more_results, mysqli::multi_query, mysqli.

2 Next_result, mysqli::options, mysqli::ping, mysqli::poll, mysqli::prepare, mysqli::query, mysqli::real_connect, mysqli::real_escape_string, mysqli::real_query, mysqli::reap_async_query, mysqli::refresh, mysqli::release_savepoint, mysqli::rollback, mysqli::savepoint, mysqli::select_db, mysqli::set_charset, mysqli::$sqlstate, mysqli::ssl_set, mysqli::stat, mysqli::stmt_init, mysqli::store_result, mysqli::$thread_id, mysqli::thread_safe, mysqli::use_result, mysqli::$warning_count, The mysqli_stmt mysqli_stmt::$affected_rows, mysqli_stmt::attr_get, mysqli_stmt::attr_set, mysqli_stmt::bind_param, mysqli_stmt::bind_result, mysqli_stmt::close, mysqli_ mysqli_stmt::data_seek, mysqli_stmt::$errno, mysqli_stmt::$error_list, mysqli_stmt::$error, mysqli_stmt::execute, mysqli_stmt::fetch, mysqli_stmt::$field_count, mysqli_stmt::free_result, 173ivMySQL and mysqli_stmt::get_result, mysqli_stmt::get_warnings, mysqli_stmt::$insert_id, mysqli_stmt::more_results, mysqli_stmt::next_result, mysqli_stmt::$num_rows, mysqli_stmt::num_rows, mysqli_stmt::$param_count, mysqli_stmt::prepare, mysqli_stmt::reset, mysqli_stmt::result_metadata, mysqli_stmt::send_long_data, mysqli_stmt::$sqlstate, mysqli_stmt::store_result, The mysqli_result mysqli_ mysqli_result::$current_field, mysqli_result::data_seek, mysqli_result::fetch_all, mysqli_result::fetch_array, mysqli_result::fetch_assoc, mysqli_result::fetch_column, mysqli_result::fetch_field_direct, mysqli_result.

3 Fetch_field, mysqli_result::fetch_fields, mysqli_result::fetch_object, mysqli_result::fetch_row, mysqli_result::$field_count, mysqli_result::field_seek, mysqli_result::free, mysqli_result::close,mysqli_result::free _result, mysqli_ mysqli_result::$lengths, mysqli_result::$num_rows, The mysqli_driver mysqli_driver::embedded_server_end, mysqli_driver::embedded_server_start, mysqli_driver::$report_mode, The mysqli_warning mysqli_ mysqli_ The mysqli_sql_exception mysqli_sql_ Aliases and deprecated Mysqli mysqli::escape_string, mysqli::set_opt, 2394 MySQL Functions (PDO_MYSQL).. 241vMySQL and PDO_MYSQL 2445 Runtime Building / Compiling From Predefined Mysql_xdevapi BaseResult Client mysql_xdevapi\ Collection CollectionAdd CollectionFind CollectionModify 300viMySQL and CollectionRemove ColumnResult CrudOperationBindable CrudOperationLimitable CrudOperationSkippable CrudOperationSortable DatabaseObject DocResult

4 Exception Executable ExecutionStatus 341viiMySQL and Expression Result RowResult Schema SchemaObject Session SqlStatement 386viiiMySQL and SqlStatementResult Statement Table TableDelete TableInsert TableSelect 425ixMySQL and TableUpdate Warning 4376 Original MySQL Runtime Resource Predefined MySQL extension overview MySQL 485xMySQL and 5137 MySQL Native Runtime Persistent Memory MySQL Native Driver Plugin A comparison of mysqlnd plugins with MySQL Obtaining the mysqlnd plugin MySQL Native Driver Plugin The mysqlnd plugin Getting started building a mysqlnd 5468 Common Problems with MySQL and 551xixiiPreface and Legal NoticesThis manual

5 Describes the PHP extensions and interfaces that can be used with NoticesCopyright 1997, 2022, Oracle and/or its software and related documentation are provided under a license agreement containing restrictionson use and disclosure and are protected by intellectual property laws. Except as expressly permittedin your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast,modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by anymeans. Reverse engineering, disassembly, or decompilation of this software, unless required by law forinteroperability, is information contained herein is subject to change without notice and is not warranted to be you find any errors, please report them to us in this is software or related documentation that is delivered to the Government or anyone licensing iton behalf of the Government, then the following notice is GOVERNMENT END USERS.

6 Oracle programs (including any operating system, integratedsoftware, any programs embedded, installed or activated on delivered hardware, and modifications ofsuch programs) and Oracle computer documentation or other Oracle data delivered to or accessed Government end users are "commercial computer software" or "commercial computer softwaredocumentation" pursuant to the applicable Federal Acquisition Regulation and agency-specificsupplemental regulations. As such, the use, reproduction, duplication, release, display, disclosure,modification, preparation of derivative works, and/or adaptation of i) Oracle programs (including anyoperating system, integrated software, any programs embedded, installed or activated on deliveredhardware, and modifications of such programs), ii) Oracle computer documentation and/or iii) other Oracledata, is subject to the rights and limitations specified in the license contained in the applicable terms governing the Government's use of Oracle cloud services are defined by the applicablecontract for such services.

7 No other rights are granted to the software or hardware is developed for general use in a variety of information managementapplications. It is not developed or intended for use in any inherently dangerous applications, includingapplications that may create a risk of personal injury. If you use this software or hardware in dangerousapplications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and othermeasures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damagescaused by use of this software or hardware in dangerous and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarksof their respective and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarksare used under license and are trademarks or registered trademarks of SPARC International, Inc.

8 AMD,Epyc, and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is aregistered trademark of The Open software or hardware and documentation may provide access to or information about content,products, and services from third parties. Oracle Corporation and its affiliates are not responsible for andexpressly disclaim all warranties of any kind with respect to third-party content, products, and servicesunless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and itsaffiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use ofxiiiAccess to Oracle Support for Accessibilitythird-party content, products, or services, except as set forth in an applicable agreement between you documentation is NOT distributed under a GPL license. Use of this documentation is subject to thefollowing terms:You may create a printed copy of this documentation solely for your own personal use.

9 Conversion to otherformats is allowed as long as the actual content is not altered or edited in any way. You shall not publishor distribute this documentation in any form or on any media, except if you distribute the documentation ina manner similar to how Oracle disseminates it (that is, electronically for download on a Web site with thesoftware) or on a CD-ROM or similar medium, provided however that the documentation is disseminatedtogether with the software on the same medium. Any other use, such as any dissemination of printedcopies or use of this documentation, in whole or in part, in another publication, requires the prior writtenconsent from an authorized representative of Oracle. Oracle and/or its affiliates reserve any and all rightsto this documentation not expressly granted to Oracle Support for AccessibilityOracle customers that have purchased support have access to electronic support through My OracleSupport.

10 For information, # 1 Introduction to the MySQL PHP APIPHP is a server-side, HTML-embedded scripting language that may be used to create dynamic Webpages. It is available for most operating systems and Web servers, and can access most commondatabases, including MySQL . PHP may be run as a separate program or compiled as a module for usewith a Web provides four different MySQL API extensions:NoteThe PHP documentation assumes PHP 7 and higher is used; functionality specificto PHP 5 and below is not documented. Chapter 3, MySQL Improved Extension: Stands for MySQL , Improved ; this extension is availableas of PHP It is intended for use with MySQL and later. This extension fully supports theauthentication protocol used in MySQL , as well as the Prepared Statements and Multiple StatementsAPIs. In addition, this extension provides an advanced, object-oriented programming interface.