Firebird(PDO)

简介

PDO_FIREBIRD is a driver that implements the PHP Data Objects(PDO)interface to enable access from PHP to Firebird database.PDO_FIREBIRD是一个驱动程序，该驱动程序实现PHP数据对象（PDO）接口以允许从PHP访问Firebird数据库。

安装

Use 使用--with-pdo-firebird[= DIR]安装PDO Firebird扩展，其中可选的[= DIR]是Firebird的基本安装目录。is the Firebird base install directory.

$ ./configure --with-pdo-firebird

预定义常量

下列常量由此驱动定义，且仅在扩展编译入 PHP或在运行时动态载入时可用。另外，使用此驱动时，仅会使用这些驱动特定的常量。使用其他驱动的驱动特定的常量可能会导致不可预见的情况。如果代码可运行于多个驱动，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.

PDO_FIREBIRD DSN—连接到Firebird数据库

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]);

I have added fbclient.dll in windows/system32/

You need to set:
  setAttribute(PDO::FB_ATTR_TIMESTAMP_FORMAT, '%s')
for timestamp values

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 />';
}?>

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.

Firebird(PDO)

简介

安装

预定义常量

Table of Contents