Hi,
ok while talking to marcus about sqlite it came up again that some ext
have different function names for similar things which is really
unnecessary. Here is a list of some most used (just a guestimate)
functions. I used the mysql extension as the basis for the most part.
Some functions obviously don't exist in the ext because the underlying
RDBMS doesn't support it (like prepared queries, autoincrement and
selecting a database etc.).
Please correct me where I am wrong. Some query() functions might be
actually be unbuffered_query() etc. And while doing such a boring work
you tend to make mistakes. Finally I don't know all API's by heart nor
have I used all of them.
Finally I want to mention again that I only looked at the function names
and not at stuff like parameter order etc where I expect to be even more
needless API differences.
I removed the ext prefix for obvious reasons and I put diverging names,
ext where there is no equivalent function or other comments in
parenthesis:
- affected_rows
missing in ibase, ingress, odbc, ora
sqlite_changes
mssql_rows_affected
ocirowcount
- bind
missing in ifx
handled by execute in ibase, odbc
mssql uses this method to handle stored procdures
mysqli_bind_param
ocibindbyname
prepared not supported by fbsql, ingres, mssql, msql, mysql, pg,
sqlite, sybase
- close
ocilogoff
- connect
ocilogon
oralogon
sqlite_open
- data_seek
missing in ifx, ibase, ingress, odbc, oci, ora, pg
sqlite_seek - due to spl
- errno
ifx_error
odbc_error
ora_errorcode
missing in ibase, ingress, mssql, msql, oci, pg, sqlite, sybase
- error
ifx_errormsg
ibase_errmsg
mssql_get_last_message
sybase_get_last_message
odbc_errormsg
ocierror
pg_last_error
sqlite_error_string
missing in ingres
- escape_string
missing in fbsql, ifx, ibase, ingress, mssql, msql, odbc, oci, ora,
sybase
mysqli_real_escape_string
- execute
ifx_do
mssql uses this method to handle stored procedures
ociexecute
ora_exec
prepared not supported by fbsql, ingres, mssql, msql, mysql, pg,
sqlite, sybase
- fetch_array
missing in ifx, ibase
ocifechtino
ora_fetch_into
- fetch_assoc
ifx_fetch_row
missing in ingress, msql, odbc, oci, ora, sqlite
- fetch_object
missing in ifx, oci, ora, sqlite
- fetch_row
missing in ibase, oci, ora, sqlite
- free_query
missing in ifx, mysqli, odbc, ora
mysqli_stmt_close
ocifreecursor
prepared not supported by fbsql, ingres, mssql, msql, mysql, pg,
sqlite, sybase
- free_result
ocifreestatement
missing in ingress, ora, sqlite
- insert_id
sqlite_last_insert_rowid
not supported by ifx, ibase, ingres, mssql*, msql, odbc, oci, ora,
pg, sybase*
- next_result
only exists in fbsql and mssql
- num_fields
ocinumcols
ora_numcols
- num_rows
missing since buffering is not supported in ibase, oci
ora_numrows
- pconnect
missing because it was found to be not feasible in mysqli
ora_plogon
ociplogon
sqlite_popen
- prepare
ociparse
ora_parse
prepared not supported by fbsql, ingress, mssql, mysql, pg, sqlite,
sybase
- query
is unbuffered in ibase
pg_send_query
missing in odbc, oci, ora
- result
missing in ifx, ibase, ingres, mysqli, oci, ora, sqlite
- select_db
missing in ifx, ibase, ingres, odbc, oci, ora, pg, sqlite
- unbuffered_query
missing in fbsql, ifx, ingres, mssql, msql, odbc, ora, pg
ibase_query
ociexecute
regards,
Lukas Smith
[EMAIL PROTECTED]
_______________________________
BackendMedia
www.backendmedia.com
[EMAIL PROTECTED]
Linn Zwoch Smith GbR
Pariser Str. 44
D-10707 Berlin
Tel +49 30 83 22 50 00
Fax +49 30 83 22 50 07
--
PHP Internals - PHP Runtime Development Mailing List
To unsubscribe, visit: http://www.php.net/unsub.php
