oci_close

(PHP 5, PECL oci8 >= 1.1.0)

oci_close — Closes Oracle connection

Описание

bool oci_close ( resource $connection )

Closes the Oracle connection .

Параметри

connection: An Oracle connection identifier, returned by oci_connect().

Връщани стойности

Връща TRUE при успех или FALSE при неуспех.

Бележки

Забележка: Starting from the version 1.1 oci_close() correctly closes the Oracle connection. Use oci8.old_oci_close_semantics option to restore old behaviour of this function.

add a note User Contributed Notes oci_close

Fahd Alwashmi (F-A-W) 10-Mar-2012 08:22


please note, you can use oci_close() to close persistent connections opened with oci_pconnect() in PHP ver 5.3 or above.

as stated in here:

http://www.php.net/manual/en/oci8.configuration.php#ini.oci8.persistent-timeout

yepster at hotmail dot com 16-Feb-2002 10:21


For using persistent connections && being able to sleep, I use:





function close_db_locks_on_abort( ) {


    global $conn;


    if( connection_aborted() ) {


        $fp = fopen( "/tmp/shutdown-func.txt", "a" );


        fwrite( $fp, sprintf( "connection aborted on %s\n", date( "d-m-Y H:i:s" ) ) );


        if( $conn ) {


            OCIRollBack( $conn );


            fwrite( $fp, sprintf( "-- DURING CONNECTION! ip=%s, user=%s, page=%s\n", $_SERVER["REMOTE_ADDR"], $_SERVER["PHP_AUTH_USER"], $_SERVER["SCRIPT_FILENAME"] ) );


        }


        fclose( $fp );


    }


}





register_shutdown_function ( "close_db_locks_on_abort" );





This makes sure a rollback is done on a connection when a user hits 'stop', so there will be no locks on table rows.

add a note