PageRenderTime 58ms CodeModel.GetById 29ms RepoModel.GetById 0ms app.codeStats 0ms

/php/mysqlnduhpreparedstatement.execute.html

https://bitbucket.org/stillzhl/manuals
HTML | 113 lines | 90 code | 23 blank | 0 comment | 0 complexity | 66fa2377b34be3c12e852e2fec04e199 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>Executes a prepared Query</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="mysqlnduhpreparedstatement.construct.html">MysqlndUhPreparedStatement::__construct</a></div>
    10. 

  10.  <div class="next" style="text-align: right; float: right;"><a href="mysqlnduhpreparedstatement.prepare.html">MysqlndUhPreparedStatement::prepare</a></div>
    11. 

  11.  <div class="up"><a href="class.mysqlnduhpreparedstatement.html">MysqlndUhPreparedStatement</a></div>
    12. 

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

  13. </div><hr /><div id="mysqlnduhpreparedstatement.execute" class="refentry">
    14. 

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

  15.   <h1 class="refname">MysqlndUhPreparedStatement::execute</h1>
    16. 

  16.   <p class="verinfo">(PECL mysqlnd-uh &gt;= 1.0.0-alpha)</p><p class="refpurpose"><span class="refname">MysqlndUhPreparedStatement::execute</span> &mdash; <span class="dc-title">Executes a prepared Query</span></p>
    17. 

  17. 

  18.  </div>
    19. 

  19. 

  20.  <div class="refsect1 description" id="refsect1-mysqlnduhpreparedstatement.execute-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>MysqlndUhPreparedStatement::execute</strong></span>
    24. 

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

  25.    )</div>
    26. 

  26. 

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

  28.    Executes a prepared Query.
    29. 

  29.   </p>
    30. 

  30.  </div>
    31. 

  31. 

  32. 

  33.  <div class="refsect1 parameters" id="refsect1-mysqlnduhpreparedstatement.execute-parameters">
    34. 

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

  35.   <dl>
    36. 

  36. 

  37.    <dt>
    38. 

  38. 

  39.     <span class="term"><em><code class="parameter">statement</code></em></span>
    40. 

  40.     <dd>
    41. 

  41. 

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

  43.       Mysqlnd prepared statement handle. Do not modify!
    44. 

  44.       Resource of type <em>Mysqlnd Prepared Statement (internal only - you must not modify it!)</em>.
    45. 

  45.      </p>
    46. 

  46.     </dd>
    47. 

  47. 

  48.    </dt>
    49. 

  49. 

  50.   </dl>
    51. 

  51. 

  52.  </div>
    53. 

  53. 

  54. 

  55.  <div class="refsect1 returnvalues" id="refsect1-mysqlnduhpreparedstatement.execute-returnvalues">
    56. 

  56.   <h3 class="title">返回值</h3>
    57. 

  57.   <p class="para">
    58. 

  58.    Returns <strong><code>TRUE</code></strong> on success.
    59. 

  59.    Otherwise, returns <strong><code>FALSE</code></strong>
    60. 

  60.   </p>
    61. 

  61.  </div>
    62. 

  62. 

  63. 

  64.  <div class="refsect1 examples" id="refsect1-mysqlnduhpreparedstatement.execute-examples">
    65. 

  65.   <h3 class="title">范例</h3>
    66. 

  66.   <p class="para">
    67. 

  67.    <div class="example" id="example-1941">
    68. 

  68.     <p><strong>Example #1  <span class="function"><strong>MysqlndUhPreparedStatement::execute()</strong></span> example</strong></p>
    69. 

  69.         <div class="example-contents">
    70. 

  70. <div class="phpcode"><code><span style="color: #000000">
    71. 

  71. <span style="color: #0000BB">&lt;?php<br /></span><span style="color: #007700">class&nbsp;</span><span style="color: #0000BB">stmt_proxy&nbsp;</span><span style="color: #007700">extends&nbsp;</span><span style="color: #0000BB">MysqlndUhPreparedStatement&nbsp;</span><span style="color: #007700">{<br />&nbsp;public&nbsp;function&nbsp;</span><span style="color: #0000BB">execute</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</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("</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">__METHOD__</span><span style="color: #007700">);<br />&nbsp;&nbsp;</span><span style="color: #0000BB">var_dump</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">);<br />&nbsp;&nbsp;</span><span style="color: #0000BB">printf</span><span style="color: #007700">(</span><span style="color: #DD0000">")\n"</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">execute</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</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;</span><span style="color: #0000BB">var_dump</span><span style="color: #007700">(</span><span style="color: #0000BB">$ret</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_statement_proxy</span><span style="color: #007700">(new&nbsp;</span><span style="color: #0000BB">stmt_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">$stmt&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">$mysqli</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">prepare</span><span style="color: #007700">(</span><span style="color: #DD0000">"SELECT&nbsp;'Labskaus'&nbsp;AS&nbsp;_msg&nbsp;FROM&nbsp;DUAL"</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$stmt</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">execute</span><span style="color: #007700">();<br /></span><span style="color: #0000BB">$msg&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">NULL</span><span style="color: #007700">;<br /></span><span style="color: #0000BB">$stmt</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">bind_result</span><span style="color: #007700">(</span><span style="color: #0000BB">$msg</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$stmt</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">fetch</span><span style="color: #007700">();<br /></span><span style="color: #0000BB">var_dump</span><span style="color: #007700">(</span><span style="color: #0000BB">$msg</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">?&gt;</span>
    72. 

  72. </span>
    73. 

  73. </code></div>
    74. 

  74.     </div>
    75. 

  75. 

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

  77.     <div class="example-contents screen">
    78. 

  78. <div class="cdata"><pre>
    79. 

  79. stmt_proxy::execute(resource(256) of type (Mysqlnd Prepared Statement (internal only - you must not modify it!))
    80. 

  80. )
    81. 

  81. stmt_proxy::execute returns true
    82. 

  82. bool(true)
    83. 

  83. string(8) &quot;Labskaus&quot;
    84. 

  84. </pre></div>
    85. 

  85.     </div>
    86. 

  86.    </div>
    87. 

  87.   </p>
    88. 

  88.  </div>
    89. 

  89. 

  90. 

  91.  <div class="refsect1 seealso" id="refsect1-mysqlnduhpreparedstatement.execute-seealso">
    92. 

  92.   <h3 class="title">参见</h3>
    93. 

  93.   <p class="para">
    94. 

  94.    <ul class="simplelist">
    95. 

  95.     <li class="member">
    96. 

  96.       <span class="function"><a href="function.mysqlnd-uh-set-statement-proxy.html" class="function" rel="rdfs-seeAlso">mysqlnd_uh_set_statement_proxy()</a> - Installs a proxy for mysqlnd statements</span>
    97. 

  97.     </li>
    98. 

  98.     <li class="member">
    99. 

  99.       <span class="function"><a href="mysqli-stmt.execute.html" class="function" rel="rdfs-seeAlso">mysqli_stmt_execute()</a> - Executes a prepared Query</span>
    100. 

  100.     </li>
    101. 

  101.    </ul>
    102. 

  102.   </p>
    103. 

  103.  </div>
    104. 

  104. 

  105. 

  106. 

  107. 

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

  109.  <div class="prev" style="text-align: left; float: left;"><a href="mysqlnduhpreparedstatement.construct.html">MysqlndUhPreparedStatement::__construct</a></div>
    110. 

  110.  <div class="next" style="text-align: right; float: right;"><a href="mysqlnduhpreparedstatement.prepare.html">MysqlndUhPreparedStatement::prepare</a></div>
    111. 

  111.  <div class="up"><a href="class.mysqlnduhpreparedstatement.html">MysqlndUhPreparedStatement</a></div>
    112. 

  112.  <div class="home"><a href="index.html">PHP Manual</a></div>
    113. 

  113. </div></body></html>
    114. 

  114.