(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.
Returns true
on success or false
on failure.
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, oci8 for Oracle).
© 1997–2020 The PHP Documentation Group
Licensed under the Creative Commons Attribution License v3.0 or later.
https://www.php.net/manual/en/function.odbc-execute.php