Instructions for using ORACLE functions in PHP

OCIDefineByName
Allow the SELECT command to use PHP variables.
Syntax: boolean OCIDefineByName (int stmt, string ColumnName, mixed & variable, int [type]);
Return Value: Boolean Value
Function Type: Database Function

Description
This function is used to define the specified PHP variable so that it can be used by the SELECT command in the SQL command. Pay attention to the Case sensitivity issue, because the column names in the Oracle database are actually capital names. The stmt parameter is a string indicator after Oracle resolution (OCIParse. The ColumnName parameter is the column name in the Oracle data table. Before the variable parameter, you must add the & symbol to the table PHP variable address. The type parameter is usually omitted. It is worth noting that the OCINewDescriptor () function must be executed before you use the LOB, ROWID, and BFILE Data Types in Oracle 8. If this function is successfully executed, the return value is true.
OCIBindByName
Allows dynamic SQL to use PHP variables.
Syntax: boolean OCIBindByName (int stmt, string ph_name, mixed & variable, int length, int [type]);
Return Value: Boolean Value
Function Type: Database Function
Description
This function is used to define the specified PHP variable so that it can be used by dynamic SQL commands (Oracle Placeholder. Pay attention to the Case sensitivity issue, because the column names in the Oracle database are actually capital names. The stmt parameter is a string indicator after Oracle resolution (OCIParse. The ph_name parameter is the variable used by the dynamic SQL command. Before the variable parameter, you must add the & symbol to the table PHP variable address. The parameter length is the data length. If it is set to-1, the maximum value of the specified variable data is used. The parameter type can be omitted. Its values include OCI_ B _FILE, OCI_ B _CFILE, OCI_ B _CLOB, OCI_ B _BLOB, and OCI_ B _ROWID (ROWID. It is worth noting that the OCINewDescriptor () function must be executed before using the LOB, ROWID, and BFILE Data Types in Oracle 8, and the length parameter must be set to-1. If this function is successfully executed, the return value is true.
OCILogon
Enable the connection to Oracle.
Syntax: int OCILogon (string username, string password, string [OCACLE_SID]);
Return Value: integer
Function Type: Database Function
Description
This function establishes a connection between PHP and Oracle. The username and password parameters are the connected accounts and passwords respectively. The OCACLE_SID parameter is the database name, which can be omitted. The code with the returned value being a line.
OCILogOff
Close the connection to Oracle.
Syntax: boolean OCILogOff (int connection );
Return Value: Boolean Value
Function Type: Database Function
Description
This function ends the connection between PHP and Oracle. The connection parameter is the connection code connecting to Oracle. If the return value is true, the return value is successful. If the return value is false, an error occurs.
OCIExecute
Command section for executing Oracle.
Syntax: boolean OCIExecute (int statement, int [mode]);
Return Value: Boolean Value
Function Type: Database Function
Description
This function is used to execute the specified Oracle command segment. Before execution, you must first analyze the SQL Syntax of this segment by OCIParse. The statement parameter is the parsed code. The mode parameter can be omitted. The value is OCI_COMMIT_ON_SUCCESS. If the return value is true, the return value is successful. If the return value is false, an error occurs.
OCICommit
Put Oracle transaction processing into practice.
Syntax: boolean OCICommit (int connection );
Return Value: Boolean Value
Function Type: Database Function
Description
This function permanently modifies the last transaction after commit/rollback. The connection parameter is the connection code connecting to Oracle. If the return value is true, the return value is successful. If the return value is false, an error occurs.
OCIRollback
Cancel the current transaction.
Syntax: boolean OCIRollback (int connection );
Return Value: Boolean Value
Function Type: Database Function
Description
This function cancels the modification made to the database by Oracle transaction Processing (transaction. The connection parameter is the connection code connecting to Oracle. If the call succeeds, true is returned, and false is returned.
OCINumRows
Obtain the number of affected columns.
Syntax: int OCINumRows (int statement );
Return Value: integer
Function Type: Database Function
Description
This function returns the number of columns affected by commands such as UPDATE. If you use SQL commands such as SELECT, this function does not affect the number of columns. The statement parameter is the parsed code.
OCIResult
Obtain a column from the data of the current column (row ).
Syntax: string OCIResult (int statement, mixed column );
Return Value: String
Function Type: Database Function
Description
This function is used to return a column of data. The statement parameter is the parsed code. The column parameter is the column name. If the new data format (ROWIDs, LOBs, and FILEs) is used, the returned data is also a string.
OCIFetch
Returns a row ).
Syntax: int OCIFetch (int statement );
Return Value: integer
Function Type: Database Function
Description
This function is used to obtain a column of non-empty data. The statement parameter is the parsed code. If the return value is true, a column is retrieved successfully. If the return value is false, the column is empty or other errors occur.
OCIFetchInto
Retrieve Oracle data and place it in the array.
Syntax: int OCIFetchInto (array & result, int [mode]);
Return Value: integer
Function Type: Database Function
Description

This function puts the data retrieved from Oracle into the array result. Returns the number of bits in each column. If it fails, false is returned. The mode parameter can be omitted. The internal value is OCI_NUM, and other parameters include OCI_ASSOC, OCI_RETURN_NULLS, and OCI_RETURN_LOBS.
OCIColumnIsNULL
Test whether the returned row is null.
Syntax: boolean OCIColumnIsNULL (int stmt, mixed column );
Return Value: Boolean Value
Function Type: Database Function
Description
This function is used to test whether the returned row (column) is NULL ). Return true to indicate a null value.
OCIColumnSize
Obtains the size of the column type.
Syntax: int OCIColumnSize (int stmt, mixed column );
Return Value: integer
Function Type: Database Function
Description
This function obtains the size of the column type.
OCINewDescriptor
Initial new LOB/FILE description.
Syntax: string OCINewDescriptor (int connection, int [type]);
Return Value: String
Function Type: Database Function
Description
This function is used to initialize a new LOB/FILE description value.
OCIParse
Analyze SQL syntax.
Syntax: int OCIParse (int connection, string query );
Return Value: integer
Function Type: Database Function
Description
This function can be used to analyze SQL syntax or PL/SQL section errors. The connection parameter is the connection code. The query parameter is an SQL command string. <Script language = JavaScript src = "/netbei/x/view_a2.js"> </script>