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

/php/mysqli-stmt.param-count.html

https://bitbucket.org/thncr/manuals
HTML | 110 lines | 90 code | 20 blank | 0 comment | 0 complexity | 46cf8ee366af00b9bb14337d2045f48f 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>Returns the number of parameter for the given statement</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="mysqli-stmt.num-rows.html">mysqli_stmt::$num_rows</a></div>
    10. 

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

  11.  <div class="up"><a href="class.mysqli-stmt.html">MySQLi_STMT</a></div>
    12. 

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

  13. </div><hr /><div id="mysqli-stmt.param-count" class="refentry">
    14. 

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

  15.   <h1 class="refname">mysqli_stmt::$param_count</h1>
    16. 

  16.   <h1 class="refname">mysqli_stmt_param_count</h1>
    17. 

  17.   <p class="verinfo">(PHP 5)</p><p class="refpurpose"><span class="refname">mysqli_stmt::$param_count</span> -- <span class="refname">mysqli_stmt_param_count</span> &mdash; <span class="dc-title">Returns the number of parameter for the given statement</span></p>
    18. 

  18. 

  19.  </div>
    20. 

  20. 

  21.  <div class="refsect1 description" id="refsect1-mysqli-stmt.param-count-description">
    22. 

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

  23.   <p class="para">面向对象风格</p>
    24. 

  24.   <div class="fieldsynopsis"><span class="type">int</span> <var class="varname"><a href="mysqli-stmt.param-count.html">$mysqli_stmt-&gt;param_count</a></var>;</div>
    25. 

  25. 

  26.   <p class="para">过程化风格</p>
    27. 

  27.   <div class="methodsynopsis dc-description">
    28. 

  28.    <span class="type">int</span> <span class="methodname"><strong>mysqli_stmt_param_count</strong></span>
    29. 

  29.     ( <span class="methodparam"><span class="type"><a href="class.mysqli-stmt.html" class="type mysqli_stmt">mysqli_stmt</a></span> <code class="parameter">$stmt</code></span>
    30. 

  30.    )</div>
    31. 

  31. 

  32.   <p class="para rdfs-comment">
    33. 

  33.    Returns the number of parameter markers present in the prepared statement.
    34. 

  34.   </p>
    35. 

  35.  </div>
    36. 

  36. 

  37. 

  38.  <div class="refsect1 parameters" id="refsect1-mysqli-stmt.param-count-parameters">
    39. 

  39.   <h3 class="title">参数</h3>
    40. 

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

  41.    <dl>
    42. 

  42. 

  43.     <dt>
    44. 

  44. <span class="term"><em><code class="parameter">
    45. 

  45. stmt</code></em></span><dd>
    46. 

  46. <p class="para">仅以过程化样式：由
    47. 

  47.  <span class="function"><a href="mysqli.stmt-init.html" class="function">mysqli_stmt_init()</a></span> 返回的 statement 标识。</p></dd>
    48. 

  48. </dt>
    49. 

  49. 

  50.    </dl>
    51. 

  51. 

  52.   </p>
    53. 

  53.  </div>
    54. 

  54. 

  55. 

  56.  <div class="refsect1 returnvalues" id="refsect1-mysqli-stmt.param-count-returnvalues">
    57. 

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

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

  59.    Returns an integer representing the number of parameters.
    60. 

  60.   </p>
    61. 

  61.  </div>
    62. 

  62. 

  63. 

  64.  <div class="refsect1 examples" id="refsect1-mysqli-stmt.param-count-examples">
    65. 

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

  66.   <div class="example" id="example-1728">
    67. 

  67.    <p><strong>Example #1 面向对象风格</strong></p>
    68. 

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

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

  70. <span style="color: #0000BB">&lt;?php<br />$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">"my_user"</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"my_password"</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"world"</span><span style="color: #007700">);<br /><br /></span><span style="color: #FF8000">/*&nbsp;check&nbsp;connection&nbsp;*/<br /></span><span style="color: #007700">if&nbsp;(</span><span style="color: #0000BB">mysqli_connect_errno</span><span style="color: #007700">())&nbsp;{<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">printf</span><span style="color: #007700">(</span><span style="color: #DD0000">"Connect&nbsp;failed:&nbsp;%s\n"</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">mysqli_connect_error</span><span style="color: #007700">());<br />&nbsp;&nbsp;&nbsp;&nbsp;exit();<br />}<br /><br />if&nbsp;(</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;Name&nbsp;FROM&nbsp;Country&nbsp;WHERE&nbsp;Name=?&nbsp;OR&nbsp;Code=?"</span><span style="color: #007700">))&nbsp;{<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$marker&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">$stmt</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">param_count</span><span style="color: #007700">;<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">printf</span><span style="color: #007700">(</span><span style="color: #DD0000">"Statement&nbsp;has&nbsp;%d&nbsp;markers.\n"</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$marker</span><span style="color: #007700">);<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #FF8000">/*&nbsp;close&nbsp;statement&nbsp;*/<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$stmt</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">close</span><span style="color: #007700">();<br />}<br /><br /></span><span style="color: #FF8000">/*&nbsp;close&nbsp;connection&nbsp;*/<br /></span><span style="color: #0000BB">$mysqli</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">close</span><span style="color: #007700">();<br /></span><span style="color: #0000BB">?&gt;</span>
    71. 

  71. </span>
    72. 

  72. </code></div>
    73. 

  73.    </div>
    74. 

  74. 

  75.   </div>
    76. 

  76.   <div class="example" id="example-1729">
    77. 

  77.    <p><strong>Example #2 过程化风格</strong></p>
    78. 

  78.    <div class="example-contents">
    79. 

  79. <div class="phpcode"><code><span style="color: #000000">
    80. 

  80. <span style="color: #0000BB">&lt;?php<br />$link&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">mysqli_connect</span><span style="color: #007700">(</span><span style="color: #DD0000">"localhost"</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"my_user"</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"my_password"</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"world"</span><span style="color: #007700">);<br /><br /></span><span style="color: #FF8000">/*&nbsp;check&nbsp;connection&nbsp;*/<br /></span><span style="color: #007700">if&nbsp;(</span><span style="color: #0000BB">mysqli_connect_errno</span><span style="color: #007700">())&nbsp;{<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">printf</span><span style="color: #007700">(</span><span style="color: #DD0000">"Connect&nbsp;failed:&nbsp;%s\n"</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">mysqli_connect_error</span><span style="color: #007700">());<br />&nbsp;&nbsp;&nbsp;&nbsp;exit();<br />}<br /><br />if&nbsp;(</span><span style="color: #0000BB">$stmt&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">mysqli_prepare</span><span style="color: #007700">(</span><span style="color: #0000BB">$link</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"SELECT&nbsp;Name&nbsp;FROM&nbsp;Country&nbsp;WHERE&nbsp;Name=?&nbsp;OR&nbsp;Code=?"</span><span style="color: #007700">))&nbsp;{<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$marker&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">mysqli_stmt_param_count</span><span style="color: #007700">(</span><span style="color: #0000BB">$stmt</span><span style="color: #007700">);<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">printf</span><span style="color: #007700">(</span><span style="color: #DD0000">"Statement&nbsp;has&nbsp;%d&nbsp;markers.\n"</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$marker</span><span style="color: #007700">);<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #FF8000">/*&nbsp;close&nbsp;statement&nbsp;*/<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">mysqli_stmt_close</span><span style="color: #007700">(</span><span style="color: #0000BB">$stmt</span><span style="color: #007700">);<br />}<br /><br /></span><span style="color: #FF8000">/*&nbsp;close&nbsp;connection&nbsp;*/<br /></span><span style="color: #0000BB">mysqli_close</span><span style="color: #007700">(</span><span style="color: #0000BB">$link</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">?&gt;</span>
    81. 

  81. </span>
    82. 

  82. </code></div>
    83. 

  83.    </div>
    84. 

  84. 

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

  86.    <div class="example-contents screen">
    87. 

  87. <div class="cdata"><pre>
    88. 

  88. Statement has 2 markers.
    89. 

  89. </pre></div>
    90. 

  90.    </div>
    91. 

  91.   </div>
    92. 

  92.  </div>
    93. 

  93. 

  94. 

  95.  <div class="refsect1 seealso" id="refsect1-mysqli-stmt.param-count-seealso">
    96. 

  96.   <h3 class="title">参见</h3>
    97. 

  97.   <p class="para">
    98. 

  98.    <ul class="simplelist">
    99. 

  99.     <li class="member"> <span class="function"><a href="mysqli.prepare.html" class="function" rel="rdfs-seeAlso">mysqli_prepare()</a> - Prepare an SQL statement for execution</span></li>
    100. 

  100.    </ul>
    101. 

  101.   </p>
    102. 

  102.  </div>
    103. 

  103. 

  104. 

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

  106.  <div class="prev" style="text-align: left; float: left;"><a href="mysqli-stmt.num-rows.html">mysqli_stmt::$num_rows</a></div>
    107. 

  107.  <div class="next" style="text-align: right; float: right;"><a href="mysqli-stmt.prepare.html">mysqli_stmt::prepare</a></div>
    108. 

  108.  <div class="up"><a href="class.mysqli-stmt.html">MySQLi_STMT</a></div>
    109. 

  109.  <div class="home"><a href="index.html">PHP Manual</a></div>
    110. 

  110. </div></body></html>
    111. 

  111.