MySQL and PHP
Pdf form change font size - C# PDF Field Edit Library: insert, delete, update pdf form field in C#.net, ASP.NET, MVC, Ajax, WPF
Online C# Tutorial to Insert, Delete and Update Fields in PDF Document
create a pdf form from excel; change font size in fillable pdf form
Pdf form change font size - VB.NET PDF Field Edit library: insert, delete, update pdf form field in vb.net, ASP.NET, MVC, Ajax, WPF
How to Insert, Delete and Update Fields in PDF Document with VB.NET Demo Code
changing font in pdf form; cannot save pdf form
Abstract
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 either the MySQL Forums or MySQL Mailing Lists, where you can discuss
your issues with other MySQL users.
For additional documentation on MySQL products, including translations of the documentation into other languages,
and downloadable versions in variety of formats, including HTML and PDF formats, see the MySQL Documentation
Library.
Document generated on: 2016-05-18 (revision: 47780)
C# PDF File Compress Library: Compress reduce PDF size in C#.net
Flatten form fields. outputFilePath = Program.RootPath + "\\" 3_optimized.pdf"; // create optimizing TargetResolution = 150F; // to change image compression
pdf form save with reader; add form fields to pdf without acrobat
VB.NET PDF File Compress Library: Compress reduce PDF size in vb.
Flatten form fields. outputFilePath = Program.RootPath + "\\" 3_optimized.pdf"; 'create optimizing TargetResolution = 150.0F 'to change image compression
add email button to pdf form; create a fillable pdf form in word
iii
Table of Contents
Preface and Legal Notices............................................................................................................... . xiii
1 Introduction to the MySQL PHP API................................................................................................ . 1
2 Overview of the MySQL PHP drivers............................................................................................... . 3
2.1 Introduction.......................................................................................................................... . 3
2.2 Terminology overview........................................................................................................... . 3
2.3 Choosing an API.................................................................................................................. . 4
2.4 Choosing a library................................................................................................................ . 6
2.5 Concepts..............................................................................................................................7
2.5.1 Buffered and Unbuffered queries................................................................................ . 7
2.5.2 Character sets........................................................................................................... 9
3 MySQL Improved Extension...........................................................................................................11
3.1 Overview............................................................................................................................ . 14
3.2 Quick start guide................................................................................................................ . 18
3.2.1 Dual procedural and object-oriented interface............................................................18
3.2.2 Connections.............................................................................................................20
3.2.3 Executing statements............................................................................................... . 22
3.2.4 Prepared Statements............................................................................................... . 26
3.2.5 Stored Procedures................................................................................................... . 33
3.2.6 Multiple Statements................................................................................................. 38
3.2.7 API support for transactions..................................................................................... . 39
3.2.8 Metadata................................................................................................................. . 40
3.3 Installing/Configuring...........................................................................................................42
3.3.1 Requirements.......................................................................................................... . 42
3.3.2 Installation............................................................................................................... . 42
3.3.3 Runtime Configuration..............................................................................................44
3.3.4 Resource Types...................................................................................................... 46
3.4 The mysqli Extension and Persistent Connections................................................................46
3.5 Predefined Constants......................................................................................................... 47
3.6 Notes................................................................................................................................. . 50
3.7 The MySQLi Extension Function Summary.......................................................................... . 51
3.8 Examples........................................................................................................................... . 57
3.8.1 MySQLi extension basic examples........................................................................... 57
3.9 The mysqli class................................................................................................................ 59
3.9.1 mysqli::$affected_rowsmysqli_affected_rows......................................... . 62
3.9.2 mysqli::autocommitmysqli_autocommit....................................................... . 65
3.9.3 mysqli::begin_transaction, mysqli_begin_transaction........................... . 66
3.9.4 mysqli::change_usermysqli_change_user................................................... . 68
3.9.5 mysqli::character_set_namemysqli_character_set_name....................... 71
3.9.6 mysqli::$client_infomysqli_get_client_info......................................... . 72
3.9.7 mysqli::$client_version, mysqli_get_client_version............................. . 73
3.9.8 mysqli::close, mysqli_close........................................................................... . 74
3.9.9 mysqli::commit, mysqli_commit....................................................................... . 75
3.9.10 mysqli::$connect_errnomysqli_connect_errno....................................... 77
3.9.11 mysqli::$connect_errormysqli_connect_error....................................... 78
3.9.12 mysqli::__constructmysqli_connect......................................................... . 80
3.9.13 mysqli::debug, mysqli_debug......................................................................... . 83
3.9.14 mysqli::dump_debug_infomysqli_dump_debug_info..................................84
3.9.15 mysqli::$errnomysqli_errno....................................................................... . 85
3.9.16 mysqli::$error_list, mysqli_error_list................................................... . 87
3.9.17 mysqli::$errormysqli_error....................................................................... . 88
3.9.18 mysqli::$field_countmysqli_field_count............................................... 90
C# PDF insert text Library: insert text into PDF content in C#.net
Powerful .NET PDF edit control allows modify existing scanned PDF text. Ability to change text font, color, size and location and output a new PDF document.
cannot save pdf form in reader; change text size pdf form
C# PDF Annotate Library: Draw, edit PDF annotation, markups in C#.
Able to edit and change PDF annotation properties such as font size or color. Abilities to draw markups on PDF document or stamp on PDF file.
change font pdf fillable form; create a fillable pdf form from a pdf
MySQL and PHP
iv
3.9.19 mysqli::get_charset, mysqli_get_charset................................................. . 92
3.9.20 mysqli::get_client_infomysqli_get_client_info..................................93
3.9.21 mysqli_get_client_stats............................................................................... . 94
3.9.22 mysqli_get_client_versionmysqli::$client_version............................97
3.9.23 mysqli::get_connection_statsmysqli_get_connection_stats..............97
3.9.24 mysqli::$host_infomysqli_get_host_info..............................................100
3.9.25 mysqli::$protocol_versionmysqli_get_proto_info..............................102
3.9.26 mysqli::$server_infomysqli_get_server_info......................................103
3.9.27 mysqli::$server_versionmysqli_get_server_version..........................105
3.9.28 mysqli::get_warningsmysqli_get_warnings............................................106
3.9.29 mysqli::$info, mysqli_info......................................................................... 107
3.9.30 mysqli::init, mysqli_init........................................................................... 108
3.9.31 mysqli::$insert_idmysqli_insert_id......................................................109
3.9.32 mysqli::kill, mysqli_kill........................................................................... 111
3.9.33 mysqli::more_resultsmysqli_more_results............................................113
3.9.34 mysqli::multi_querymysqli_multi_query................................................114
3.9.35 mysqli::next_resultmysqli_next_result................................................116
3.9.36 mysqli::optionsmysqli_options............................................................... 117
3.9.37 mysqli::ping, mysqli_ping........................................................................... 118
3.9.38 mysqli::poll, mysqli_poll........................................................................... 120
3.9.39 mysqli::preparemysqli_prepare............................................................... 122
3.9.40 mysqli::querymysqli_query....................................................................... 124
3.9.41 mysqli::real_connectmysqli_real_connect............................................127
3.9.42 mysqli::real_escape_stringmysqli_real_escape_string....................131
3.9.43 mysqli::real_query, mysqli_real_query....................................................134
3.9.44 mysqli::reap_async_querymysqli_reap_async_query............................134
3.9.45 mysqli::refreshmysqli_refresh............................................................... 135
3.9.46 mysqli::release_savepointmysqli_release_savepoint........................136
3.9.47 mysqli::rollbackmysqli_rollback........................................................... 136
3.9.48 mysqli::rpl_query_typemysqli_rpl_query_type....................................139
3.9.49 mysqli::savepointmysqli_savepoint........................................................140
3.9.50 mysqli::select_dbmysqli_select_db........................................................140
3.9.51 mysqli::send_query, mysqli_send_query....................................................142
3.9.52 mysqli::set_charsetmysqli_set_charset................................................143
3.9.53 mysqli::set_local_infile_default,
mysqli_set_local_infile_default........................................................................ 145
3.9.54 mysqli::set_local_infile_handler,
mysqli_set_local_infile_handler........................................................................ 145
3.9.55 mysqli::$sqlstatemysqli_sqlstate......................................................... 148
3.9.56 mysqli::ssl_setmysqli_ssl_set............................................................... 150
3.9.57 mysqli::stat, mysqli_stat........................................................................... 151
3.9.58 mysqli::stmt_initmysqli_stmt_init........................................................152
3.9.59 mysqli::store_resultmysqli_store_result............................................153
3.9.60 mysqli::$thread_idmysqli_thread_id......................................................154
3.9.61 mysqli::thread_safemysqli_thread_safe................................................156
3.9.62 mysqli::use_result, mysqli_use_result....................................................156
3.9.63 mysqli::$warning_countmysqli_warning_count......................................159
3.10 The mysqli_stmt class.....................................................................................................161
3.10.1 mysqli_stmt::$affected_rowsmysqli_stmt_affected_rows..................162
3.10.2 mysqli_stmt::attr_getmysqli_stmt_attr_get........................................164
3.10.3 mysqli_stmt::attr_setmysqli_stmt_attr_set........................................165
3.10.4 mysqli_stmt::bind_parammysqli_stmt_bind_param................................166
3.10.5 mysqli_stmt::bind_resultmysqli_stmt_bind_result............................169
3.10.6 mysqli_stmt::close, mysqli_stmt_close....................................................171
C# PDF Sticky Note Library: add, delete, update PDF note in C#.net
Allow users to add comments online in ASPX webpage. Able to change font size in PDF comment box. Able to save and print sticky notes in PDF file.
add picture to pdf form; change font in pdf form
C# PDF Convert to Word SDK: Convert PDF to Word library in C#.net
PDF document, keeps the elements (like images, tables and chats) of original PDF file and maintains the original text style (including font, size, color, links
add editable fields to pdf; add attachment to pdf form
MySQL and PHP
v
3.10.7 mysqli_stmt::__construct........................................................................... 172
3.10.8 mysqli_stmt::data_seekmysqli_stmt_data_seek....................................172
3.10.9 mysqli_stmt::$errno, mysqli_stmt_errno..................................................175
3.10.10 mysqli_stmt::$error_list, mysqli_stmt_error_list............................ . 177
3.10.11 mysqli_stmt::$error, mysqli_stmt_error................................................179
3.10.12 mysqli_stmt::executemysqli_stmt_execute..........................................181
3.10.13 mysqli_stmt::fetch, mysqli_stmt_fetch..................................................184
3.10.14 mysqli_stmt::$field_count, mysqli_stmt_field_count........................ . 186
3.10.15 mysqli_stmt::free_result, mysqli_stmt_free_result.......................... . 186
3.10.16 mysqli_stmt::get_result, mysqli_stmt_get_result.............................. . 187
3.10.17 mysqli_stmt::get_warningsmysqli_stmt_get_warnings...................... . 189
3.10.18 mysqli_stmt::$insert_id, mysqli_stmt_insert_id................................ . 190
3.10.19 mysqli_stmt::more_resultsmysqli_stmt_more_results...................... . 190
3.10.20 mysqli_stmt::next_result, mysqli_stmt_next_result.......................... . 191
3.10.21 mysqli_stmt::$num_rowsmysqli_stmt_num_rows....................................192
3.10.22 mysqli_stmt::$param_count, mysqli_stmt_param_count........................ . 194
3.10.23 mysqli_stmt::preparemysqli_stmt_prepare..........................................195
3.10.24 mysqli_stmt::reset, mysqli_stmt_reset..................................................198
3.10.25 mysqli_stmt::result_metadatamysqli_stmt_result_metadata.......... . 199
3.10.26 mysqli_stmt::send_long_datamysqli_stmt_send_long_data.............. . 201
3.10.27 mysqli_stmt::$sqlstatemysqli_stmt_sqlstate....................................202
3.10.28 mysqli_stmt::store_resultmysqli_stmt_store_result...................... . 204
3.11 The mysqli_result class................................................................................................... . 207
3.11.1 mysqli_result::$current_fieldmysqli_field_tell..............................208
3.11.2 mysqli_result::data_seekmysqli_data_seek..........................................210
3.11.3 mysqli_result::fetch_allmysqli_fetch_all..........................................212
3.11.4 mysqli_result::fetch_arraymysqli_fetch_array..................................213
3.11.5 mysqli_result::fetch_assocmysqli_fetch_assoc..................................215
3.11.6 mysqli_result::fetch_field_direct, mysqli_fetch_field_direct...... . 218
3.11.7 mysqli_result::fetch_fieldmysqli_fetch_field..................................221
3.11.8 mysqli_result::fetch_fieldsmysqli_fetch_fields..............................223
3.11.9 mysqli_result::fetch_objectmysqli_fetch_object..............................226
3.11.10 mysqli_result::fetch_rowmysqli_fetch_row........................................229
3.11.11 mysqli_result::$field_count, mysqli_num_fields................................ . 231
3.11.12 mysqli_result::field_seekmysqli_field_seek....................................232
3.11.13 mysqli_result::free, mysqli_free_result..............................................234
3.11.14 mysqli_result::$lengthsmysqli_fetch_lengths..................................235
3.11.15 mysqli_result::$num_rowsmysqli_num_rows..........................................237
3.12 The mysqli_driver class...................................................................................................239
3.12.1 mysqli_driver::embedded_server_endmysqli_embedded_server_end.. . 240
3.12.2 mysqli_driver::embedded_server_start,
mysqli_embedded_server_start.............................................................................. 240
3.12.3 mysqli_driver::$report_modemysqli_report..........................................241
3.13 The mysqli_warning class............................................................................................... 243
3.13.1 mysqli_warning::__construct......................................................................244
3.13.2 mysqli_warning::next................................................................................... 244
3.14 The mysqli_sql_exception class.......................................................................................244
3.15 Aliases and deprecated Mysqli Functions.........................................................................245
3.15.1 mysqli_bind_param......................................................................................... 245
3.15.2 mysqli_bind_result....................................................................................... 245
3.15.3 mysqli_client_encoding............................................................................... 246
3.15.4 mysqli_connect............................................................................................... 246
3.15.5 mysqli::disable_reads_from_master,
mysqli_disable_reads_from_master...................................................................... 247
Generate Barcodes in Web Image Viewer| Online Tutorials
Change Barcode Properties. RasterEdge OCR Engine; PDF Reading; Encode & Decode JBIG 2 Files; Compress & Twain Scanning; DICOM Reading; Form Recognition & Processing
create a pdf form that can be filled out; pdf save form data
VB.NET Image: Visual Basic .NET Guide to Draw Text on Image in .
for example, a VB.NET Windows Form application. Please note that you can change some of the provide powerful & profession imaging controls, PDF document, image
pdf editable fields; create pdf forms
MySQL and PHP
vi
3.15.6 mysqli_disable_rpl_parse........................................................................... 247
3.15.7 mysqli_enable_reads_from_master..............................................................248
3.15.8 mysqli_enable_rpl_parse............................................................................. 248
3.15.9 mysqli_escape_string................................................................................... 248
3.15.10 mysqli_execute..............................................................................................249
3.15.11 mysqli_fetch..................................................................................................249
3.15.12 mysqli_get_cache_stats..............................................................................249
3.15.13 mysqli_get_links_stats..............................................................................250
3.15.14 mysqli_get_metadata....................................................................................250
3.15.15 mysqli_master_query....................................................................................251
3.15.16 mysqli_param_count......................................................................................251
3.15.17 mysqli_report................................................................................................252
3.15.18 mysqli_rpl_parse_enabled..........................................................................252
3.15.19 mysqli_rpl_probe..........................................................................................252
3.15.20 mysqli_send_long_data................................................................................252
3.15.21 mysqli::set_opt, mysqli_set_opt..............................................................253
3.15.22 mysqli_slave_query......................................................................................253
3.16 Changelog...................................................................................................................... . 253
4 MySQL Functions (PDO_MYSQL)................................................................................................ . 255
4.1 PDO_MYSQL DSN............................................................................................................. . 258
5 Original MySQL API.................................................................................................................... . 261
5.1 Installing/Configuring......................................................................................................... . 262
5.1.1 Requirements........................................................................................................ 262
5.1.2 Installation............................................................................................................. . 262
5.1.3 Runtime Configuration............................................................................................264
5.1.4 Resource Types.....................................................................................................265
5.2 Changelog........................................................................................................................ . 265
5.3 Predefined Constants........................................................................................................266
5.4 Examples......................................................................................................................... 267
5.4.1 MySQL extension overview example.......................................................................267
5.5 MySQL Functions............................................................................................................. . 267
5.5.1 mysql_affected_rows....................................................................................... . 268
5.5.2 mysql_client_encoding................................................................................... . 270
5.5.3 mysql_close....................................................................................................... . 271
5.5.4 mysql_connect................................................................................................... . 272
5.5.5 mysql_create_db............................................................................................... . 275
5.5.6 mysql_data_seek............................................................................................... . 277
5.5.7 mysql_db_name................................................................................................... . 278
5.5.8 mysql_db_query................................................................................................. . 279
5.5.9 mysql_drop_db................................................................................................... . 281
5.5.10 mysql_errno..................................................................................................... 283
5.5.11 mysql_error..................................................................................................... 284
5.5.12 mysql_escape_string..................................................................................... 285
5.5.13 mysql_fetch_array......................................................................................... 286
5.5.14 mysql_fetch_assoc......................................................................................... 289
5.5.15 mysql_fetch_field......................................................................................... 291
5.5.16 mysql_fetch_lengths..................................................................................... 293
5.5.17 mysql_fetch_object....................................................................................... 294
5.5.18 mysql_fetch_row............................................................................................. 296
5.5.19 mysql_field_flags......................................................................................... 297
5.5.20 mysql_field_len............................................................................................. 298
5.5.21 mysql_field_name........................................................................................... 300
5.5.22 mysql_field_seek........................................................................................... 301
5.5.23 mysql_field_table......................................................................................... 302
Generate Image in .NET Winforms Imaging Viewer| Online Tutorials
Change Barcode Properties. Multi-page Tiff Processing; RasterEdge OCR Engine; PDF Reading; Encode & JPEG 2000 Files; Twain Scanning; DICOM Reading; Form Recognition
create a fillable pdf form; change tab order in pdf form
MySQL and PHP
vii
5.5.24 mysql_field_type........................................................................................... 303
5.5.25 mysql_free_result......................................................................................... 305
5.5.26 mysql_get_client_info................................................................................. 306
5.5.27 mysql_get_host_info..................................................................................... 307
5.5.28 mysql_get_proto_info................................................................................... 308
5.5.29 mysql_get_server_info................................................................................. 309
5.5.30 mysql_info....................................................................................................... 310
5.5.31 mysql_insert_id............................................................................................. 311
5.5.32 mysql_list_dbs............................................................................................... 313
5.5.33 mysql_list_fields......................................................................................... 314
5.5.34 mysql_list_processes................................................................................... 316
5.5.35 mysql_list_tables......................................................................................... 317
5.5.36 mysql_num_fields........................................................................................... 319
5.5.37 mysql_num_rows............................................................................................... 320
5.5.38 mysql_pconnect............................................................................................... 321
5.5.39 mysql_ping....................................................................................................... 323
5.5.40 mysql_query..................................................................................................... 324
5.5.41 mysql_real_escape_string........................................................................... 326
5.5.42 mysql_result................................................................................................... 329
5.5.43 mysql_select_db............................................................................................. 330
5.5.44 mysql_set_charset......................................................................................... 332
5.5.45 mysql_stat....................................................................................................... 333
5.5.46 mysql_tablename............................................................................................. 334
5.5.47 mysql_thread_id............................................................................................. 336
5.5.48 mysql_unbuffered_query............................................................................... 337
6 MySQL Native Driver...................................................................................................................339
6.1 Overview.......................................................................................................................... . 339
6.2 Installation........................................................................................................................ . 340
6.3 Runtime Configuration.......................................................................................................341
6.4 Incompatibilities................................................................................................................ . 346
6.5 Persistent Connections..................................................................................................... 346
6.6 Statistics...........................................................................................................................346
6.7 Notes............................................................................................................................... . 360
6.8 Memory management....................................................................................................... . 361
6.9 MySQL Native Driver Plugin API....................................................................................... . 362
6.9.1 A comparison of mysqlnd plugins with MySQL Proxy............................................... . 364
6.9.2 Obtaining the mysqlnd plugin API........................................................................... . 364
6.9.3 MySQL Native Driver Plugin Architecture................................................................ . 365
6.9.4 The mysqlnd plugin API......................................................................................... . 370
6.9.5 Getting started building a mysqlnd plugin................................................................ . 372
7 Mysqlnd replication and load balancing plugin.............................................................................. 377
7.1 Key Features....................................................................................................................378
7.2 Limitations........................................................................................................................ . 380
7.3 On the name.................................................................................................................... 380
7.4 Quickstart and Examples.................................................................................................. 380
7.4.1 Setup.................................................................................................................... 380
7.4.2 Running statements............................................................................................... . 383
7.4.3 Connection state.................................................................................................... . 384
7.4.4 SQL Hints..............................................................................................................386
7.4.5 Local transactions.................................................................................................. . 388
7.4.6 XA/Distributed Transactions....................................................................................391
7.4.7 Service level and consistency.................................................................................394
7.4.8 Global transaction IDs............................................................................................ . 398
7.4.9 Cache integration...................................................................................................404
MySQL and PHP
viii
7.4.10 Failover................................................................................................................407
7.4.11 Partitioning and Sharding..................................................................................... 408
7.4.12 MySQL Fabric......................................................................................................410
7.5 Concepts.......................................................................................................................... . 411
7.5.1 Architecture........................................................................................................... 411
7.5.2 Connection pooling and switching........................................................................... . 412
7.5.3 Local transaction handling...................................................................................... . 414
7.5.4 Error handling........................................................................................................ 415
7.5.5 Transient errors..................................................................................................... 418
7.5.6 Failover................................................................................................................. 420
7.5.7 Load balancing...................................................................................................... . 421
7.5.8 Read-write splitting.................................................................................................422
7.5.9 Filter......................................................................................................................422
7.5.10 Service level and consistency............................................................................... . 424
7.5.11 Global transaction IDs.......................................................................................... . 426
7.5.12 Cache integration................................................................................................. . 428
7.5.13 Supported clusters............................................................................................... . 430
7.5.14 XA/Distributed transactions................................................................................... . 434
7.6 Installing/Configuring......................................................................................................... . 436
7.6.1 Requirements........................................................................................................ 436
7.6.2 Installation............................................................................................................. . 437
7.6.3 Runtime Configuration............................................................................................437
7.6.4 Plugin configuration file (>=1.1.x)............................................................................438
7.7 Predefined Constants........................................................................................................496
7.8 Mysqlnd_ms Functions......................................................................................................498
7.8.1 mysqlnd_ms_dump_servers............................................................................... 498
7.8.2 mysqlnd_ms_fabric_select_global............................................................... 500
7.8.3 mysqlnd_ms_fabric_select_shard................................................................. 501
7.8.4 mysqlnd_ms_get_last_gtid............................................................................. 501
7.8.5 mysqlnd_ms_get_last_used_connection....................................................... 503
7.8.6 mysqlnd_ms_get_stats..................................................................................... . 504
7.8.7 mysqlnd_ms_match_wild................................................................................... . 510
7.8.8 mysqlnd_ms_query_is_select......................................................................... 511
7.8.9 mysqlnd_ms_set_qos......................................................................................... . 513
7.8.10 mysqlnd_ms_set_user_pick_server..............................................................515
7.8.11 mysqlnd_ms_xa_begin..................................................................................... 518
7.8.12 mysqlnd_ms_xa_commit................................................................................... 519
7.8.13 mysqlnd_ms_xa_gc........................................................................................... 520
7.8.14 mysqlnd_ms_xa_rollback............................................................................... 521
7.9 Change History.................................................................................................................522
7.9.1 PECL/mysqlnd_ms 1.6 series................................................................................. . 522
7.9.2 PECL/mysqlnd_ms 1.5 series................................................................................. . 524
7.9.3 PECL/mysqlnd_ms 1.4 series................................................................................. . 526
7.9.4 PECL/mysqlnd_ms 1.3 series................................................................................. . 527
7.9.5 PECL/mysqlnd_ms 1.2 series................................................................................. . 527
7.9.6 PECL/mysqlnd_ms 1.1 series................................................................................. . 529
7.9.7 PECL/mysqlnd_ms 1.0 series................................................................................. . 530
8 Mysqlnd query result cache plugin............................................................................................... . 531
8.1 Key Features....................................................................................................................532
8.2 Limitations........................................................................................................................ . 532
8.3 On the name.................................................................................................................... 532
8.4 Quickstart and Examples.................................................................................................. 532
8.4.1 Architecture and Concepts..................................................................................... 533
8.4.2 Setup.................................................................................................................... 534
MySQL and PHP
ix
8.4.3 Caching queries.....................................................................................................534
8.4.4 Setting the TTL......................................................................................................539
8.4.5 Pattern based caching........................................................................................... 541
8.4.6 Slam defense........................................................................................................ 543
8.4.7 Finding cache candidates....................................................................................... . 543
8.4.8 Measuring cache efficiency.....................................................................................546
8.4.9 Beyond TTL: user-defined storage.......................................................................... . 552
8.5 Installing/Configuring......................................................................................................... . 556
8.5.1 Requirements........................................................................................................ 556
8.5.2 Installation............................................................................................................. . 556
8.5.3 Runtime Configuration............................................................................................556
8.6 Predefined Constants........................................................................................................558
8.7 mysqlnd_qc Functions.......................................................................................................560
8.7.1 mysqlnd_qc_clear_cache................................................................................. 560
8.7.2 mysqlnd_qc_get_available_handlers........................................................... 561
8.7.3 mysqlnd_qc_get_cache_info........................................................................... 562
8.7.4 mysqlnd_qc_get_core_stats........................................................................... 568
8.7.5 mysqlnd_qc_get_normalized_query_trace_log........................................... 573
8.7.6 mysqlnd_qc_get_query_trace_log................................................................. 576
8.7.7 mysqlnd_qc_set_cache_condition................................................................. 580
8.7.8 mysqlnd_qc_set_is_select............................................................................. 581
8.7.9 mysqlnd_qc_set_storage_handler................................................................. 583
8.7.10 mysqlnd_qc_set_user_handlers....................................................................584
8.8 Change History.................................................................................................................585
8.8.1 PECL/mysqlnd_qc 1.2 series.................................................................................. . 585
8.8.2 PECL/mysqlnd_qc 1.1 series.................................................................................. . 585
8.8.3 PECL/mysqlnd_qc 1.0 series.................................................................................. . 586
9 Mysqlnd user handler plugin........................................................................................................ . 589
9.1 Security considerations..................................................................................................... . 591
9.2 Documentation note.......................................................................................................... . 591
9.3 On the name.................................................................................................................... 591
9.4 Quickstart and Examples.................................................................................................. 591
9.4.1 Setup.................................................................................................................... 592
9.4.2 How it works..........................................................................................................592
9.4.3 Installing a proxy....................................................................................................593
9.4.4 Basic query monitoring...........................................................................................595
9.5 Installing/Configuring......................................................................................................... . 596
9.5.1 Requirements........................................................................................................ 597
9.5.2 Installation............................................................................................................. . 597
9.5.3 Runtime Configuration............................................................................................597
9.5.4 Resource Types.....................................................................................................597
9.6 Predefined Constants........................................................................................................597
9.7 The MysqlndUhConnection class.......................................................................................603
9.7.1 MysqlndUhConnection::changeUser............................................................... 606
9.7.2 MysqlndUhConnection::charsetName............................................................. 607
9.7.3 MysqlndUhConnection::close......................................................................... 608
9.7.4 MysqlndUhConnection::connect..................................................................... 610
9.7.5 MysqlndUhConnection::__construct............................................................. 611
9.7.6 MysqlndUhConnection::endPSession............................................................. 612
9.7.7 MysqlndUhConnection::escapeString........................................................... 613
9.7.8 MysqlndUhConnection::getAffectedRows..................................................... 614
9.7.9 MysqlndUhConnection::getErrorNumber....................................................... 615
9.7.10 MysqlndUhConnection::getErrorString......................................................616
9.7.11 MysqlndUhConnection::getFieldCount........................................................617
MySQL and PHP
x
9.7.12 MysqlndUhConnection::getHostInformation..............................................618
9.7.13 MysqlndUhConnection::getLastInsertId....................................................619
9.7.14 MysqlndUhConnection::getLastMessage......................................................621
9.7.15 MysqlndUhConnection::getProtocolInformation......................................622
9.7.16 MysqlndUhConnection::getServerInformation..........................................623
9.7.17 MysqlndUhConnection::getServerStatistics............................................624
9.7.18 MysqlndUhConnection::getServerVersion..................................................625
9.7.19 MysqlndUhConnection::getSqlstate............................................................626
9.7.20 MysqlndUhConnection::getStatistics........................................................627
9.7.21 MysqlndUhConnection::getThreadId............................................................635
9.7.22 MysqlndUhConnection::getWarningCount....................................................636
9.7.23 MysqlndUhConnection::init......................................................................... 637
9.7.24 MysqlndUhConnection::killConnection......................................................638
9.7.25 MysqlndUhConnection::listFields..............................................................639
9.7.26 MysqlndUhConnection::listMethod..............................................................640
9.7.27 MysqlndUhConnection::moreResults............................................................642
9.7.28 MysqlndUhConnection::nextResult..............................................................643
9.7.29 MysqlndUhConnection::ping......................................................................... 645
9.7.30 MysqlndUhConnection::query....................................................................... 646
9.7.31 MysqlndUhConnection::queryReadResultsetHeader..................................647
9.7.32 MysqlndUhConnection::reapQuery................................................................648
9.7.33 MysqlndUhConnection::refreshServer........................................................650
9.7.34 MysqlndUhConnection::restartPSession....................................................651
9.7.35 MysqlndUhConnection::selectDb..................................................................652
9.7.36 MysqlndUhConnection::sendClose................................................................653
9.7.37 MysqlndUhConnection::sendQuery................................................................654
9.7.38 MysqlndUhConnection::serverDumpDebugInformation..............................655
9.7.39 MysqlndUhConnection::setAutocommit........................................................656
9.7.40 MysqlndUhConnection::setCharset..............................................................657
9.7.41 MysqlndUhConnection::setClientOption....................................................658
9.7.42 MysqlndUhConnection::setServerOption....................................................660
9.7.43 MysqlndUhConnection::shutdownServer......................................................661
9.7.44 MysqlndUhConnection::simpleCommand........................................................662
9.7.45 MysqlndUhConnection::simpleCommandHandleResponse............................664
9.7.46 MysqlndUhConnection::sslSet......................................................................666
9.7.47 MysqlndUhConnection::stmtInit..................................................................668
9.7.48 MysqlndUhConnection::storeResult............................................................669
9.7.49 MysqlndUhConnection::txCommit..................................................................670
9.7.50 MysqlndUhConnection::txRollback..............................................................671
9.7.51 MysqlndUhConnection::useResult................................................................672
9.8 The MysqlndUhPreparedStatement class........................................................................... . 673
9.8.1 MysqlndUhPreparedStatement::__construct............................................... 674
9.8.2 MysqlndUhPreparedStatement::execute....................................................... 674
9.8.3 MysqlndUhPreparedStatement::prepare....................................................... 675
9.9 Mysqlnd_uh Functions...................................................................................................... 676
9.9.1 mysqlnd_uh_convert_to_mysqlnd................................................................... 676
9.9.2 mysqlnd_uh_set_connection_proxy............................................................... 678
9.9.3 mysqlnd_uh_set_statement_proxy................................................................. 679
9.10 Change History............................................................................................................... . 680
9.10.1 PECL/mysqlnd_uh 1.0 series................................................................................ . 680
10 Mysqlnd connection multiplexing plugin...................................................................................... 681
10.1 Key Features.................................................................................................................. . 681
10.2 Limitations...................................................................................................................... . 682
10.3 About the name mysqlnd_mux........................................................................................ 682
Documents you may be interested
Documents you may be interested