PHP and ORACLE ?

NickJ

Hi,

Bit of a newbie to PHP.

I'm quite familiar with the ORACLE database engine but all the books, tutorials, documentation, etc, seems to refer to MY SQL.

Why is this?

Thanks guys.

Norman_Graham

Hi Nick

Because MySQL is free, at least for non-commercial applications, while Oracle certainly isn't. Also, the native MySQL support offered by PHP is quite extensive, whereas the native Oracle functions aren't quite so comprehensive.

Those would seem to be the reasons IMHO.

However, there's absolutely no reason why you shouldn't use Oracle and PHP.

Btw - there's a thing called ADOdb which is a DB abstraction layer for PHP such that you can use exactly the same code to query any database - you only have to change the connection parameters. It's available at http://php.weblogs.com. There's a tutorial and documentation there. Also, it's just an extensive class, so you don't have to reconfigure to make it work.

HTH

Norm

LordShryku

Originally posted by Norman Graham
Also, the native MySQL support offered by PHP is quite extensive, whereas the native Oracle functions aren't quite so comprehensive.

The first batch of Oracle functions, this is true. The OCI8 functions on OTOH, are pretty good....

MySQL is good for web developers. Most of them don't need a huge powerhouse database like Oracle. They're going to be storing simple information, in simple tables, using simple SQL. No need for the complexities that Oracle brings to the table. Then for the one's that do need a more powerful database, most people use PostgreSQL. It's free, standard in almost all *nix builds, and provides a lot of the functions that Oracle will give.

amrigo

I have found several tutorials about php and oracle "by the power of google"