note 19122 added to function.ocilogoff

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. -- http://www.php.net/manual/en/function.ocilogoff.php http://master.php.net/manage/user-notes.php?action=edit+19122 http://master.php.net/manage/user-notes.php?action=delete+19122 http://master.php.net/manage/user-notes.php?action=reject+19122