Subject | Problems conecting to Firebird 1.5 with PHP in RedHat 9 |
---|---|
Author | Kamus |
Post date | 2004-05-20T17:39:33Z |
Hi everybody.
I have problems conecting to Firebird 1.5 from PHP (4.3.5)
I do this this:
1.- install Firebird 1.5
# rpm -Uvh FirebirdSS-1.5.0.4290-0.i686.rpm
the install path is /opt/firebird
2.- Change the SYSDBA password to "masterkey" with the changeDBAPassword.sh
script
3.- Download source code of php (php-4.3.5.tar.bz2).
4.- Extract php-4.3.5.tar.bz2 to /home/julio
5.- # cd /home/julio/php-4.3.5
6.- # ./configure --with-interbase=shared,/opt/firebird
7.- # make
8.- # cp modules/interbase.so /usr/lib/php4
9.- # cd /etc/php.d
10.- # touch firebird.ini
I edit firebird.ini and add this line:
extension=interbase.so
*** This step is necesary for apache-2.0.X
11.- # service httpd restart
12.- I run the following script:
<?
// Script: listar.php
$host = "localhost:/opt/firebird/examples/employee.fdb";
$usuario = "sysdba";
$password = "masterkey";
$conexion = ibase_connect($host,$usuario,$password);
$sql = "select * from country";
$resultado = ibase_query($sql);
while ($fila = ibase_fetch_row($resultado)) {
echo $fila[0].' '.$fila[1].'<br />';
}
?>
But nothing happens. None messages of errors.
With "isql" I connect to same DataBase without problems.
Please help me !!!
*** Sorry about my english, I'm from BOLIVIA ****
__________________________________________
Julio Carlos Canaviri C.
e-mail : e18278@...
Linux Registered User #306526
_____________________________________
I have problems conecting to Firebird 1.5 from PHP (4.3.5)
I do this this:
1.- install Firebird 1.5
# rpm -Uvh FirebirdSS-1.5.0.4290-0.i686.rpm
the install path is /opt/firebird
2.- Change the SYSDBA password to "masterkey" with the changeDBAPassword.sh
script
3.- Download source code of php (php-4.3.5.tar.bz2).
4.- Extract php-4.3.5.tar.bz2 to /home/julio
5.- # cd /home/julio/php-4.3.5
6.- # ./configure --with-interbase=shared,/opt/firebird
7.- # make
8.- # cp modules/interbase.so /usr/lib/php4
9.- # cd /etc/php.d
10.- # touch firebird.ini
I edit firebird.ini and add this line:
extension=interbase.so
*** This step is necesary for apache-2.0.X
11.- # service httpd restart
12.- I run the following script:
<?
// Script: listar.php
$host = "localhost:/opt/firebird/examples/employee.fdb";
$usuario = "sysdba";
$password = "masterkey";
$conexion = ibase_connect($host,$usuario,$password);
$sql = "select * from country";
$resultado = ibase_query($sql);
while ($fila = ibase_fetch_row($resultado)) {
echo $fila[0].' '.$fila[1].'<br />';
}
?>
But nothing happens. None messages of errors.
With "isql" I connect to same DataBase without problems.
Please help me !!!
*** Sorry about my english, I'm from BOLIVIA ****
__________________________________________
Julio Carlos Canaviri C.
e-mail : e18278@...
Linux Registered User #306526
_____________________________________