Edit Report a Bug

    oci_statement_type

    (PHP 5, PHP 7, PHP 8, PECL OCI8 >= 1.1.0)

    oci_statement_type — Returns the type of a statement

    Descrizione

    oci_statement_type(resource $statement): string|false

    Returns a keyword identifying the type of the OCI8 statement.

    Elenco dei parametri

    statement

    A valid OCI8 statement identifier from oci_parse().

    Valori restituiti

    Returns the type of statement as one of the following strings.

    Statement type
    Return String Notes
    ALTER  
    BEGIN  
    CALL  
    CREATE  
    DECLARE  
    DELETE  
    DROP  
    INSERT  
    SELECT  
    UPDATE  
    UNKNOWN  

    Returns false on error.

    Esempi

    Example #1 oci_statement_type() example

    <?php

    $conn     = oci_connect('hr', 'welcome', 'localhost/XE');

    $stid = oci_parse($conn, 'DELETE FROM departments WHERE department_id = 130;');
    if (    oci_statement_type($stid) == "DELETE") {
    trigger_error('You are not allowed to delete from this table', E_USER_ERROR);
    }
    else {
    oci_execute($stid); // delete the row
    }

    oci_free_statement($stid);
    oci_close($conn);

    ?>

    add a note add a note

    User Contributed Notes

    There are no user contributed notes for this page.
    To Top