changing MySQL functions to Oracle

[Anon]

does anyone know of any reference list that documents MySQL functions and thier equivalent Oracle functions?
for example: mysql_connect() and ocilogin()
i am switching from a MySQL backend to an Oracle DB so i need to change my scripts to the correct Oracle functions.

thanks.

[matto]

go to the php manual, database functions. there's one chapter for every db system supported, such as "mysql functions" and "oracle functions". compare the chapters.

oracle basically uses the same steps that mysql does (connect - execute - fetch - close), except for one: a statement has to be parsed before executed:
connect - parse - execute - fetch - close.