OK php and not cfm!<g>
-----Original Message-----
From: Johan van Zyl [mailto:johan@...]
Sent: 15 November 2004 21:11
To: firebird-php@yahoogroups.com
Subject: [firebird-php] Re: Request for help -interbase.so




--- In firebird-php@yahoogroups.com, "David at PFI"
<firebird-php-david@p...> wrote:

>
>
> Hello all. I have hit a deadend with compiling the infamous
> interbase.so 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.
> (www.apachefriends.org) 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 interbase.so 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 interbase.so 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

Hi
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)
Try http://realwebonline.myftp.org/php/

<html>
<head>
<title> Database Test </title>
</head>
<big><u>Status Report on table USER</u><br></big>
<br>
<table border>
<?php
dl("interbase.so");
print "Connected to";

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

$username = "SYSDBA";
$password = "masterkey";
$dbh = ibase_pconnect ($host, $username, $password);
$stmt = "SELECT FIRST_NAME, LAST_NAME FROM EMPLOYEE";
$sth = ibase_query ($dbh, $stmt);
$time = gettimeofday ();

print " ".$host." at ".$time['sec']." <br>";
?>
<br>
<table border>
<tr>
<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>
</tr>
<?php
$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";
}
?>
</table>
<br><br>
<big><u>Table Contents</u></big><br><br>

<table border>
<tr>
<td> <b>First</b></td>
<td> <b>Last</b></td>
</tr>
<?php
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);
?>
</table>
</html>








Yahoo! Groups Sponsor

Get unlimited calls to

U.S./Canada




----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-php/

b.. To unsubscribe from this group, send an email to:
firebird-php-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.796 / Virus Database: 540 - Release Date: 2004/11/13


[Non-text portions of this message have been removed]