HowTo: Install Firebird/Interbase with PHP on Windows. A step-by-step tutorial.

This simple tutorial assumes you already have a working PHP installation. There's plenty of guides on how to set up PHP, here I'm only showing how to make it interact with Firebird.

PEAR - PHP Extension and Application Repository   PHP.net   Firebird - Database for the new millennium

Requirements

Install Firebird SQL

  • Download the zip archive: Firebird SQL 2.0.0
  • Extract the archive to C:\firebird (for instance)
  • Open a command prompt window (START, Run, "cmd")
  • Run these commands, one by one:
    C:\firebird\bin\instreg i
    C:\firebird\bin\instsvc i -s -a
    C:\firebird\bin\instsvc start

Configure PHP

  • Copy C:\firebird\bin\fbclient.dll to your C:\windows\system32 directory and rename the file to gds32.dll
  • Copy php_interbase.dll from your php\ext directory to the C:\windows\system32 directory.
  • Copy libeay32.dll and ssleay32.dll from your php directory to the C:\windows\system32 directory.
  • Edit your php.ini, un-comment the line
    extension=php_interbase.dll
    (you have to remove the semicolon from that line).
  • Restart your webserver (Apache).

Install some Firebird SQL Tools

You can manage your databases with some tools:

NB: the default admin username:password pair for Firebird is SYSDBA:masterkey.




9 responses to "HowTo: Install Firebird/Interbase with PHP on Windows. A step-by-step tutorial."

* web frontend for the Firebird and InterBase database servers, written in PHP.
NB: the default admin username:password pair for Firebird is SYSDBA:masterkey.

Thank you! Your article helped me to quickly set up php and firebird

Thanks, it was helpful!

Your article helped me to quickly set up php and firebird

Nice this helped me with my Windows System

Thanks a LOT............................

Thanks,

im trying to create a php application to connect to interbase but im using a 64bit system, iv followed your tutorial but i still cant get it to work i get the following error Fatal error: Call to undefined function ibase_connect() in C:\\xampp\\htdocs\\phase\\includes\\config.php on line 11 another thing is where do i get the php_interbase.dll because i cant find it in my php/ext folder !!

the tips here, saved me from a complete nightmare over a complete day!, trying to set up. thanks a lot.

Lorenzo Alberton

Lorenzo Alberton Lorenzo has been working with large enterprise UK companies for the past 10+ years and is currently CTO at DataSift. He's an international conference speaker and a long-time contributor to many open source projects. Lorenzo Alberton's profile on GitHub Lorenzo Alberton's profile on LinkedIN View Lorenzo Alberton's profile on PHP PEAR
View Lorenzo Alberton's Twitter stream Lorenzo Alberton - Sun Certified MySQL 5 Developer PHP5 ZCE - Zend Certified Engineer

Tags

AJAX, Apache, Book Review, Charset, Cheat Sheet, Data structures, Database, Firebird SQL, Hadoop, Imagick, INFORMATION_SCHEMA, JavaScript, Kafka, Linux, Message Queues, mod_rewrite, Monitoring, MySQL, NoSQL, Oracle, PDO, PEAR, Performance, PHP, PostgreSQL, Profiling, Scalability, Security, SPL, SQL Server, SQLite, Testing, Tutorial, TYPO3, Windows, Zend Framework

Buy me a book - The Best Software Writing 1