PHP4 & Oracle
Andy Hassall
>I'm working on a project and I heard that Oracle and PHP4 are not
>compatible.
Don't know where you heard this; I've had PHP4 working fine with Oracle 8.1.7,
9.0.1 and 9.2.0.
The only serious problem I've seen is with persistent connections (OCIPLogon
as opposed to OCILogon) when the database server restarts whilst PHP has some
connections open; it doesn't always reconnect the existing persistent
connections in the pool.
There's a workaround listed, using a failover in your TNS entry:
http://bugs.php.net/bug.php?id=16502
>Can somebody acknowledge this and have you got any
>experience with PHP3 & Oracle, in other words have you got some
>interesting url's for me. I don't find that much on helpfull.
No idea about PHP3, since it's so ancient now.
http://www.php.net/manual/en/ref.oci8.php
--
Andy Hassall (an...@andyh.org) icq(5747695) http://www.andyh.org
http://www.andyhsoftware.co.uk/space | disk usage analysis tool
Marc Thomas
I've a number of thin client applications that use PHP4 against Oracle
8.1.x and have had no problems at all.
If you want to achieve a degree of database transparancy (i.e. you want your
web pages to be transportable to different database backends) you might want
to consider ADODB (http://php.weblogs.com/) which provides a rather nice
abstraction layer. However, you need to consider the trade-offs between a
consistant and transportable database infrastructure vs the potential
performance gains acheivable if you code for a dedicated RDBMS backend.
Anyway I think I've done my bit for the open source community ;)
Regards
"@did" <ad...@pandora.ns.be> wrote in message
news:3voasuoj32t2hgse4...@4ax.com...
>
> I'm working on a project and I heard that Oracle and PHP4 are not
> compatible. Can somebody acknowledge this and have you got any
> experience with PHP3 & Oracle, in other words have you got some
> interesting url's for me. I don't find that much on helpfull.
>
> Thx in advance,
>
> C.
Geoff Muldoon
>Hi,
> I've a number of thin client applications that use PHP4 against Oracle
>8.1.x and have had no problems at all.
>
>If you want to achieve a degree of database transparancy (i.e. you want your
>web pages to be transportable to different database backends) you might want
>to consider ADODB (http://php.weblogs.com/) which provides a rather nice
>abstraction layer. However, you need to consider the trade-offs between a
>consistant and transportable database infrastructure vs the potential
>performance gains acheivable if you code for a dedicated RDBMS backend.
The later versions of ADODB cater for bind variables in SQL queries
against Oracle databases, so there are now fewer clear advantages in
using the dedicated OCI8 PHP library.
For consistency of coding standards (we also run a smaller MySQL DB
where the code binding the variables just gets ignored), it's great.
Geoff M