oci_statement_type

(PHP 5)

oci_statement_type -- Returns the type of an OCI statement

Beschreibung

string oci_statement_type ( resource statement )

Returns the type of the provided OCI statement.

Parameter Liste

statement

A valid OCI statement identifier.

Rückgabewerte

Returns the query type ofstatement as one of the following values:

  1. SELECT

  2. UPDATE

  3. DELETE

  4. INSERT

  5. CREATE

  6. DROP

  7. ALTER

  8. BEGIN

  9. DECLARE

  10. CALL (since PHP 5.2.1 and OCI8 1.2.3)

  11. UNKNOWN

Returns FALSE on error.

Beispiele

Beispiel 1. oci_statement_type() example

<?php
    $conn
= oci_connect("scott", "tiger");
    
$sql  = "delete from emp where deptno = 10";

    
$stmt = oci_parse($conn, $sql);
    if (
oci_statement_type($stmt) == "DELETE") {
        die(
"You are not allowed to delete from this table<br />");
    }

    
oci_close($conn);
?>

Anmerkungen

Anmerkung: In PHP versions before 5.0.0 you must use ocistatementtype() instead. This name still can be used, it was left as alias of oci_statement_type() for downwards compatability. This, however, is deprecated and not recommended.