   #PHP Manual SESAM database functions sesam_seek_row Session handling
   functions

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                             sesam_settransaction

   (PHP 3 CVS only)
   sesam_settransaction -- Set SESAM transaction parameters

Description

   bool sesam_settransaction ( int isolation_level, int read_only)

   Returns: TRUE if the values are valid, and the settransaction()
   operation was successful, FALSE otherwise.

   sesam_settransaction() overrides the default values for the "isolation
   level" and "read-only" transaction parameters (which are set in the
   SESAM configuration file), in order to optimize subsequent queries and
   guarantee database consistency. The overridden values are used for the
   next transaction only.

   sesam_settransaction() can only be called before starting a
   transaction, not after the transaction has been started already.

   To simplify the use in PHP scripts, the following constants have been
   predefined in PHP (see SESAM handbook for detailed explanation of the
   semantics):

   Table 1. Valid values for "Isolation_Level" parameter
   Value Constant                      Meaning
   1     SESAM_TXISOL_READ_UNCOMMITTED Read Uncommitted
   2     SESAM_TXISOL_READ_COMMITTED   Read Committed
   3     SESAM_TXISOL_REPEATABLE_READ  Repeatable Read
   4     SESAM_TXISOL_SERIALIZABLE     Serializable

   Table 2. Valid values for "Read_Only" parameter
   Value Constant               Meaning
   0     SESAM_TXREAD_READWRITE Read/Write
   1     SESAM_TXREAD_READONLY  Read-Only

   The values set by sesam_settransaction() will override the default
   setting specified in the SESAM configuration file.

   Example 1. Setting SESAM transaction parameters
   <?php
   sesam_settransaction (SESAM_TXISOL_REPEATABLE_READ,
                        SESAM_TXREAD_READONLY);
   ?>
   ______________________________________________________________________

   Prev           Home                       Next
   sesam_seek_row  Up  Session handling functions
