Subject RE: [IBDI] A suggestion
Author John.Hubbard@Gunter.AF.mil
Pre-built?!? What kind of amatuer do you think I am? :) I was not
suggesting that this had anything to do with IB's API, merely that it might
be a good direction for some of our efforts. It's my feeling that IB
support was originally added to PHP/FI, and maintenance on it has slowly
faded away.
First, specifics on "Not at all." It seems that ibase_connect() and
ibase_pconnect both work, because if I muck up the path name or purpose it
throws me an I/O error about not being able to find the .gdb file. This is
good. It's when I try to retrieve data by executing an ibase_query() and
manipulating the result that something goes wrong. I do print the values
of $db_conn, $result, and $row, the first two give me integer values, the
third gives me 'Array'. It's when I try to retrieve values out of this
array that things go south. Nothing gets printed (and yes, I tried my SQL
statement in ISQL, it returns a recordset). If I change ibase_fetch_row()
to ibase_fetch_object() I get that "Server returned an invalid or
unrecognized response" popup from my browser. I also get that error if I
try to refer to the array elements using ordinals rather than strings.
I also tried wiping out my Apache/PHP install and re-building the whole
thing, to no avail. Same problem.
So I inserted some HTML content above my script. Now my browser says "The
download of the specified resource has failed". A 'View Source' shows that
the script died, there is no '</body></html>' at the end and none of the
script output is in the file.

-----Original Message-----
From: Vince Duggan [mailto:vince@...]
Sent: Friday, April 07, 2000 2:28 AM
To: IBDI@egroups.com
Subject: Re: [IBDI] A suggestion


Hi John,

I am not sure of the differences between PHP3 and PHP4 when it comes to
add on modules, so it may be too much to expect the IB module within
PHP3 to work with PHP4. However...

I am pretty sure that the fact that PHP4 is not working with Interbase
has nothing to do with the Interbase version. The Interbase module for
PHP3 was written apparently for Interbase 4. I have it (PHP3) working
with no problems on RH 6.1 with Interbase 5.6 I'll try it today with
IB6(beta). Since one typically builds PHP specifically with Interbase
enabled i.e:

./configure --with-interbase=/usr/interbase

it builds using the version of ibase.h and gdsxxx.so on the machine. As
Ann pointed out, Interbase go to major lengths to make sure that the API
is backward and forward compatible. Certainly I have never had any
problems compiling API apps under different versions of Interbase.

I suggest you have one of a number of different problems:

1. You are using a pre-built PHP4, which has been built without the
Interbase support included.

2. You are using a pre-built PHP4, which has been built with a previous
version of Interbase, and the libraries don't match up.

3. You have built PHP4 yourself with the correct Interbase version
included, and it doesn't work for one of three reasons:
a) The PHP4 Interbase module is buggy (quite likely)
b) The PHP4 Interbase module has not been looked at since PHP3 -
(also quite likely)
c) You have configured something else (such as Apache) incorrectly
so that nothing in PHP4 works (unlikely).

I'd like to hear exactly how it is not working...

Vince


John.Hubbard@... wrote:
>
> This is kind of off the cuff, but it may be a project worthy of calling
on
> your userbase for help with.
> I installed SuSE Linux on a machine so I could play with the new IB 6.0
> SuperServer package. IB installed fine, and works fine. The goal was to
see
> how well IB 6 works with PHP 4.0(which supports IB, at least version 4).
> Unfortunately, it doesn't work at all with IB 6.
> I know very little about C/C++, I've always been a little intimidated by
> it, but I printed out the API Ref and I'm hoping that I can at least
figure
> out what's missing. For the developers, and you probably already know
this,
> PHP is a hugely popular web scripting engine. There are legions of
> potential IB users among PHP's ranks.
> So, I'm putting out the call for anybody on this list with some C/C++
> experience to take a look at this problem. I'm a rank amatuer, so any
> advice/help you could send my way would be hugely appreciated. TIA
>
> Thatcher Hubbard
>
> ------------------------------------------------------------------------
> PERFORM CPR ON YOUR APR!
> Get a NextCard Visa, in 30 seconds! Get rates as low as
> 0.0% Intro or 9.9% Fixed APR and no hidden fees.
> Apply NOW!
> http://click.egroups.com/1/2121/3/_/679568/_/955053874/
> ------------------------------------------------------------------------
>
> Community email addresses:
> Post message: IBDI@onelist.com
> Subscribe: IBDI-subscribe@onelist.com
> Unsubscribe: IBDI-unsubscribe@onelist.com
> List owner: IBDI-owner@onelist.com
>
> Shortcut URL to this page:
> http://www.onelist.com/community/IBDI

--
Vince Duggan
Synectics Software
Inprise C/S Business Partner
South Africa
http://www.synectics.co.za
mailto:vince@...

------------------------------------------------------------------------
LOW RATE, NO WAIT!
Get a NextCard Visa, in 30 seconds! Get rates
as low as 2.9% Intro or 9.9% Fixed APR and no hidden fees.
Learn more at:
http://click.egroups.com/1/937/3/_/679568/_/955092511/
------------------------------------------------------------------------

Community email addresses:
Post message: IBDI@onelist.com
Subscribe: IBDI-subscribe@onelist.com
Unsubscribe: IBDI-unsubscribe@onelist.com
List owner: IBDI-owner@onelist.com

Shortcut URL to this page:
http://www.onelist.com/community/IBDI