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

Reply via email to