====== Firebird en PHP ======

Doc: [[https://www.php.net/manual/en/ref.pdo-firebird.php]]

===== Installation =====

<code bash>
sudo apt install php-interbase
</code>

Ceci installe également les librairies clientes pour l'accès à Firebird.

<code bash>
sudo vi /etc/php/7.4/apache2/php.ini
</code>

<code ini>
extension=pdo_firebird
</code>

<code bash>
sudo systemctl reload apache2.service
</code>

===== Connexion =====

<code php>
<?php

$dbname = 'firebird:dbname=servername:/path/to/database.fdb';
$dbuser = 'sysdba';
$dbpass = '******';

try {

    // Connexion
    $db = new \PDO($dbname, $dbuser, $dbpass, [
        \PDO::ATTR_ERRMODE => \PDO::ERRMODE_EXCEPTION
    ]);
    
    ...
    
    // Déconnexion
    $db = null;
}
catch(\PDOException $e) {
    echo $e->getMessage();
}
</code>

===== Requêtes =====

<code php>
$res = $db->query("SELECT nom, prenom FROM personnel;");

if($res !== false) {
    foreach($res as $row) {
        echo $row['NOM'];
        echo $row['PRENOM'];
    }
}
</code>