PHPCon Poland 2024

odbc_close

(PHP 4, PHP 5, PHP 7, PHP 8)

odbc_closeClose an ODBC connection

Descrição

odbc_close(resource $odbc): void

Closes down the connection to the database server.

Parâmetros

odbc

O identificador da conexão ODBC. Consulte odbc_connect() para obter detalhes.

Valor Retornado

Nenhum valor é retornado.

Notas

Nota:

This function will fail if there are open transactions on this connection. The connection will remain open in this case.

add a note

User Contributed Notes 1 note

up
-6
alvaro at demogracia dot com
6 years ago
`odbc_close()` does not report success and some drivers (namely Microsoft Access) don't seem to close connections at first attempt. This is normally not an issue, unless you need to establish many connections within the script lifetime.

You can use the fact that resource type changes (e.g. from "odbc link" to "Unknown") as a trick to figure out whether connection was successfully closed (and eventually retry):

<?php
$type
= get_resource_type($conn);
$wait_until = time() + 3;
do {
odbc_close($conexion_odbc);
} while (
get_resource_type($conn)===$type && time()<$wait_until);
To Top