Sophie

Sophie

distrib > PLD > ac > amd64 > media > dist > by-pkgid > dd8ef74e7a184506d40e4328053fb785 > files > 2399

php-manual-ro-20051028-1.noarch.rpm

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML
><HEAD
><TITLE
>ocinlogon</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
REL="HOME"
TITLE="Manual PHP"
HREF="index.html"><LINK
REL="UP"
TITLE="Oracle 8 functions"
HREF="ref.oci8.html"><LINK
REL="PREVIOUS"
TITLE="ocinewdescriptor"
HREF="function.ocinewdescriptor.html"><LINK
REL="NEXT"
TITLE="ocinumcols"
HREF="function.ocinumcols.html"><META
HTTP-EQUIV="Content-type"
CONTENT="text/html; charset=ISO-8859-2"></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"
>Manual PHP</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="function.ocinewdescriptor.html"
ACCESSKEY="P"
>Înapoi</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="function.ocinumcols.html"
ACCESSKEY="N"
>Înainte</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="function.ocinlogon"
></A
>ocinlogon</H1
><DIV
CLASS="refnamediv"
><A
NAME="AEN83998"
></A
><P
>    (PHP 3&#62;= 3.0.8, PHP 4 , PHP 5)</P
>ocinlogon&nbsp;--&nbsp;Establishes a new connection to Oracle</DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN84001"
></A
><H2
>Description</H2
>resource <B
CLASS="methodname"
>ocinlogon</B
> ( string username, string password [, string db [, string charset]])<BR
></BR
><P
>&#13;     <B
CLASS="function"
>ocinlogon()</B
> creates a new connection to an
     Oracle 8 database and logs on.  The optional third parameter can
     either contain the name of the local Oracle instance or the name
     of the entry in tnsnames.ora to which you want to connect.  If
     the optional third parameter is not specified, PHP uses the
     environment variables ORACLE_SID (Oracle instance) or TWO_TASK
     (tnsnames.ora) to determine which database to connect to.
    </P
><P
>&#13;     <B
CLASS="function"
>ocinlogon()</B
> forces a new connection.  This
     should be used if you need to isolate a set of transactions.  By
     default, connections are shared at the page level if using
     <A
HREF="function.ocilogon.html"
><B
CLASS="function"
>ocilogon()</B
></A
> or at the web server process level
     if using <A
HREF="function.ociplogon.html"
><B
CLASS="function"
>ociplogon()</B
></A
>.  If you have multiple
     connections open using <B
CLASS="function"
>ocinlogon()</B
>, all
     commits and rollbacks apply to the specified connection only.
    </P
><P
>Using Oracle server version 9.2 and greater, you can
indicate <VAR
CLASS="parameter"
>charset</VAR
> parameter, which will be used in the new
connection. If you're using Oracle server &#60; 9.2, this parameter will be ignored
and NLS_LANG environment variable will be used instead.</P
><P
>&#13;     This example demonstrates how the connections are separated.
     <TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
CLASS="EXAMPLE"
><TR
><TD
><DIV
CLASS="example"
><A
NAME="AEN84028"
></A
><P
><B
>Exemplu 1. <B
CLASS="function"
>ocinlogon()</B
> example</B
></P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
CELLPADDING="5"
><TR
><TD
><code><font color="#000000">
<font color="#0000BB">&lt;?php<br /></font><font color="#007700">echo </font><font color="#DD0000">"&lt;html&gt;&lt;pre&gt;"</font><font color="#007700">;<br /></font><font color="#0000BB">$db </font><font color="#007700">= </font><font color="#DD0000">""</font><font color="#007700">;<br /><br /></font><font color="#0000BB">$c1 </font><font color="#007700">= </font><font color="#0000BB">ocilogon</font><font color="#007700">(</font><font color="#DD0000">"scott"</font><font color="#007700">, </font><font color="#DD0000">"tiger"</font><font color="#007700">, </font><font color="#0000BB">$db</font><font color="#007700">);<br /></font><font color="#0000BB">$c2 </font><font color="#007700">= </font><font color="#0000BB">ocinlogon</font><font color="#007700">(</font><font color="#DD0000">"scott"</font><font color="#007700">, </font><font color="#DD0000">"tiger"</font><font color="#007700">, </font><font color="#0000BB">$db</font><font color="#007700">);<br /><br />function </font><font color="#0000BB">create_table</font><font color="#007700">(</font><font color="#0000BB">$conn</font><font color="#007700">) <br />{<br />&nbsp;&nbsp;</font><font color="#0000BB">$stmt </font><font color="#007700">= </font><font color="#0000BB">ociparse</font><font color="#007700">(</font><font color="#0000BB">$conn</font><font color="#007700">, </font><font color="#DD0000">"create table scott.hallo (test<br />varchar2(64))"</font><font color="#007700">);<br />&nbsp;&nbsp;</font><font color="#0000BB">ociexecute</font><font color="#007700">(</font><font color="#0000BB">$stmt</font><font color="#007700">);<br />&nbsp;&nbsp;echo </font><font color="#0000BB">$conn </font><font color="#007700">. </font><font color="#DD0000">" created table\n\n"</font><font color="#007700">;<br />}<br /><br />function </font><font color="#0000BB">drop_table</font><font color="#007700">(</font><font color="#0000BB">$conn</font><font color="#007700">) <br />{<br />&nbsp;&nbsp;</font><font color="#0000BB">$stmt </font><font color="#007700">= </font><font color="#0000BB">ociparse</font><font color="#007700">(</font><font color="#0000BB">$conn</font><font color="#007700">, </font><font color="#DD0000">"drop table scott.hallo"</font><font color="#007700">);<br />&nbsp;&nbsp;</font><font color="#0000BB">ociexecute</font><font color="#007700">(</font><font color="#0000BB">$stmt</font><font color="#007700">);<br />&nbsp;&nbsp;echo </font><font color="#0000BB">$conn </font><font color="#007700">. </font><font color="#DD0000">" dropped table\n\n"</font><font color="#007700">;<br />}<br /><br />function </font><font color="#0000BB">insert_data</font><font color="#007700">(</font><font color="#0000BB">$conn</font><font color="#007700">) <br />{<br />&nbsp;&nbsp;</font><font color="#0000BB">$stmt </font><font color="#007700">= </font><font color="#0000BB">ociparse</font><font color="#007700">(</font><font color="#0000BB">$conn</font><font color="#007700">, </font><font color="#DD0000">"insert into scott.hallo <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;values('$conn' || ' ' || to_char(sysdate,'DD-MON-YY HH24:MI:SS'))"</font><font color="#007700">);<br />&nbsp;&nbsp;</font><font color="#0000BB">ociexecute</font><font color="#007700">(</font><font color="#0000BB">$stmt</font><font color="#007700">, </font><font color="#0000BB">OCI_DEFAULT</font><font color="#007700">);<br />&nbsp;&nbsp;echo </font><font color="#0000BB">$conn </font><font color="#007700">. </font><font color="#DD0000">" inserted hallo\n\n"</font><font color="#007700">;<br />}<br /><br />function </font><font color="#0000BB">delete_data</font><font color="#007700">(</font><font color="#0000BB">$conn</font><font color="#007700">) <br />{<br />&nbsp;&nbsp;</font><font color="#0000BB">$stmt </font><font color="#007700">= </font><font color="#0000BB">ociparse</font><font color="#007700">(</font><font color="#0000BB">$conn</font><font color="#007700">, </font><font color="#DD0000">"delete from scott.hallo"</font><font color="#007700">);<br />&nbsp;&nbsp;</font><font color="#0000BB">ociexecute</font><font color="#007700">(</font><font color="#0000BB">$stmt</font><font color="#007700">, </font><font color="#0000BB">OCI_DEFAULT</font><font color="#007700">);<br />&nbsp;&nbsp;echo </font><font color="#0000BB">$conn </font><font color="#007700">. </font><font color="#DD0000">" deleted hallo\n\n"</font><font color="#007700">;<br />}<br /><br />function </font><font color="#0000BB">commit</font><font color="#007700">(</font><font color="#0000BB">$conn</font><font color="#007700">) <br />{<br />&nbsp;&nbsp;</font><font color="#0000BB">ocicommit</font><font color="#007700">(</font><font color="#0000BB">$conn</font><font color="#007700">);<br />&nbsp;&nbsp;echo </font><font color="#0000BB">$conn </font><font color="#007700">. </font><font color="#DD0000">" committed\n\n"</font><font color="#007700">;<br />}<br /><br />function </font><font color="#0000BB">rollback</font><font color="#007700">(</font><font color="#0000BB">$conn</font><font color="#007700">) <br />{<br />&nbsp;&nbsp;</font><font color="#0000BB">ocirollback</font><font color="#007700">(</font><font color="#0000BB">$conn</font><font color="#007700">);<br />&nbsp;&nbsp;echo </font><font color="#0000BB">$conn </font><font color="#007700">. </font><font color="#DD0000">" rollback\n\n"</font><font color="#007700">;<br />}<br /><br />function </font><font color="#0000BB">select_data</font><font color="#007700">(</font><font color="#0000BB">$conn</font><font color="#007700">) <br />{<br />&nbsp;&nbsp;</font><font color="#0000BB">$stmt </font><font color="#007700">= </font><font color="#0000BB">ociparse</font><font color="#007700">(</font><font color="#0000BB">$conn</font><font color="#007700">, </font><font color="#DD0000">"select * from scott.hallo"</font><font color="#007700">);<br />&nbsp;&nbsp;</font><font color="#0000BB">ociexecute</font><font color="#007700">(</font><font color="#0000BB">$stmt</font><font color="#007700">, </font><font color="#0000BB">OCI_DEFAULT</font><font color="#007700">);<br />&nbsp;&nbsp;echo </font><font color="#0000BB">$conn </font><font color="#007700">. </font><font color="#DD0000">"----selecting\n\n"</font><font color="#007700">;<br />&nbsp;&nbsp;while (</font><font color="#0000BB">ocifetch</font><font color="#007700">(</font><font color="#0000BB">$stmt</font><font color="#007700">)) {<br />&nbsp;&nbsp;&nbsp;&nbsp;echo </font><font color="#0000BB">$conn </font><font color="#007700">. </font><font color="#DD0000">" &lt;" </font><font color="#007700">. </font><font color="#0000BB">ociresult</font><font color="#007700">(</font><font color="#0000BB">$stmt</font><font color="#007700">, </font><font color="#DD0000">"TEST"</font><font color="#007700">) . </font><font color="#DD0000">"&gt;\n\n"</font><font color="#007700">;<br />&nbsp;&nbsp;}<br />&nbsp;&nbsp;echo </font><font color="#0000BB">$conn </font><font color="#007700">. </font><font color="#DD0000">"----done\n\n"</font><font color="#007700">;<br />}<br /><br /></font><font color="#0000BB">create_table</font><font color="#007700">(</font><font color="#0000BB">$c1</font><font color="#007700">);<br /></font><font color="#0000BB">insert_data</font><font color="#007700">(</font><font color="#0000BB">$c1</font><font color="#007700">);<br /><br /></font><font color="#0000BB">select_data</font><font color="#007700">(</font><font color="#0000BB">$c1</font><font color="#007700">);&nbsp;&nbsp;&nbsp;<br /></font><font color="#0000BB">select_data</font><font color="#007700">(</font><font color="#0000BB">$c2</font><font color="#007700">);&nbsp;&nbsp;&nbsp;<br /><br /></font><font color="#0000BB">rollback</font><font color="#007700">(</font><font color="#0000BB">$c1</font><font color="#007700">);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br /><br /></font><font color="#0000BB">select_data</font><font color="#007700">(</font><font color="#0000BB">$c1</font><font color="#007700">);&nbsp;&nbsp;&nbsp;<br /></font><font color="#0000BB">select_data</font><font color="#007700">(</font><font color="#0000BB">$c2</font><font color="#007700">);&nbsp;&nbsp;&nbsp;<br /><br /></font><font color="#0000BB">insert_data</font><font color="#007700">(</font><font color="#0000BB">$c2</font><font color="#007700">);&nbsp;&nbsp;&nbsp;<br /></font><font color="#0000BB">commit</font><font color="#007700">(</font><font color="#0000BB">$c2</font><font color="#007700">);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br /><br /></font><font color="#0000BB">select_data</font><font color="#007700">(</font><font color="#0000BB">$c1</font><font color="#007700">);&nbsp;&nbsp;&nbsp;<br /><br /></font><font color="#0000BB">delete_data</font><font color="#007700">(</font><font color="#0000BB">$c1</font><font color="#007700">);&nbsp;&nbsp;&nbsp;<br /></font><font color="#0000BB">select_data</font><font color="#007700">(</font><font color="#0000BB">$c1</font><font color="#007700">);&nbsp;&nbsp;&nbsp;<br /></font><font color="#0000BB">select_data</font><font color="#007700">(</font><font color="#0000BB">$c2</font><font color="#007700">);&nbsp;&nbsp;&nbsp;<br /></font><font color="#0000BB">commit</font><font color="#007700">(</font><font color="#0000BB">$c1</font><font color="#007700">);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br /><br /></font><font color="#0000BB">select_data</font><font color="#007700">(</font><font color="#0000BB">$c1</font><font color="#007700">);<br /></font><font color="#0000BB">select_data</font><font color="#007700">(</font><font color="#0000BB">$c2</font><font color="#007700">);<br /><br /></font><font color="#0000BB">drop_table</font><font color="#007700">(</font><font color="#0000BB">$c1</font><font color="#007700">);<br />echo </font><font color="#DD0000">"&lt;/pre&gt;&lt;/html&gt;"</font><font color="#007700">;<br /></font><font color="#0000BB">?&gt;</font>
</font>
</code></TD
></TR
></TABLE
></DIV
></TD
></TR
></TABLE
>
    </P
><DIV
CLASS="note"
><BLOCKQUOTE
CLASS="note"
><P
><B
>Not&#227;: </B
>
      This function was renamed to <A
HREF="function.oci-new-connect.html"
><B
CLASS="function"
>oci_new_connect()</B
></A
> 
      after PHP &#62;= 5.0.0. For downward compatibility 
      <B
CLASS="function"
>ocinlogon()</B
> can also be used. 
      This is deprecated, however.
     </P
></BLOCKQUOTE
></DIV
></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.ocinewdescriptor.html"
ACCESSKEY="P"
>Înapoi</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Acas&#227;</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="function.ocinumcols.html"
ACCESSKEY="N"
>Înainte</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>ocinewdescriptor</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="ref.oci8.html"
ACCESSKEY="U"
>Sus</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>ocinumcols</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>

Perl :: Catalyst :: PostgreSQL :: RPM Valid HTML 4.01 Transitional