<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >sesam_settransaction</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK REL="HOME" TITLE="PHP 手册" HREF="index.html"><LINK REL="UP" TITLE="SESAM Database Functions" HREF="ref.sesam.html"><LINK REL="PREVIOUS" TITLE="sesam_seek_row" HREF="function.sesam-seek-row.html"><LINK REL="NEXT" TITLE="PostgreSQL Session Save Handler" HREF="ref.session-pgsql.html"><META HTTP-EQUIV="Content-type" CONTENT="text/html; charset=UTF-8"></HEAD ><BODY CLASS="refentry" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >PHP 手册</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="function.sesam-seek-row.html" ACCESSKEY="P" >上一页</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="ref.session-pgsql.html" ACCESSKEY="N" >下一页</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><H1 ><A NAME="function.sesam-settransaction" ></A >sesam_settransaction</H1 ><DIV CLASS="refnamediv" ><A NAME="AEN207323" ></A ><P > (PHP 3 CVS only)</P >sesam_settransaction -- Set SESAM transaction parameters</DIV ><DIV CLASS="refsect1" ><A NAME="AEN207326" ></A ><H2 >说明</H2 >bool <B CLASS="methodname" >sesam_settransaction</B > ( int isolation_level, int read_only )<BR ></BR ><P > Overrides the default values for the <TT CLASS="literal" >isolation level</TT > and <TT CLASS="literal" >read-only</TT > 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. See the SESAM handbook for detailed explanation of the semantics. </P ><P > This function can only be called before starting a transaction, not after the transaction has been started already. </P ><P > The values set by <B CLASS="function" >sesam_settransaction()</B > will override the default setting specified in the <A HREF="ref.sesam.html#ini.sesam-configfile" >SESAM configuration file</A >. </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN207344" ></A ><H2 >参数</H2 ><P > <P ></P ><DIV CLASS="variablelist" ><DL ><DT ><CODE CLASS="parameter" >isolation_level</CODE ></DT ><DD ><P > <DIV CLASS="table" ><A NAME="AEN207353" ></A ><P ><B >表 1. Valid values for <CODE CLASS="parameter" >isolation_level</CODE > parameter </B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><COL><COL><COL><THEAD ><TR ><TH >Value</TH ><TH >Constant</TH ><TH >Meaning</TH ></TR ></THEAD ><TBODY ><TR ><TD >1</TD ><TD ><TT CLASS="literal" >SESAM_TXISOL_READ_UNCOMMITTED</TT ></TD ><TD >Read Uncommitted</TD ></TR ><TR ><TD >2</TD ><TD ><TT CLASS="literal" >SESAM_TXISOL_READ_COMMITTED</TT ></TD ><TD >Read Committed</TD ></TR ><TR ><TD >3</TD ><TD ><TT CLASS="literal" >SESAM_TXISOL_REPEATABLE_READ</TT ></TD ><TD >Repeatable Read</TD ></TR ><TR ><TD >4</TD ><TD ><TT CLASS="literal" >SESAM_TXISOL_SERIALIZABLE</TT ></TD ><TD >Serializable</TD ></TR ></TBODY ></TABLE ></DIV > </P ></DD ><DT ><CODE CLASS="parameter" >read_only</CODE ></DT ><DD ><P > <DIV CLASS="table" ><A NAME="AEN207388" ></A ><P ><B >表 2. Valid values for <CODE CLASS="parameter" >read_only</CODE > parameter </B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><COL><COL><COL><THEAD ><TR ><TH >Value</TH ><TH >Constant</TH ><TH >Meaning</TH ></TR ></THEAD ><TBODY ><TR ><TD >0</TD ><TD ><TT CLASS="literal" >SESAM_TXREAD_READWRITE</TT ></TD ><TD >Read/Write</TD ></TR ><TR ><TD >1</TD ><TD ><TT CLASS="literal" >SESAM_TXREAD_READONLY</TT ></TD ><TD >Read-Only</TD ></TR ></TBODY ></TABLE ></DIV > </P ></DD ></DL ></DIV > </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN207408" ></A ><H2 >返回值</H2 ><P > Returns <TT CLASS="constant" ><B >TRUE</B ></TT > if the values are valid, and the <TT CLASS="literal" >settransaction</TT > operation was successful, <TT CLASS="constant" ><B >FALSE</B ></TT > otherwise. </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN207414" ></A ><H2 >范例</H2 ><P > <TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" CLASS="EXAMPLE" ><TR ><TD ><DIV CLASS="example" ><A NAME="AEN207417" ></A ><P ><B >例 1. Setting SESAM transaction parameters</B ></P ><TABLE BORDER="0" BGCOLOR="#E0E0E0" CELLPADDING="5" ><TR ><TD ><code><font color="#000000"> <font color="#0000BB"><?php<br />sesam_settransaction </font><font color="#007700">(</font><font color="#0000BB">SESAM_TXISOL_REPEATABLE_READ</font><font color="#007700">,<br /> </font><font color="#0000BB">SESAM_TXREAD_READONLY</font><font color="#007700">);<br /></font><font color="#0000BB">?></font> </font> </code></TD ></TR ></TABLE ></DIV ></TD ></TR ></TABLE > </P ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="function.sesam-seek-row.html" ACCESSKEY="P" >上一页</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >起始页</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="ref.session-pgsql.html" ACCESSKEY="N" >下一页</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >sesam_seek_row</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="ref.sesam.html" ACCESSKEY="U" >上一级</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >PostgreSQL Session Save Handler</TD ></TR ></TABLE ></DIV ></BODY ></HTML >