I don't have the time to answer this in more detail, but some of these
calls are just not supported by ODBC (i.e. select_db).  Some are, I just
haven't had the time to commit the patches that create the functionality
and fully test it.

On Wed, 24 Sep 2003, Lukas Smith wrote:

> 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
>
>

>---------------------------------------------------------------<
Dan Kalowsky                    "I thought you died alone,
http://www.deadmime.org/~dank    a long long time ago."
[EMAIL PROTECTED]        - "The Man Who Sold the World"
[EMAIL PROTECTED]                       David Bowie

-- 
PHP Internals - PHP Runtime Development Mailing List
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to