oci_statement_type

(PHP 5, PHP 7, PECL OCI8 >= 1.1.0)
Returns the type of a statement
string oci_statement_type ( resource $statement )

Returns a keyword identifying the type of the OCI8 statement.

Parameters:
statement

A valid OCI8 statement identifier from oci_parse().

Returns:

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

Statement type
Return String Notes
ALTER
BEGIN
CALL Introduced in PHP 5.2.1 (PECL OCI8 1.2.3)
CREATE
DECLARE
DELETE
DROP
INSERT
SELECT
UPDATE
UNKNOWN

Returns FALSE on error.

Examples:
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);

?>

doc_php
2016-02-24 16:17:52
Comments
Leave a Comment

Please login to continue.