PHP Australia Conference 2015

Firebird/Interbase Functions (PDO_FIREBIRD)

Introduction

Warning

This extension is EXPERIMENTAL. The behaviour of this extension including the names of its functions and any other documentation surrounding this extension may change without notice in a future release of PHP. This extension should be used at your own risk.

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

Installation

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

Predefined Constants

The constants below are defined by this driver, and will only be available when the extension has been either compiled into PHP or dynamically loaded at runtime. In addition, these driver-specific constants should only be used if you are using this driver. Using driver-specific attributes with another driver may result in unexpected behaviour. PDO::getAttribute() may be used to obtain the PDO_ATTR_DRIVER_NAME attribute to check the driver, if your code can run against multiple drivers.

PDO::FB_ATTR_DATE_FORMAT (integer)

فراهم شده از PHP 5.3.0.

تعیین قالب تاریخ.

PDO::FB_ATTR_TIME_FORMAT (integer)

تعیین قالب زمان.

فراهم شده از PHP 5.3.0.

PDO::FB_ATTR_TIMESTAMP_FORMAT (integer)

تعیین قالب برچسب زمان.

فراهم شده از PHP 5.3.0.

Table of Contents

add a note add a note

User Contributed Notes 4 notes

up
0
Anonymous
2 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
0
mark-php at vectrex dot org dot uk
7 years ago
If you have a database alias on the server "localhost" called "test.fdb", you can do:

$conn = new PDO("firebird:dbname=localhost:test.fdb",
                'SYSDBA','letmein');

Note that as of the time of writing, the Firebird driver doesn't correctly throw an exception on connection error

http://bugs.php.net/bug.php?id=41522
up
0
thomas at last-it dot de
8 years ago
if youre dsn syntax is wrong, see ritsaert's comment, there maybe no errormessage!
up
0
ritsaert at continuit dot nl
8 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