| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re[2]: Oracle/PHP Issue
Edgar, I looked at the package and while it does have certain similarity
to DBI, the essential things like DBI->bind_param,DBI->bind_param_in_out and
DBI->bind_column are, unfortunately, not there, and OCI routines have to be
used directly. Theoretically speaking, it is possible to execute SQL without
bind & define calls, but it would definitely cause mayor problems with the code
design. Below is the list of the DB functions from the PEAR site and, unless
I'm missing something, I don't see anything usable for that purpose.
DB
Table of Contents
Introduction - DSN -- The Data Source Name Introduction - Connect -- Connecting and disconnecting a database Introduction - Portability -- Database portability Introduction - Query -- Performing queries Introduction - Prepare & Execute -- Prepare & Execute/ExecuteMultiple Introduction - autoPrepare & autoExecute -- Automatically prepare and execute SQL statements Introduction - Fetch & Get -- Fetching rows from queries Introduction - Sequences -- Sequences and auto-incrementingDB -- Main class
DB_common -- Interface for database access DB_common::affectedRows() -- Finds the number of affected rows DB_common::autoExecute() -- Automatically performs insert or update queries DB_common::autoPrepare() -- Automatically prepare an insert or update query DB_common::createSequence() -- Create a new sequence DB_common::disconnect() -- Disconnect from a database DB_common::dropSequence() -- Deletes a sequence DB_common::escapeSimple() -- Escape a string according to the current DBMS's standards DB_common::execute() -- Executes a prepared SQL statment DB_common::executeMultiple() -- Repeated execution of a prepared SQL statment DB_common::freePrepared() -- Release resources associated with a prepared SQL statement DB_common::getAll() -- Fetch all rows DB_common::getAssoc() -- Fetch result set as associative array DB_common::getCol() -- Fetch a single column DB_common::getListOf() -- View database system information DB_common::getOne() -- Fetch the first column of the first row DB_common::getRow() -- Fetch the first row DB_common::limitQuery() -- Send a limited query to the database DB_common::nextId() -- Returns the next free id of a sequence DB_common::prepare() -- Prepares a SQL statement DB_common::provides() -- Checks if a DBMS supports a particular feature DB_common::query() -- Send a query to the database DB_common::quote() -- DEPRECATED: Quotes a string DB_common::quoteIdentifier() -- Format string so it can be safely used as an identifier DB_common::quoteSmart() -- Format input so it can be safely used as a literal DB_common::setFetchMode() -- Sets the default fetch mode DB_common::setOption() -- Set run-time configuration options for PEAR DB DB_common::tableInfo() -- Get info about columns in a table or a query result DB_result -- DB result set DB_result::fetchInto() -- Fetch a row into a variable DB_result::fetchRow() -- Fetch a row DB_result::free() -- Release a result set DB_result::nextResult() -- Get result sets from multiple queries DB_result::numCols() -- Get number of columns DB_result::numRows() -- Get number of rows DB_Error -- DB Error object
-- Mladen Gogala Oracle DBA ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Apr 15 2004 - 17:52:18 CDT
 |
 |