odbc_execute

(PHP 4, PHP 5, PHP 7)

odbc_execute — Execute a prepared statement

说明

odbc_execute ( resource $result_id [, array $parameters_array ] ) : bool

Executes a statement prepared with odbc_prepare().

参数

result_id

The result id resource, from odbc_prepare().

parameters_array

Parameters in parameter_array will be substituted for placeholders in the prepared statement in order. Elements of this array will be converted to strings by calling this function.

Any parameters in parameter_array which start and end with single quotes will be taken as the name of a file to read and send to the database server as the data for the appropriate placeholder.

If you wish to store a string which actually begins and ends with single quotes, you must add a space or other non-single-quote character to the beginning or end of the parameter, which will prevent the parameter from being taken as a file name. If this is not an option, then you must use another mechanism to store the string, such as executing the query directly with odbc_exec()).

返回值

成功时返回 TRUE， 或者在失败时返回 FALSE。

范例

Example #1 odbc_execute() and odbc_prepare() example

In the following code, $success will only be TRUE if all three parameters to myproc are IN parameters:

<?php
$a = 1;
$b = 2;
$c = 3;
$stmt    = odbc_prepare($conn, 'CALL myproc(?,?,?)');
$success = odbc_execute($stmt, array($a, $b, $c));
?>

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, mssql for MS SQL Server, or oci8 for Oracle).

更新日志

版本 说明
4.2.0 File reading is now subject to 安全模式 and open-basedir restrictions in parameters_array.

参见

相关文章
php cubrid 函数 bind variables to a prepared statement as parametersphp cubrid 函数 execute a prepared sql statementphp cubrid 函数 bind a lob object or a string as a lob object to a prepared statement as parametersphp ibm db2 函数 executes a prepared sql statementphp firebird/interbase 函数 execute a previously prepared queryphp informix 函数 execute a previously prepared sql statementphp ingres 函数 execute a prepared queryphp maxdb 函数 binds variables to a prepared statement as parametersphp maxdb 函数 binds variables to a prepared statement for result storagephp maxdb 函数 closes a prepared statementphp maxdb 函数 fetch results from a prepared statement into the bound variablesphp maxdb 函数 returns result set metadata from a prepared statementphp maxdb 函数 transfers a result set from a prepared statementphp odbc 函数 prepare and execute an sql statementphp odbc 函数 execute a prepared statementphp postgresql 函数 sends a request to execute a prepared statement with given parameters and waits for the resultphp postgresql 函数 sends a request to execute a prepared statement with given parameters without waiting for the result s php postgresql 函数 sends a request to create a prepared statement with the given parameters without waiting for completionphp sqlsrv 函数 executes a statement prepared with sqlsrv preparephp sdo das relational 函数 executes an sql query passed as a prepared statement with a list of values to substitute for placeholders and return the results as a normalised data graph
关注编程学问公众号