PHP
downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

ocibindbyname> <oci_set_prefetch
Last updated: Fri, 05 Sep 2008

view this page in

oci_statement_type

(PHP 5, PECL oci8:1.1-1.2.4)

oci_statement_typeReturns 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

Hinweis: 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.



add a note add a note User Contributed Notes
oci_statement_type
There are no user contributed notes for this page.

ocibindbyname> <oci_set_prefetch
Last updated: Fri, 05 Sep 2008
 
 
show source | credits | stats | sitemap | contact | advertising | mirror sites