Subject Re: Request for help
Author Johan van Zyl
--- In, "David at PFI"
<firebird-php-david@p...> wrote:
> Hello all. I have hit a deadend with compiling the infamous
> file.
> Environment=
> Redhat 9.0,
> Apache 2.0.52,
> MySQL 4.0.21,
> PHP 4.3.9
> Codecharge Studio 2.3
> Xampp 1.4.9a
> I use the xampp/codecharge environment to develop in.
> ( Although I have tryed to make Firebird 1.5
> work with PHP in even different config I can think of separate from
> Xampp. I must be missing something, because when I follow the
> instructions I have found in various places for compiling PHP with
> interbase aka firebird support, everything says it is supposed to
> reference a file in modules/extensions. Well no matter
> how I compile it with make, it never produces this file. Hence PHP
> barfs when it tryed to load the module and it is not there.
> Does anyone have a copy of that was compiled with the
> above considerations that they could email me? I am assuming that
> this will allow my PHP code to talk to Firebird server side? If I am
> missing something please feel free to comment.
> Any help is appreciated.
> Thank you,
> David
I dont konw if this will help you, but this cfm works for me.
I develop on Win 2000 Pro PC with Dreamweaver but the cfm is saved on
Linux Box (SME)

<title> Database Test </title>
<big><u>Status Report on table USER</u><br></big>
<table border>
print "Connected to";

$host = "/opt/firebird/examples/employee.fdb";

$username = "SYSDBA";
$password = "masterkey";
$dbh = ibase_pconnect ($host, $username, $password);
$sth = ibase_query ($dbh, $stmt);
$time = gettimeofday ();

print " ".$host." at ".$time['sec']." <br>";
<table border>
<td> <b>Name</b></td>
<td> <b>Alias</b></td>
<td> <b>Relation</b></td>
<td> <b>Length</b></td>
<td> <b>Type</b></td>
$coln = ibase_num_fields($sth);
for ($i=0; $i < $coln; $i++)
$col_info = ibase_field_info($sth, $i);
print "<tr>\n";
print "<td> ".$col_info['name']." </b></td>";
print "<td> ".$col_info['alias']." </b></td>";
print "<td> ".$col_info['relation']." </b></td>";
print "<td> ".$col_info['length']." </b></td>";
print "<td> ".$col_info['type']." </b></td>";
print "<tr>\n";
<big><u>Table Contents</u></big><br><br>

<table border>
<td> <b>First</b></td>
<td> <b>Last</b></td>
while ($row = ibase_fetch_row ($sth))
{ print "<tr>";
print "<td> ".$row[0]. " </b></td>";
print "<td> ".$row[1]. " </b></td>";
print "<tr>";
ibase_close ($dbh);