LXIX. Unified ODBC functions

Introduction

Huomaa :

Requirements

Installation

Runtime Configuration

Taulu 1 .

Huomaa :

For further details and definition of the PHP_INI_* constants see ini_set() .

odbc.default_db string

odbc.default_user string

odbc.default_pw string

odbc.allow_persistent boolean

odbc.check_persistent boolean

odbc.max_persistent integer

odbc.max_links integer

odbc.defaultlrl integer

odbc.defaultbinmode integer



Resource Types

Tämä laajennus ei määrittele yhtäkään resurssi-tyyppiä .

Predefined Constants

These constants are defined by this extension , and will only be available when the extension has either been compiled into PHP or dynamically loaded at runtime .

ODBC_TYPE ( integer )

ODBC_BINMODE_PASSTHRU ( integer )

ODBC_BINMODE_RETURN ( integer )

ODBC_BINMODE_CONVERT ( integer )

SQL_ODBC_CURSORS ( integer )

SQL_CUR_USE_DRIVER ( integer )

SQL_CUR_USE_IF_NEEDED ( integer )

SQL_CUR_USE_ODBC ( integer )

SQL_CONCURRENCY ( integer )

SQL_CONCUR_READ_ONLY ( integer )

SQL_CONCUR_LOCK ( integer )

SQL_CONCUR_ROWVER ( integer )

SQL_CONCUR_VALUES ( integer )

SQL_CURSOR_TYPE ( integer )

SQL_CURSOR_FORWARD_ONLY ( integer )

SQL_CURSOR_KEYSET_DRIVEN ( integer )

SQL_CURSOR_DYNAMIC ( integer )

SQL_CURSOR_STATIC ( integer )

SQL_KEYSET_SIZE ( integer )

SQL_CHAR ( integer )

SQL_VARCHAR ( integer )

SQL_LONGVARCHAR ( integer )

SQL_DECIMAL ( integer )

SQL_NUMERIC ( integer )

SQL_BIT ( integer )

SQL_TINYINT ( integer )

SQL_SMALLINT ( integer )

SQL_INTEGER ( integer )

SQL_BIGINT ( integer )

SQL_REAL ( integer )

SQL_FLOAT ( integer )

SQL_DOUBLE ( integer )

SQL_BINARY ( integer )

SQL_VARBINARY ( integer )

SQL_LONGVARBINARY ( integer )

SQL_DATE ( integer )

SQL_TIME ( integer )

SQL_TIMESTAMP ( integer )

SQL_TYPE_DATE ( integer )

SQL_TYPE_TIME ( integer )

SQL_TYPE_TIMESTAMP ( integer )

SQL_BEST_ROWID ( integer )

SQL_ROWVER ( integer )

SQL_SCOPE_CURROW ( integer )

SQL_SCOPE_TRANSACTION ( integer )

SQL_SCOPE_SESSION ( integer )

SQL_NO_NULLS ( integer )

SQL_NULLABLE ( integer )

SQL_INDEX_UNIQUE ( integer )

SQL_INDEX_ALL ( integer )

SQL_ENSURE ( integer )

SQL_QUICK ( integer )

Sisällys
odbc_autocommit -- Toggle autocommit behaviour
odbc_binmode -- Handling of binary column data
odbc_close_all -- Close all ODBC connections
odbc_close -- Close an ODBC connection
odbc_columnprivileges -- Returns a result identifier that can be used to fetch a list of columns and associated privileges
odbc_columns -- Lists the column names in specified tables. Returns a result identifier containing the information.
odbc_commit -- Commit an ODBC transaction
odbc_connect -- Connect to a datasource
odbc_cursor -- Get cursorname
odbc_data_source -- Returns information about a current connection
odbc_do -- Synonym for odbc_exec()
odbc_error -- Get the last error code
odbc_errormsg -- Get the last error message
odbc_exec -- Prepare and execute a SQL statement
odbc_execute -- Execute a prepared statement
odbc_fetch_array -- Fetch a result row as an associative array
odbc_fetch_into -- Fetch one result row into array
odbc_fetch_object -- Fetch a result row as an object
odbc_fetch_row -- Fetch a row
odbc_field_len -- Get the length (precision) of a field
odbc_field_name -- Get the columnname
odbc_field_num -- Return column number
odbc_field_precision -- Synonym for odbc_field_len()
odbc_field_scale -- Get the scale of a field
odbc_field_type -- Datatype of a field
odbc_foreignkeys -- Returns a list of foreign keys in the specified table or a list of foreign keys in other tables that refer to the primary key in the specified table
odbc_free_result -- Free resources associated with a result
odbc_gettypeinfo -- Returns a result identifier containing information about data types supported by the data source.
odbc_longreadlen -- Handling of LONG columns
odbc_next_result -- Checks if multiple results are avaiable
odbc_num_fields -- Number of columns in a result
odbc_num_rows -- Number of rows in a result
odbc_pconnect -- Open a persistent database connection
odbc_prepare -- Prepares a statement for execution
odbc_primarykeys -- Returns a result identifier that can be used to fetch the column names that comprise the primary key for a table
odbc_procedurecolumns -- Retrieve information about parameters to procedures
odbc_procedures -- Get the list of procedures stored in a specific data source. Returns a result identifier containing the information.
odbc_result_all -- Print result as HTML table
odbc_result -- Get result data
odbc_rollback -- Rollback a transaction
odbc_setoption -- Adjust ODBC settings. Returns FALSE if an error occurs , otherwise TRUE .
odbc_specialcolumns -- Returns either the optimal set of columns that uniquely identifies a row in the table or columns that are automatically updated when any value in the row is updated by a transaction
odbc_statistics -- Retrieve statistics about a table
odbc_tableprivileges -- Lists tables and the privileges associated with each table
odbc_tables -- Get the list of table names stored in a specific data source. Returns a result identifier containing the information .