db interface

Anon

Does PHP4 have a common database interface? I want to be able to write an application that can be used for any database server, msql, mysql, postgres etc.

I was told that version 4 would have something like this built in. I may be mis informed though.

Anon

Sorray man... This is the main fault of PHP

There's a different syntax for each type of database
Example:

ORACLE:

$select = "select * from table";
$dood = ora_parse($select);

MYSQL:

$select = "select * from table";
$dood = mysql_query($select);

Ive been bitching about this one for a while
Hopefully iy'll be phyxed soon

Anon

There are many wrapper classes and the like out there. You can easily write one yourself, though - that way you have one, and then you can give it to other people to use. I had one that I wrote, and LOVED, but now it's gone...HD failed.

Anon

That bites. I know that there is a very popular one out there (I can't remember what it is called though). I was talking to someone who has met and spoken to Rasmus Lerdorf, and apparently he said that while it is good it is slower as it is essentially another layer on top of PHP (speed is essential in my project). I also got the impression one will be built into PHP. I was hoping it would be done in the current version. I may be wrong though.

I guess I will have to try and write my own. Difficult as I don't have many db servers to test it on.

Thanks anyway.