Transcription
MySQL and PHP
AbstractThis manual describes the PHP extensions and interfaces that can be used with MySQL.For legal information, see the Legal Notices.For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQLusers.Document generated on: 2021-05-29 (revision: 69900)
Table of ContentsPreface and Legal Notices . xiii1 Introduction to the MySQL PHP API . 12 Overview of the MySQL PHP drivers . 32.1 Introduction . 32.2 Terminology overview . 32.3 Choosing an API . 42.4 Choosing a library . 52.5 Concepts . 72.5.1 Buffered and Unbuffered queries . 72.5.2 Character sets . 83 MySQL Improved Extension . 113.1 Overview . 133.2 Quick start guide . 173.2.1 Dual procedural and object-oriented interface . 173.2.2 Connections . 193.2.3 Executing statements . 213.2.4 Prepared Statements . 243.2.5 Stored Procedures . 303.2.6 Multiple Statements . 343.2.7 API support for transactions . 363.2.8 Metadata . 373.3 Installing/Configuring . 393.3.1 Requirements . 393.3.2 Installation . 393.3.3 Runtime Configuration . 413.3.4 Resource Types . 423.4 The mysqli Extension and Persistent Connections . 423.5 Predefined Constants . 433.6 Notes . 473.7 The MySQLi Extension Function Summary . 483.8 The mysqli class . 543.8.1 mysqli:: affected rows, mysqli affected rows . 573.8.2 mysqli::autocommit, mysqli autocommit . 593.8.3 mysqli::begin transaction, mysqli begin transaction . 623.8.4 mysqli::change user, mysqli change user . 653.8.5 mysqli::character set name, mysqli character set name . 673.8.6 mysqli::close, mysqli close . 693.8.7 mysqli::commit, mysqli commit . 703.8.8 mysqli:: connect errno, mysqli connect errno . 713.8.9 mysqli:: connect error, mysqli connect error . 723.8.10 mysqli:: construct, mysqli::connect, mysqli connect . 733.8.11 mysqli::debug, mysqli debug . 773.8.12 mysqli::dump debug info, mysqli dump debug info . 783.8.13 mysqli:: errno, mysqli errno . 793.8.14 mysqli:: error list, mysqli error list . 813.8.15 mysqli:: error, mysqli error . 823.8.16 mysqli:: field count, mysqli field count . 843.8.17 mysqli::get charset, mysqli get charset . 853.8.18 mysqli:: client info, mysqli::get client info,mysqli get client info . 873.8.19 mysqli:: client version, mysqli get client version . 88iii
MySQL and PHP3.8.20 mysqli::get connection stats, mysqli get connection stats . 893.8.21 mysqli:: host info, mysqli get host info . 923.8.22 mysqli:: protocol version, mysqli get proto info . 933.8.23 mysqli:: server info, mysqli::get server info,mysqli get server info . 943.8.24 mysqli:: server version, mysqli get server version . 963.8.25 mysqli::get warnings, mysqli get warnings . 983.8.26 mysqli:: info, mysqli info . 983.8.27 mysqli::init, mysqli init . 1003.8.28 mysqli:: insert id, mysqli insert id . 1013.8.29 mysqli::kill, mysqli kill . 1023.8.30 mysqli::more results, mysqli more results . 1043.8.31 mysqli::multi query, mysqli multi query . 1053.8.32 mysqli::next result, mysqli next result . 1073.8.33 mysqli::options, mysqli options . 1083.8.34 mysqli::ping, mysqli ping . 1103.8.35 mysqli::poll, mysqli poll . 1113.8.36 mysqli::prepare, mysqli prepare . 1133.8.37 mysqli::query, mysqli query . 1153.8.38 mysqli::real connect, mysqli real connect . 1183.8.39 mysqli::real escape string, mysqli real escape string . 1223.8.40 mysqli::real query, mysqli real query . 1243.8.41 mysqli::reap async query, mysqli reap async query . 1253.8.42 mysqli::refresh, mysqli refresh . 1253.8.43 mysqli::release savepoint, mysqli release savepoint . 1263.8.44 mysqli::rollback, mysqli rollback . 1273.8.45 mysqli::savepoint, mysqli savepoint . 1283.8.46 mysqli::select db, mysqli select db . 1283.8.47 mysqli::set charset, mysqli set charset . 1303.8.48 mysqli:: sqlstate, mysqli sqlstate . 1323.8.49 mysqli::ssl set, mysqli ssl set . 1343.8.50 mysqli::stat, mysqli stat . 1353.8.51 mysqli::stmt init, mysqli stmt init . 1363.8.52 mysqli::store result, mysqli store result . 1373.8.53 mysqli:: thread id, mysqli thread id . 1383.8.54 mysqli::thread safe, mysqli thread safe . 1403.8.55 mysqli::use result, mysqli use result . 1413.8.56 mysqli:: warning count, mysqli warning count . 1433.9 The mysqli stmt class . 1453.9.1 mysqli stmt:: affected rows, mysqli stmt affected rows . 1463.9.2 mysqli stmt::attr get, mysqli stmt attr get . 1483.9.3 mysqli stmt::attr set, mysqli stmt attr set . 1493.9.4 mysqli stmt::bind param, mysqli stmt bind param . 1503.9.5 mysqli stmt::bind result, mysqli stmt bind result . 1533.9.6 mysqli stmt::close, mysqli stmt close . 1553.9.7 mysqli stmt:: construct . 1563.9.8 mysqli stmt::data seek, mysqli stmt data seek . 1573.9.9 mysqli stmt:: errno, mysqli stmt errno . 1593.9.10 mysqli stmt:: error list, mysqli stmt error list . 1613.9.11 mysqli stmt:: error, mysqli stmt error . 1633.9.12 mysqli stmt::execute, mysqli stmt execute . 1653.9.13 mysqli stmt::fetch, mysqli stmt fetch . 1673.9.14 mysqli stmt:: field count, mysqli stmt field count . 1693.9.15 mysqli stmt::free result, mysqli stmt free result . 171iv
MySQL and PHP3.9.16 mysqli stmt::get result, mysqli stmt get result .3.9.17 mysqli stmt::get warnings, mysqli stmt get warnings .3.9.18 mysqli stmt:: insert id, mysqli stmt insert id .3.9.19 mysqli stmt::more results, mysqli stmt more results .3.9.20 mysqli stmt::next result, mysqli stmt next result .3.9.21 mysqli stmt:: num rows, mysqli stmt::num rows,mysqli stmt num rows .3.9.22 mysqli stmt:: param count, mysqli stmt param count .3.9.23 mysqli stmt::prepare, mysqli stmt prepare .3.9.24 mysqli stmt::reset, mysqli stmt reset .3.9.25 mysqli stmt::result metadata, mysqli stmt result metadata .3.9.26 mysqli stmt::send long data, mysqli stmt send long data .3.9.27 mysqli stmt:: sqlstate, mysqli stmt sqlstate .3.9.28 mysqli stmt::store result, mysqli stmt store result .3.10 The mysqli result class .3.10.1 mysqli result:: current field, mysqli field tell .3.10.2 mysqli result::data seek, mysqli data seek .3.10.3 mysqli result::fetch all, mysqli fetch all .3.10.4 mysqli result::fetch array, mysqli fetch array .3.10.5 mysqli result::fetch assoc, mysqli fetch assoc .3.10.6 mysqli result::fetch field direct, mysqli fetch field direct .3.10.7 mysqli result::fetch field, mysqli fetch field .3.10.8 mysqli result::fetch fields, mysqli fetch fields .3.10.9 mysqli result::fetch object, mysqli fetch object .3.10.10 mysqli result::fetch row, mysqli fetch row .3.10.11 mysqli result:: field count, mysqli nu
This manual describes the PHP extensions and interfaces that can be used with MySQL. For legal information, see the Legal Notices. For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users. Document generated on: File Size: 2MBPage Count: 574
