oci_statement_type

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

oci_statement_typeReturns the type of a statement

Description

oci_statement_type(resource $statement): string|false

Returns a keyword identifying the type of the OCI8 statement.

Parameters

statement

A valid OCI8 statement identifier from oci_parse().

Return Values

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

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

?>

Here you can write a comment


Please enter at least 10 characters.
Loading... Please wait.
* Pflichtangabe
There are no comments available yet.

PHP cURL Tutorial: Using cURL to Make HTTP Requests

cURL is a powerful PHP extension that allows you to communicate with different servers using various protocols, including HTTP, HTTPS, FTP, and more. ...

TheMax

Autor : TheMax
Category: PHP-Tutorials

Midjourney Tutorial - Instructions for beginners

There is an informative video about Midjourney, the tool for creating digital images using artificial intelligence, entitled "Midjourney tutorial in German - instructions for beginners" ...

Mike94

Autor : Mike94
Category: KI Tutorials

Basics of views in MySQL

Views in a MySQL database offer the option of creating a virtual table based on the result of an SQL query. This virtual table can be queried like a normal table without changing the underlying data. ...

admin

Autor : admin
Category: mySQL-Tutorials

Publish a tutorial

Share your knowledge with other developers worldwide

Share your knowledge with other developers worldwide

You are a professional in your field and want to share your knowledge, then sign up now and share it with our PHP community

learn more

Publish a tutorial