odbc_columns

Function • Params and return types changed in PHP 8.4

Lists the column names in specified tables.

PHP 5
PHP 7
PHP 8.0
Improved
PHP 8.1
PHP 8.2-8.3
PHP 8.4
Improved
PHP 8.5
PHP 8.6

odbc_columns Function synopsis

odbc_columns(
    Odbc\Connection $odbc,
    ?string $catalog = null,
    ?string $schema = null,
    ?string $table = null,
    ?string $column = null
  ): Odbc\Result|false

Parameters

$odbc

TypeOdbc\Connection

$catalog

OptionalType?stringDefault valuenull

The catalog ("qualifier" in ODBC 2 parlance).

$schema

OptionalType?stringDefault valuenull

The schema ("owner" in ODBC 2 parlance). This parameter accepts the following search patterns: % to match zero or more characters, and _ to match a single character.

$table

OptionalType?stringDefault valuenull

The table name. This parameter accepts the following search patterns: % to match zero or more characters, and _ to match a single character.

$column

OptionalType?stringDefault valuenull

The column name. This parameter accepts the following search patterns: % to match zero or more characters, and _ to match a single character.

Return value

TypeOdbc\Result|false

Returns an ODBC result object or false on failure

The result set has the following columns:

Drivers can report additional columns.

Changes to the odbc_columns Function

PHP 8.4

  • Return type added: Odbc\Result|false
  • Parameter type added for parameter #1 ($odbc): Odbc\Connection
  odbc_columns(
-     $odbc,
+     Odbc\Connection $odbc,
      ?string $catalog = null,
      ?string $schema = null,
      ?string $table = null,
      ?string $column = null
-   )
+   ): Odbc\Result|false

PHP 8.0

  • Parameter name of parameter #1 changed: $connection_id to $odbc
  • Parameter name of parameter #2 changed: $qualifier to $catalog
  • Parameter type added for parameter #2 ($catalog): ?string
  • Parameter default value added for position #2 ($catalog): null
  • Parameter name of parameter #3 changed: $owner to $schema
  • Parameter type added for parameter #3 ($schema): ?string
  • Parameter default value added for position #3 ($schema): null
  • Parameter name of parameter #4 changed: $table_name to $table
  • Parameter type added for parameter #4 ($table): ?string
  • Parameter default value added for position #4 ($table): null
  • Parameter name of parameter #5 changed: $column_name to $column
  • Parameter type added for parameter #5 ($column): ?string
  • Parameter default value added for position #5 ($column): null
  odbc_columns(
-     $connection_id,
+     $odbc,
-     $qualifier,
+     ?string $catalog = null,
-     $owner,
+     ?string $schema = null,
-     $table_name,
+     ?string $table = null,
-     $column_name
+     ?string $column = null
    )

odbc_columns Function Availability

PHP VersionAvailability
PHP 8.6Upcoming Release Yes
PHP 8.5Supported (Latest) Yes
PHP 8.4Supported Yes
PHP 8.3Security-Fixes Only Yes
PHP 8.2Security-Fixes Only Yes
PHP 8.1Unsupported Yes
PHP 8.0Unsupported Yes
PHP 7.4Unsupported Yes
PHP 7.3Unsupported Yes
PHP 7.2Unsupported Yes
PHP 7.1Unsupported Yes
PHP 7.0Unsupported Yes
PHP 5.6Unsupported Yes
PHP 5.5Unsupported Yes
PHP 5.4Unsupported Yes
PHP 5.3Unsupported Yes