Firebird Functions (PDO_FIREBIRD)

簡介

PDO_FIREBIRD is a driver that implements the PHP Data Objects (PDO) interface to enable access from PHP to Firebird database.

安裝

Use --with-pdo-firebird[=DIR] to install the PDO Firebird extension, where the optional [=DIR] is the Firebird base install directory.

$ ./configure --with-pdo-firebird

預設常數

以下常數由本驅動程式所定義,並且僅在該擴充功能被編譯入 PHP 或在執行時動態載入時可用。此外,這些驅動程式特定的常數應僅在使用此驅動程式被使用。在 Postgres 驅動下使用 MySQL 特定的屬性可能會導致不可預期的行為。在程式碼可以執行於多個驅動程式下時,可以用 PDO::getAttribute() 來取得 PDO_ATTR_DRIVER_NAME 屬性以檢查驅動程式。

PDO::FB_ATTR_DATE_FORMAT (integer)

Available since PHP 5.3.0.

Sets the date format.

PDO::FB_ATTR_TIME_FORMAT (integer)

Sets the time format.

Available since PHP 5.3.0.

PDO::FB_ATTR_TIMESTAMP_FORMAT (integer)

Sets the timestamp format.

Available since PHP 5.3.0.

Table of Contents

add a note add a note

User Contributed Notes 5 notes

up
0
Anonymous
5 years ago
From php 7.1  i am using PDO like this:

$host = 'firebird:dbname=x.x.x.x:C:\baza.eu3';
$password = 'xxx';
$username = 'SYSDBA';
  
$firebird = new \PDO($host, $username, $password, [\PDO::ATTR_ERRMODE => \PDO::ERRMODE_EXCEPTION]);
up
-4
trumped at mail dot ru
8 years ago
You need to set:
    setAttribute(PDO::FB_ATTR_TIMESTAMP_FORMAT, '%s')
for timestamp values
up
-5
sebastien dot caplet at l-seguin dot fr
8 years ago
I have added fbclient.dll in windows/system32/
up
-5
Anonymous
11 years ago
After two days of trouble with no visibile issues, when rebooting the system two popups come up:

PHP Startup: Unable to load dynamic library
'c:/wamp/bin/php/php.5.3.13/ext/php_interbase.dll' - %1 non è un'applicazione di Win32 valida.

PHP Startup: Unable to load dynamic library
'c:/wamp/bin/php/php.5.3.13/ext/php_pdo_firebird.dll' - %1 non è un'applicazione di Win32 valida.

I've just re-installed wampserver (http://www.wampserver.com/en/) and all seems run well.

To see if your Firebird PDO driver runs well:

<?php
foreach(PDO::getAvailableDrivers() as $driver) {
  echo
$driver.'<br />';
}
?>
up
-13
ritsaert at continuit dot nl
18 years ago
The connection string for a firebird PDO connection is different than described above. It is something like:

$DB = new PDO("firebird:dbname=T:\\Klimreg.GDB", "SYSDBA", "masterkey");

after dbname= the default connection string for Interbase and Firebird databases is used as presented to either gds32.dll or fbclient.dll.
To Top