odbc_prepare

odbc_prepare

Prepares a statement for execution

 **odbc_prepare** Odbc\Connection $odbc string $query

Prepares a statement for execution. odbc.result.object can be used later to execute the statement with . odbc_execute

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.

odbc``queryThe query string statement being prepared.

odbc.result.object-return if the SQL command was prepared successfully. Returns false on error.

Voorbeeld: and example

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

<?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, for Oracle). oci8

odbc_execute