PageRenderTime 52ms CodeModel.GetById 17ms RepoModel.GetById 0ms app.codeStats 0ms

/php/mysqlnd-uh.quickstart.how-it-works.html

https://bitbucket.org/stillzhl/manuals
HTML | 106 lines | 103 code | 3 blank | 0 comment | 0 complexity | 176fb09a8308eafe299581b2a4437b02 MD5 | raw file
    

  1. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    2. 

  2. <html>
    3. 

  3.  <head>
    4. 

  4.   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
    5. 

  5.   <title>How it works</title>
    6. 

  6. 

  7.  </head>
    8. 

  8.  <body><div class="manualnavbar" style="text-align: center;">
    9. 

  9.  <div class="prev" style="text-align: left; float: left;"><a href="mysqlnd-uh.quickstart.configuration.html">Setup</a></div>
    10. 

  10.  <div class="next" style="text-align: right; float: right;"><a href="mysqlnd-uh.quickstart.proxy-installation.html">Installing a proxy</a></div>
    11. 

  11.  <div class="up"><a href="mysqlnd-uh.quickstart.html">Quickstart and Examples</a></div>
    12. 

  12.  <div class="home"><a href="index.html">PHP Manual</a></div>
    13. 

  13. </div><hr /><div id="mysqlnd-uh.quickstart.how-it-works" class="section">
    14. 

  14.   <h2 class="title">How it works</h2>
    15. 

  15.   <p class="para">
    16. 

  16.    This describes the background and inner workings of the mysqlnd_uh
    17. 

  17.    extension.
    18. 

  18.   </p>
    19. 

  19.   <p class="para">
    20. 

  20.    Two classes are provided by the extension: <a href="class.mysqlnduhconnection.html" class="classname">MysqlndUhConnection</a>
    21. 

  21.    and <a href="class.mysqlnduhpreparedstatement.html" class="classname">MysqlndUhPreparedStatement</a>. <a href="class.mysqlnduhconnection.html" class="classname">MysqlndUhConnection</a> lets
    22. 

  22.    you access almost all methods of the <em>mysqlnd</em>
    23. 

  23.    internal <em>connection</em> class. The latter exposes some selected
    24. 

  24.    methods of the  <em>mysqlnd</em> internal <em>statement</em> class.
    25. 

  25.    For example,  <span class="methodname"><a href="mysqlnduhconnection.connect.html" class="methodname">MysqlndUhConnection::connect()</a></span> maps to
    26. 

  26.    the <em>mysqlnd</em> library C function
    27. 

  27.    <em>mysqlnd_conn__connect</em>.
    28. 

  28.   </p>
    29. 

  29.   <p class="para">
    30. 

  30.    As a mysqlnd plugin, the PECL/mysqlnd_uh extension replaces <em>mysqlnd</em>
    31. 

  31.    library C functions with its own functions. Whenever a
    32. 

  32.    PHP MySQL extension compiled to use <em>mysqlnd</em> calls
    33. 

  33.    a mysqlnd function, the functions installed by the plugin are executed
    34. 

  34.    instead of the original <em>mysqlnd</em> ones. For example,
    35. 

  35.     <span class="function"><a href="function.mysqli-connect.html" class="function">mysqli_connect()</a></span> invokes <em>mysqlnd_conn__connect</em>,
    36. 

  36.    so the connect function installed by PECL/mysqlnd_uh will be called.
    37. 

  37.    The functions installed by PECL/mysqlnd_uh are the methods of the built-in classes.
    38. 

  38.   </p>
    39. 

  39.   <p class="para">
    40. 

  40.    The built-in PHP classes and their methods do nothing but call their
    41. 

  41.    <em>mysqlnd</em> C library counterparts, to behave exactly
    42. 

  42.    like the original <em>mysqlnd</em> function they replace.
    43. 

  43.    The code below illustrates in pseudo-code what the extension does.
    44. 

  44.   </p>
    45. 

  45.   <p class="para">
    46. 

  46.    <div class="example" id="example-1885">
    47. 

  47.     <p><strong>Example #1 Pseudo-code: what a built-in class does</strong></p>
    48. 

  48.     <div class="example-contents">
    49. 

  49. <div class="cdata"><pre>
    50. 

  50. class MysqlndUhConnection {
    51. 

  51.   public function connect(($conn, $host, $user, $passwd, $db, $port, $socket, $mysql_flags) {
    52. 

  52.     MYSQLND* c_mysqlnd_connection = convert_from_php_to_c($conn);
    53. 

  53.     ...
    54. 

  54.     return call_c_function(mysqlnd_conn__connect(c_mysqlnd_connection, ...));
    55. 

  55.   }
    56. 

  56. }
    57. 

  57. </pre></div>
    58. 

  58.     </div>
    59. 

  59. 

  60.     </div>
    61. 

  61.   </p>
    62. 

  62.   <p class="para">
    63. 

  63.    The build-in classes behave like a transparent proxy. It is possible for
    64. 

  64.    you to replace the proxy with your own. This is done by subclassing
    65. 

  65.    <a href="class.mysqlnduhconnection.html" class="classname">MysqlndUhConnection</a> or
    66. 

  66.    <a href="class.mysqlnduhpreparedstatement.html" class="classname">MysqlndUhPreparedStatement</a> to extend the functionality
    67. 

  67.    of the proxy, followed by registering a new proxy object.
    68. 

  68.    Proxy objects are installed by
    69. 

  69.     <span class="function"><a href="function.mysqlnd-uh-set-connection-proxy.html" class="function">mysqlnd_uh_set_connection_proxy()</a></span>
    70. 

  70.    and
    71. 

  71.     <span class="function"><a href="function.mysqlnd-uh-set-statement-proxy.html" class="function">mysqlnd_uh_set_statement_proxy()</a></span>.
    72. 

  72.   </p>
    73. 

  73.   <p class="para">
    74. 

  74.    <div class="example" id="example-1886">
    75. 

  75.     <p><strong>Example #2 Installing a proxy</strong></p>
    76. 

  76.         <div class="example-contents">
    77. 

  77. <div class="phpcode"><code><span style="color: #000000">
    78. 

  78. <span style="color: #0000BB">&lt;?php<br /></span><span style="color: #007700">class&nbsp;</span><span style="color: #0000BB">proxy&nbsp;</span><span style="color: #007700">extends&nbsp;</span><span style="color: #0000BB">MysqlndUhConnection&nbsp;</span><span style="color: #007700">{<br />&nbsp;public&nbsp;function&nbsp;</span><span style="color: #0000BB">connect</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$host</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$user</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$passwd</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$db</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$port</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$socket</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$mysql_flags</span><span style="color: #007700">)&nbsp;{<br />&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">printf</span><span style="color: #007700">(</span><span style="color: #DD0000">"%s(%s)\n"</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">__METHOD__</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">var_export</span><span style="color: #007700">(</span><span style="color: #0000BB">func_get_args</span><span style="color: #007700">(),&nbsp;</span><span style="color: #0000BB">true</span><span style="color: #007700">));<br />&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$ret&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">parent</span><span style="color: #007700">::</span><span style="color: #0000BB">connect</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$host</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$user</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$passwd</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$db</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$port</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$socket</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$mysql_flags</span><span style="color: #007700">);<br />&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">printf</span><span style="color: #007700">(</span><span style="color: #DD0000">"%s&nbsp;returns&nbsp;%s\n"</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">__METHOD__</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">var_export</span><span style="color: #007700">(</span><span style="color: #0000BB">$ret</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">true</span><span style="color: #007700">));<br />&nbsp;&nbsp;&nbsp;return&nbsp;</span><span style="color: #0000BB">$ret</span><span style="color: #007700">;<br />&nbsp;}<br />}<br /></span><span style="color: #0000BB">mysqlnd_uh_set_connection_proxy</span><span style="color: #007700">(new&nbsp;</span><span style="color: #0000BB">proxy</span><span style="color: #007700">());<br /><br /></span><span style="color: #0000BB">$mysqli&nbsp;</span><span style="color: #007700">=&nbsp;new&nbsp;</span><span style="color: #0000BB">mysqli</span><span style="color: #007700">(</span><span style="color: #DD0000">"localhost"</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"root"</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">""</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"test"</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">?&gt;</span>
    79. 

  79. </span>
    80. 

  80. </code></div>
    81. 

  81.     </div>
    82. 

  82. 

  83.     <div class="example-contents"><p>以上例程会输出：</p></div>
    84. 

  84.     <div class="example-contents screen">
    85. 

  85. <div class="cdata"><pre>
    86. 

  86. proxy::connect(array (
    87. 

  87.   0 =&gt; NULL,
    88. 

  88.   1 =&gt; &#039;localhost&#039;,
    89. 

  89.   2 =&gt; &#039;root&#039;,
    90. 

  90.   3 =&gt; &#039;&#039;,
    91. 

  91.   4 =&gt; &#039;test&#039;,
    92. 

  92.   5 =&gt; 3306,
    93. 

  93.   6 =&gt; NULL,
    94. 

  94.   7 =&gt; 131072,
    95. 

  95. ))
    96. 

  96. proxy::connect returns true
    97. 

  97. </pre></div>
    98. 

  98.     </div>
    99. 

  99.    </div>
    100. 

  100.   </p>
    101. 

  101.  </div><hr /><div class="manualnavbar" style="text-align: center;">
    102. 

  102.  <div class="prev" style="text-align: left; float: left;"><a href="mysqlnd-uh.quickstart.configuration.html">Setup</a></div>
    103. 

  103.  <div class="next" style="text-align: right; float: right;"><a href="mysqlnd-uh.quickstart.proxy-installation.html">Installing a proxy</a></div>
    104. 

  104.  <div class="up"><a href="mysqlnd-uh.quickstart.html">Quickstart and Examples</a></div>
    105. 

  105.  <div class="home"><a href="index.html">PHP Manual</a></div>
    106. 

  106. </div></body></html>
    107. 

  107.