sudo apt install php-interbase
Ceci installe également les librairies clientes pour l'accès à Firebird.
sudo vi /etc/php/7.4/apache2/php.ini
extension=pdo_firebird
sudo systemctl reload apache2.service
<?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(); }
$res = $db->query("SELECT nom, prenom FROM personnel;"); if($res !== false) { foreach($res as $row) { echo $row['NOM']; echo $row['PRENOM']; } }