function.odbc-prepare.html
来自「php的帮助文档,涉及到PHP的案例和基本语法,以及实际应用内容」· HTML 代码 · 共 130 行
HTML
130 行
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html> <head> <title>Prepares a statement for execution</title> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> </head> <body><div style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="function.odbc-pconnect.html">odbc_pconnect</a></div> <div class="next" style="text-align: right; float: right;"><a href="function.odbc-primarykeys.html">odbc_primarykeys</a></div> <div class="up"><a href="ref.uodbc.html">ODBC Functions</a></div> <div class="home"><a href="index.html">PHP Manual</a></div></div><hr /><div id="function.odbc-prepare" class="refentry"> <div class="refnamediv"> <h1 class="refname">odbc_prepare</h1> <p class="verinfo">(PHP 4, PHP 5)</p><p class="refpurpose"><span class="refname">odbc_prepare</span> — <span class="dc-title">Prepares a statement for execution</span></p> </div> <div class="refsect1 description"> <h3 class="title">Description</h3> <div class="methodsynopsis dc-description"> <span class="type">resource</span> <span class="methodname"><b><b>odbc_prepare</b></b></span> ( <span class="methodparam"><span class="type">resource</span> <tt class="parameter">$connection_id</tt></span> , <span class="methodparam"><span class="type">string</span> <tt class="parameter">$query_string</tt></span> )</div> <p class="para rdfs-comment"> Prepares a statement for execution. The result identifier can be used later to execute the statement with <a href="function.odbc-execute.html" class="function">odbc_execute()</a>. </p> <p class="para"> Some databases (such as IBM DB2, MS SQL Server, and Oracle) support stored procedures that accept parameters of type IN, INOUT, and OUT as defined by the ODBC specification. However, the Unified ODBC driver currently only supports parameters of type IN to stored procedures. </p> </div> <div class="refsect1 parameters"> <h3 class="title">Parameters</h3> <p class="para"> <dl> <dt> <span class="term"><i><tt class="parameter">connection_id</tt></i></span> <dd> <p class="para">The ODBC connection identifier,see <a href="function.odbc-connect.html" class="function">odbc_connect()</a> for details.</p> </dd> </dt> <dt> <span class="term"><i><tt class="parameter">query_string</tt></i></span> <dd> <p class="para"> The query string statement being prepared. </p> </dd> </dt> </dl> </p> </div> <div class="refsect1 returnvalues"> <h3 class="title">Return Values</h3> <p class="para"> Returns an ODBC result identifier if the SQL command was prepared successfully. Returns <b><tt>FALSE</tt></b> on error. </p> </div> <div class="refsect1 examples"> <h3 class="title">Examples</h3> <p class="para"> <div class="example"> <p><b>Example #1 <a href="function.odbc-execute.html" class="function">odbc_execute()</a> and <b>odbc_prepare()</b> example</b></p> <div class="example-contents"><p> In the following code, <var class="varname">$success</var> will only be <b><tt>TRUE</tt></b> if all three parameters to myproc are IN parameters: </p></div> <div class="example-contents"><div class="phpcode"><code><span style="color: #000000"><span style="color: #0000BB"><?php<br />$a </span><span style="color: #007700">= </span><span style="color: #0000BB">1</span><span style="color: #007700">;<br /></span><span style="color: #0000BB">$b </span><span style="color: #007700">= </span><span style="color: #0000BB">2</span><span style="color: #007700">;<br /></span><span style="color: #0000BB">$c </span><span style="color: #007700">= </span><span style="color: #0000BB">3</span><span style="color: #007700">;<br /></span><span style="color: #0000BB">$stmt </span><span style="color: #007700">= </span><span style="color: #0000BB">odbc_prepare</span><span style="color: #007700">(</span><span style="color: #0000BB">$conn</span><span style="color: #007700">, </span><span style="color: #DD0000">'CALL myproc(?,?,?)'</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$success </span><span style="color: #007700">= </span><span style="color: #0000BB">odbc_execute</span><span style="color: #007700">(</span><span style="color: #0000BB">$stmt</span><span style="color: #007700">, array(</span><span style="color: #0000BB">$a</span><span style="color: #007700">, </span><span style="color: #0000BB">$b</span><span style="color: #007700">, </span><span style="color: #0000BB">$c</span><span style="color: #007700">));<br /></span><span style="color: #0000BB">?></span></span></code></div> </div> </div> </p> <p class="para"> If you need to call a stored procedure using INOUT or OUT parameters, the recommended workaround is to use a native extension for your database (for example, <a href="ref.mssql.html" class="link">mssql</a> for MS SQL Server, or <a href="ref.mssql.html" class="link">oci8</a> for Oracle). </p> </div> <div class="refsect1 seealso"> <h3 class="title">See Also</h3> <p class="para"> <ul class="simplelist"> <li class="member"><a href="function.odbc-execute.html" class="function" rel="rdfs-seeAlso">odbc_execute()</a></li> </ul> </p> </div></div><hr /><div style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="function.odbc-pconnect.html">odbc_pconnect</a></div> <div class="next" style="text-align: right; float: right;"><a href="function.odbc-primarykeys.html">odbc_primarykeys</a></div> <div class="up"><a href="ref.uodbc.html">ODBC Functions</a></div> <div class="home"><a href="index.html">PHP Manual</a></div></div></body></html>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?