简介

Firebird/InterBase is a relational database offering many ANSI SQL-92 features that runs on Linux, Windows, and a variety of Unix platforms. Firebird/InterBase offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names since 1981.

InterBase is the name of the closed-source variant of this RDBMS that was developed by Borland/Inprise. More information about InterBase is available at » http://www.borland.com/interbase/.

Firebird is a commercially independent project of C and C++ programmers, technical advisors and supporters developing and enhancing a multi-platform relational database management system based on the source code released by Inprise Corp (now known as Borland Software Corp) under the InterBase Public License v.1.0 on 25 July, 2000. More information about Firebird is available at » http://www.firebirdsql.org/.

注意: This extension supports InterBase versions 5 and up and all versions of Firebird. Support for InterBase version 5.x will be dropped in PHP 5.

This database uses a single quote (') character for escaping, a behavior similar to the Sybase database, add to your php.ini the following directive:

magic_quotes_sybase = On

需求

安装

To enable InterBase support configure PHP --with-interbase[=DIR], where DIR is the InterBase base install directory, which defaults to /usr/interbase.

Note to Win32 Users: In order for this extension to work, there are DLL files that must be available to the Windows system PATH. See the FAQ titled "How do I add my PHP directory to the PATH on Windows" for information on how to do this. Although copying DLL files from the PHP folder into the Windows system directory also works (because the system directory is by default in the systems PATH), it is not recommended. This extension requires the following files to be in the PATH: gds32.dll

In case you installed the InterBase database server on the same machine PHP is running on, you will have this DLL already. Therefore you don't need to worry because gds32.dll will already be in the PATH.

运行时配置

这些函数的行为受 php.ini 的影响。

以下是配置选项的简要解释。

资源类型

预定义常量

以下常量由本扩展模块定义，因此只有在本扩展模块被编译到 PHP 中，或者在运行时被动态加载后才有效。

The following constants can be passed to ibase_trans() to specify transaction behaviour.

The following constants can be passed to ibase_fetch_row(), ibase_fetch_assoc() or ibase_fetch_object() to specify fetch behaviour.

The following constants are used to pass requests and options to the service API functions (ibase_server_info(), ibase_db_info(), ibase_backup(), ibase_restore() and ibase_maintain_db()). Please refer to the Firebird/InterBase manuals for the meaning of these options.

目录

ibase_add_user Add a user to a security database (only for IB6 or later)

ibase_affected_rows Return the number of rows that were affected by the previous query

ibase_backup Initiates a backup task in the service manager and returns immediately

ibase_blob_add Add data into a newly created blob

ibase_blob_cancel Cancel creating blob

ibase_blob_close Close blob

ibase_blob_create Create a new blob for adding data

ibase_blob_echo Output blob contents to browser

ibase_blob_get Get len bytes data from open blob

ibase_blob_import Create blob, copy file in it, and close it

ibase_blob_info Return blob length and other useful info

ibase_blob_open Open blob for retrieving data parts

ibase_close Close a connection to an InterBase database

ibase_commit_ret Commit a transaction without closing it

ibase_commit Commit a transaction

ibase_connect Open a connection to an InterBase database

ibase_db_info Request statistics about a database

ibase_delete_user Delete a user from a security database (only for IB6 or later)

ibase_drop_db Drops a database

ibase_errcode Return an error code

ibase_errmsg Return error messages

ibase_execute Execute a previously prepared query

ibase_fetch_assoc Fetch a result row from a query as an associative array

ibase_fetch_object Get an object from a InterBase database

ibase_fetch_row Fetch a row from an InterBase database

ibase_field_info Get information about a field

ibase_free_event_handler Cancels a registered event handler

ibase_free_query Free memory allocated by a prepared query

ibase_free_result Free a result set

ibase_gen_id Increments the named generator and returns its new value

ibase_maintain_db Execute a maintenance command on the database server

ibase_modify_user Modify a user to a security database (only for IB6 or later)

ibase_name_result Assigns a name to a result set

ibase_num_fields Get the number of fields in a result set

ibase_num_params Return the number of parameters in a prepared query

ibase_param_info Return information about a parameter in a prepared query

ibase_pconnect Open a persistent connection to an InterBase database

ibase_prepare Prepare a query for later binding of parameter placeholders and execution

ibase_query Execute a query on an InterBase database

ibase_restore Initiates a restore task in the service manager and returns immediately

ibase_rollback_ret Roll back a transaction without closing it

ibase_rollback Roll back a transaction

ibase_server_info Request information about a database server

ibase_service_attach Connect to the service manager

ibase_service_detach Disconnect from the service manager

ibase_set_event_handler Register a callback function to be called when events are posted

ibase_timefmt Sets the format of timestamp, date and time type columns returned from queries

ibase_trans Begin a transaction

ibase_wait_event Wait for an event to be posted by the database