PageRenderTime 44ms CodeModel.GetById 21ms RepoModel.GetById 0ms app.codeStats 0ms

/php/mysqlnduhconnection.query.html

https://bitbucket.org/thncr/manuals
HTML | 130 lines | 105 code | 25 blank | 0 comment | 0 complexity | ffb6a685848ed44672925ce3a192fba7 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>Performs a query on the database</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="mysqlnduhconnection.ping.html">MysqlndUhConnection::ping</a></div>
    10. 

  10.  <div class="next" style="text-align: right; float: right;"><a href="mysqlnduhconnection.queryreadresultsetheader.html">MysqlndUhConnection::queryReadResultsetHeader</a></div>
    11. 

  11.  <div class="up"><a href="class.mysqlnduhconnection.html">MysqlndUhConnection</a></div>
    12. 

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

  13. </div><hr /><div id="mysqlnduhconnection.query" class="refentry">
    14. 

  14.  <div class="refnamediv">
    15. 

  15.   <h1 class="refname">MysqlndUhConnection::query</h1>
    16. 

  16.   <p class="verinfo">(PECL mysqlnd-uh &gt;= 1.0.0-alpha)</p><p class="refpurpose"><span class="refname">MysqlndUhConnection::query</span> &mdash; <span class="dc-title">Performs a query on the database</span></p>
    17. 

  17. 

  18.  </div>
    19. 

  19. 

  20.  <div class="refsect1 description" id="refsect1-mysqlnduhconnection.query-description">
    21. 

  21.   <h3 class="title">说明</h3>
    22. 

  22.   <div class="methodsynopsis dc-description">
    23. 

  23.    <span class="modifier">public</span> <span class="type">bool</span> <span class="methodname"><strong>MysqlndUhConnection::query</strong></span>
    24. 

  24.     ( <span class="methodparam"><span class="type"><span class="type mysqlnd_connection">mysqlnd_connection</span></span> <code class="parameter">$connection</code></span>
    25. 

  25.    , <span class="methodparam"><span class="type">string</span> <code class="parameter">$query</code></span>
    26. 

  26.    )</div>
    27. 

  27. 

  28.   <p class="para rdfs-comment">
    29. 

  29.    Performs a query on the database (COM_QUERY).
    30. 

  30.   </p>
    31. 

  31.  </div>
    32. 

  32. 

  33. 

  34.  <div class="refsect1 parameters" id="refsect1-mysqlnduhconnection.query-parameters">
    35. 

  35.   <h3 class="title">参数</h3>
    36. 

  36.   <dl>
    37. 

  37. 

  38.    <dt>
    39. 

  39. 

  40.     <span class="term"><em><code class="parameter">connection</code></em></span>
    41. 

  41.     <dd>
    42. 

  42. 

  43.      <p class="para">
    44. 

  44.       Mysqlnd connection handle. Do not modify!
    45. 

  45.      </p>
    46. 

  46.     </dd>
    47. 

  47. 

  48.    </dt>
    49. 

  49. 

  50.    <dt>
    51. 

  51. 

  52.     <span class="term"><em><code class="parameter">query</code></em></span>
    53. 

  53.     <dd>
    54. 

  54. 

  55.      <p class="para">
    56. 

  56.       The query string.
    57. 

  57.      </p>
    58. 

  58.     </dd>
    59. 

  59. 

  60.    </dt>
    61. 

  61. 

  62.   </dl>
    63. 

  63. 

  64.  </div>
    65. 

  65. 

  66. 

  67.  <div class="refsect1 returnvalues" id="refsect1-mysqlnduhconnection.query-returnvalues">
    68. 

  68.   <h3 class="title">返回值</h3>
    69. 

  69.   <p class="para">
    70. 

  70.    Returns <strong><code>TRUE</code></strong> on success.
    71. 

  71.    Otherwise, returns <strong><code>FALSE</code></strong>
    72. 

  72.   </p>
    73. 

  73.  </div>
    74. 

  74. 

  75. 

  76.  <div class="refsect1 examples" id="refsect1-mysqlnduhconnection.query-examples">
    77. 

  77.   <h3 class="title">范例</h3>
    78. 

  78.   <p class="para">
    79. 

  79.    <div class="example" id="example-1920">
    80. 

  80.     <p><strong>Example #1  <span class="function"><strong>MysqlndUhConnection::query()</strong></span> example</strong></p>
    81. 

  81.         <div class="example-contents">
    82. 

  82. <div class="phpcode"><code><span style="color: #000000">
    83. 

  83. <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">query</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$query</span><span style="color: #007700">)&nbsp;{<br />&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;</span><span style="color: #0000BB">$query&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">"SELECT&nbsp;'How&nbsp;about&nbsp;query&nbsp;rewriting?'"</span><span style="color: #007700">;<br />&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">query</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$query</span><span style="color: #007700">);<br />&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;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">$res&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">$mysqli</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">query</span><span style="color: #007700">(</span><span style="color: #DD0000">"SELECT&nbsp;'Welcome&nbsp;mysqlnd_uh!'&nbsp;FROM&nbsp;DUAL"</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">var_dump</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">fetch_assoc</span><span style="color: #007700">());<br /></span><span style="color: #0000BB">?&gt;</span>
    84. 

  84. </span>
    85. 

  85. </code></div>
    86. 

  86.     </div>
    87. 

  87. 

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

  89.     <div class="example-contents screen">
    90. 

  90. <div class="cdata"><pre>
    91. 

  91. proxy::query(array (
    92. 

  92.   0 =&gt; NULL,
    93. 

  93.   1 =&gt; &#039;SELECT \&#039;Welcome mysqlnd_uh!\&#039; FROM DUAL&#039;,
    94. 

  94. ))
    95. 

  95. proxy::query returns true
    96. 

  96. array(1) {
    97. 

  97.   [&quot;How about query rewriting?&quot;]=&gt;
    98. 

  98.   string(26) &quot;How about query rewriting?&quot;
    99. 

  99. }
    100. 

  100. </pre></div>
    101. 

  101.     </div>
    102. 

  102.    </div>
    103. 

  103.   </p>
    104. 

  104.  </div>
    105. 

  105. 

  106. 

  107.  <div class="refsect1 seealso" id="refsect1-mysqlnduhconnection.query-seealso">
    108. 

  108.   <h3 class="title">参见</h3>
    109. 

  109.   <p class="para">
    110. 

  110.    <ul class="simplelist">
    111. 

  111.     <li class="member">
    112. 

  112.       <span class="function"><a href="function.mysqlnd-uh-set-connection-proxy.html" class="function" rel="rdfs-seeAlso">mysqlnd_uh_set_connection_proxy()</a> - Installs a proxy for mysqlnd connections</span>
    113. 

  113.     </li>
    114. 

  114.     <li class="member">
    115. 

  115.       <span class="function"><a href="mysqli.query.html" class="function" rel="rdfs-seeAlso">mysqli_query()</a> - Performs a query on the database</span>
    116. 

  116.     </li>
    117. 

  117.     <li class="member">
    118. 

  118.       <span class="function"><a href="function.mysql-query.html" class="function" rel="rdfs-seeAlso">mysql_query()</a> - 发送一条 MySQL 查询</span>
    119. 

  119.     </li>
    120. 

  120.    </ul>
    121. 

  121.   </p>
    122. 

  122.  </div>
    123. 

  123. 

  124. 

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

  126.  <div class="prev" style="text-align: left; float: left;"><a href="mysqlnduhconnection.ping.html">MysqlndUhConnection::ping</a></div>
    127. 

  127.  <div class="next" style="text-align: right; float: right;"><a href="mysqlnduhconnection.queryreadresultsetheader.html">MysqlndUhConnection::queryReadResultsetHeader</a></div>
    128. 

  128.  <div class="up"><a href="class.mysqlnduhconnection.html">MysqlndUhConnection</a></div>
    129. 

  129.  <div class="home"><a href="index.html">PHP Manual</a></div>
    130. 

  130. </div></body></html>
    131. 

  131.