PDO_FIREBIRD DSN
(PECL PDO_FIREBIRD >= 0.1.0)
PDO_FIREBIRD DSN — Connecting to Firebird databases
Beschreibung
The PDO_FIREBIRD Data Source Name (DSN) is composed of the following elements:
- DSN prefix
-
The DSN prefix is
firebird:
. -
dbname
-
The name of the database.
-
charset
-
The character set.
-
role
-
The SQL role name.
-
dialect
-
The dialect of the database; either
1
or3
. If not specified, the dialect defaults to3
. Available as of PHP 7.4.0.
Beispiele
Beispiel #1 PDO_FIREBIRD DSN example with path
The following example shows a PDO_FIREBIRD DSN for connecting to Firebird databases:
firebird:dbname=/path/to/DATABASE.FDB
Beispiel #2 PDO_FIREBIRD DSN example with port and path
The following example shows a PDO_FIREBIRD DSN for connecting to a Firebird database using hostname port and path:
firebird:dbname=hostname/port:/path/to/DATABASE.FDB
Beispiel #3 PDO_FIREBIRD DSN example with localhost and path to employee.fdb on Debian system
The following example shows a PDO_FIREBIRD DSN for connecting to a Firebird database employee.fdb using localhost:
firebird:dbname=localhost:/var/lib/firebird/2.5/data/employee.fdb
Beispiel #4 PDO_FIREBIRD DSN to connect to a dialect 1 database
The following example shows a PDO_FIREBIRD DSN for connecting to a Firebird database test.fdb which has been created using dialect 1. This is only supported as of PHP 7.4.0.
firebird:dbname=localhost:/var/lib/firebird/2.5/data/test.fdb;charset=utf-8;dialect=1