OCI_STATEMENT_TYPE(3)OCI_STATEMENT_TYPE(3)oci_statement_type - Returns the type of a statementSYNOPSIS
string oci_statement_type (resource $statement)
DESCRIPTION
Returns a keyword identifying the type of the OCI8 $statement.
PARAMETERS
o $statement
- A valid OCI8 statement identifier from oci_parse(3).
RETURN VALUES
Returns the type of $statement as one of the following strings.
Statement type
Returns FALSE on error.
EXAMPLES
Example #1
oci_statement_type(3) 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);
?>
PHP Documentation Group OCI_STATEMENT_TYPE(3)
Check Out this Related Man Page
OCI_FETCH(3)OCI_FETCH(3)oci_fetch - Fetches the next row from a query into internal buffersSYNOPSIS
bool oci_fetch (resource $statement)
DESCRIPTION
Fetches the next row from a query into internal buffers accessible either with oci_result(3), or by using variables previously defined
with oci_define_by_name(3).
See oci_fetch_array(3) for general information about fetching data.
PARAMETERS
o $statement
-A valid OCI8 statement identifier created by oci_parse(3) and executed by oci_execute(3), or a REF CURSOR statement identifier.
RETURN VALUES
Returns TRUE on success or FALSE if there are no more rows in the $statement.
EXAMPLES
Example #1
oci_fetch(3) with defined variables
<?php
$conn = oci_connect('hr', 'welcome', 'localhost/XE');
if (!$conn) {
$e = oci_error();
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
$sql = 'SELECT location_id, city FROM locations WHERE location_id < 1200';
$stid = oci_parse($conn, $sql);
// The defines MUST be done before executing
oci_define_by_name($stid, 'LOCATION_ID', $locid);
oci_define_by_name($stid, 'CITY', $city);
oci_execute($stid);
// Each fetch populates the previously defined variables with the next row's data
while (oci_fetch($stid)) {
echo "Location id $locid is $city<br>
";
}
// Displays:
// Location id 1000 is Roma
// Location id 1100 is Venice
oci_free_statement($stid);
oci_close($conn);
?>
Example #2
oci_fetch(3) with oci_result(3)
<?php
$conn = oci_connect('hr', 'welcome', 'localhost/XE');
if (!$conn) {
$e = oci_error();
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
$sql = 'SELECT location_id, city FROM locations WHERE location_id < 1200';
$stid = oci_parse($conn, $sql);
oci_execute($stid);
while (oci_fetch($stid)) {
echo oci_result($stid, 'LOCATION_ID') . " is ";
echo oci_result($stid, 'CITY') . "<br>
";
}
// Displays:
// 1000 is Roma
// 1100 is Venice
oci_free_statement($stid);
oci_close($conn);
?>
NOTES
Note
Will not return rows from Oracle Database 12 c Implicit Result Sets. Use oci_fetch_array(3) instead.
SEE ALSO oci_define_by_name(3), oci_fetch_all(3), oci_fetch_array(3), oci_fetch_assoc(3), oci_fetch_object(3), oci_fetch_row(3), oci_result(3).
PHP Documentation Group OCI_FETCH(3)