--- In firebird-php@yahoogroups.com, "lee_domain" <lee_domain@...> wrote:

>
> I am trying to build a Bird Nets with
> FirebirdSS-2.1x + Apache-2.2.4 + PHP-5.2.3
> Problem comes when
> LoadModule module_php5 modules/libphp5.so
> is added to httpd.conf

------------------------------

With the help of many Firebird lovers, I have found a work-around,
thanks to you all.

Following is a test:

<!-- connect to a firebirdb database and select something:
consel_fb.php --->

<?php

//connect to a database on fb server FBSS-2.1
$srv_db = 'localhost:/home/myname/employee.fdb';
$usrname = 'sysdba';
$pswd = 'masterkey';

// get and report connection result
$conn = fbird_connect($srv_db, $usrname, $pswd);
echo $conn."<br>";

// issue SQL query command, show returned results on console
// particularly test some FB2.0/2.1 additionals, such as ROWS

$sql = 'SELECT COUNTRY FROM COUNTRY ROWS 2 To 5';
$res = fbird_query($conn, $sql);
while ( $row = fbird_fetch_object($res) )
{
echo $row->COUNTRY."<br>";
}

// relaese the results
fbird_free_result($res);

// close the connected database, and report result
$closedb = fbird_close($conn);
echo $closedb;

?>

Resource id #2
England
Canada
Switzerland
Japan
1

Of course the work-around is still far away from perfection, needing
some improvements, and more test.

If you would like to test any other php script on FB2.1, please post
them here, it will be a pleasure for me to test it together with you.

Thanks to you all again
Yours
O'Li