Prérequis
- Avoir déja installé le driver db2 voir ici
- Télécharger les sources PDO_IBM-1.3.3 sur http://pecl.php.net/package/PDO_IBM
Etape 1: compiler le module
tar -zxf /tmp/PDO_IBM-1.3.3.tgz
cd PDO_IBM-1.3.3/
phpize --clean
phpize
cp /opt/IBM/dsdriver/include/* .
./configure --with-pdo-ibm=/opt/IBM/dsdriver/lib
make
sudo make install
Etape 2: Installer le module
echo "extension=pdo_ibm.so" > /etc/php.d/pdo_ibm.ini
Etape 3: Tester !
<?php
$database = 'test';
$user = 'test';
$password = 'test';
$hostname = 'localhost';
$port = 50000;
$string= sprintf("ibm:DRIVER={IBM DB2 ODBC DRIVER};DATABASE=%s;HOSTNAME=%s;PORT=%d;PROTOCOL=TCPIP;",
$database ,
$hostname ,
$port);
try {
$connection = new PDO(
$string,$user,$password);
$req=$connection->query("select * from table");
foreach ($req as $row) {
print_r($row);
}
}
catch (Exception $e) {
echo($e->getMessage());
}
?>
Aucun commentaire:
Enregistrer un commentaire