odbc_rollback
(PHP 3>= 3.0.6, PHP 4 )
odbc_rollback -- Rollback a transaction
Description
int odbc_rollback ( resource connection_id)
Rolls back all pending statements on connection_id. Returns
TRUE on success, FALSE on failure.
odbc_setoption
(PHP 3>= 3.0.6, PHP 4 )
odbc_setoption -- Adjust ODBC settings. Returns FALSE if
an error occurs, otherwise TRUE.
Description
int odbc_setoption ( resource id, int function, int option,
int param)
This function allows fiddling with the ODBC options for
a particular connection or query result. It was written
to help find work around to problems in quirky ODBC drivers.
You should probably only use this function if you are an
ODBC programmer and understand the effects the various options
will have. You will certainly need a good ODBC reference
to explain all the different options and values that can
be used. Different driver versions support different options.
Because the effects may vary depending on the ODBC driver,
use of this function in scripts to be made publicly available
is strongly discouraged. Also, some ODBC options are not
available to this function because they must be set before
the connection is established or the query is prepared.
However, if on a particular job it can make PHP work so
your boss doesn't tell you to use a commercial product,
that's all that really matters.
id is a connection id or result id on which to change the
settings.For SQLSetConnectOption(), this is a connection
id. For SQLSetStmtOption(), this is a result id.
Function is the ODBC function to use. The value should
be 1 for SQLSetConnectOption() and 2 for SQLSetStmtOption().
Parameter option is the option to set.
Parameter param is the value for the given option. Example
1. ODBC Setoption Examples
<?php
// 1. Option 102 of SQLSetConnectOption() is SQL_AUTOCOMMIT.
// Value 1 of SQL_AUTOCOMMIT is SQL_AUTOCOMMIT_ON.
// This example has the same effect as
// odbc_autocommit($conn, true);
odbc_setoption($conn, 1, 102, 1);
// 2. Option 0 of SQLSetStmtOption() is SQL_QUERY_TIMEOUT.
// This example sets the query to timeout after 30 seconds.
$result = odbc_prepare($conn, $sql);
odbc_setoption($result, 2, 0, 30);
odbc_execute($result);
?>