What is PhpDig?
PhpDig is a PHP MySQL based
Web Spider & Search Engine.

ociparse
Prev	XLIII. OCI8 Functions	Next

ociparse

Name

ociparse — Parse a query and return a statement

Synopsis

int ociparse(conn, query); int conn: Connection identifier string query: SQL query

Returns

Explain return value here.

Description

Prases a query and returns a stament handle which can be passed to ociexecute() . Using ociparse() allows the script to bind PHP variables with the query using ocibindbyname() . It is then possible to use ociexecute() multiple times after one call to ociparse() to improve scrpt performance as the overhead of having to call ociparse() each time is reduced. For an example of this, see ocibindbyname() .

Version

Since versions 3.0.4 and 4.0

Example

Example 870. Parse and execute an SQL query

if (!$db = @ocinlogon("dev","dev", "ORCL")) {
    $error = ocierror();
    printf("CONNECT error: %s", $error["message"]);
    die();
}

if (!$stmt = @ociparse($db,"SELECT * FROM phone_numbers")) {
    $error = ocierror($db);
    printf("ociparse error: %s", $error["message"]);
} else {
    if (!@ociexecute($stmt)) {
        $error = ocierror($stmt);
        printf("OCIEXECUTE error:%s", $error["message"]);
    } else {
        ocifetchstatement($stmt, &$rows);
                print_r($rows);
    }
}

Prev	Home	Next
ocinumcols	Up	ociplogon

PHP Functions Essential Reference. Copyright © 2002 by New Riders Publishing (Authors: Zak Greant, Graeme Merrall, Torben Wilson, Brett Michlitsch). This material may be distributed only subject to the terms and conditions set forth in the Open Publication License, v1.0 or later (the latest version is presently available at http://www.opencontent.org/openpub/). The authors of this book have elected not to choose any options under the OPL. This online book was obtained from http://www.fooassociates.com/phpfer/ and is designed to provide information about the PHP programming language, focusing on PHP version 4.0.4 for the most part. The information is provided on an as-is basis, and no warranty or fitness is implied. All persons and entities shall have neither liability nor responsibility to any person or entity with respect to any loss or damage arising from the information contained in this book.