From oracle-l-bounce@freelists.org Thu Apr 15 17:52:18 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3FMqDa22961 for ; Thu, 15 Apr 2004 17:52:18 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i3FMqD622956 for ; Thu, 15 Apr 2004 17:52:13 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C80A9635030; Thu, 15 Apr 2004 17:33:29 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 10972-98; Thu, 15 Apr 2004 17:33:29 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7830D637F5C; Thu, 15 Apr 2004 16:53:39 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 15 Apr 2004 16:52:20 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 721CB637BF3 for ; Thu, 15 Apr 2004 16:12:56 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26526-71 for ; Thu, 15 Apr 2004 16:12:56 -0500 (EST) Received: from smtp.wangtrading.com (smtp.wangtrading.com [167.206.68.5]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 02653637E44 for ; Thu, 15 Apr 2004 15:55:18 -0500 (EST) Received: from mladen.wangtrading.com (Not Verified[192.168.3.47]) by smtp.wangtrading.com with NetIQ MailMarshal (v5.5.5.8) id ; Thu, 15 Apr 2004 17:04:22 -0400 Received: from mladen (localhost.localdomain [127.0.0.1]) by mladen.wangtrading.com (8.12.8/8.12.8) with ESMTP id i3FL5vfL003986 for ; Thu, 15 Apr 2004 17:05:57 -0400 Date: Thu, 15 Apr 2004 17:05:57 -0400 From: Mladen Gogala To: oracle-l@freelists.org Subject: Re: Re[2]: Oracle/PHP Issue Message-ID: <20040415210557.GE3926@mladen.wangtrading.com> References: <407EAAFF.2090807@tenure.com> <20040415164011.GC3088@mladen.wangtrading.com> <617356156.20040415211015@tsi.lv> Mime-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <617356156.20040415211015@tsi.lv> (from chupit@tsi.lv on Thu, Apr 15, 2004 at 14:10:15 -0400) X-Mailer: Balsa 2.0.17 Lines: 87 X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 3192 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mladen@wangtrading.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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-incrementing DB -- Main class DB::connect() -- Connects to a database DB::isError() -- Determines if a variable is a DB_Error object 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 On 04/15/2004 02:10:15 PM, Edgar Chupit wrote: > Hello Mladen, > > MG> PHP doesn't have anything like DBI which would make database access uniform across the database world. > > PHP does have something called PEAR (http://pear.php.net/) and there > is a package called DB, which currently supports dbase, fbsql, > interbase, informix, msql, mssql, mysql, mysqli, oci8, odbc, pgsql, > sqlite and sybase. But my guess is that this pear thing is still not > very popular. > > > -- > Edgar > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@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 > ----------------------------------------------------------------- > -- Mladen Gogala Oracle DBA ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------