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