PHP link Oracle function

C_SQL SQL Statement A_BIND Bind Return Value: Boolean Note: This function is just to use intuitive, intrinsically call db_change () Function DB_INSERT ($ c_sql, $ a_bind = ") {RETURN $ THIS -> DB_Change ($ c_sql, $ A_BIND) ); Function name: DB_UPDATE: Update Parameters: c_sql SQL Statement A_BIND Bind Return Value: Boolean Note: This function is just to use intuitive, intrinsically call DB_Change () Function DB_UPDATE ($ C_SQL, $ A_bind = "") {RETURN $ THIS -> DB_Change ($ c_sql, $ a_bind);} function name: db_commit () effect: Transaction submitting parameters: None return value: Boox Note: No function db_commit () {Return (ocicommit ($ this-> i_linkid));} function name: db_rollback () Role: Transaction Retreat: None Return Value: Boolean Note: No function db_rollback () {Return (Ocir Noback ($ this-> i_linkid);} Function Name: DB_LOGOFF () Role: Disconnect Database Connection Parameters: No Return Value: Boolean Note: No Function DB_Logoff () {Return (Ocilogoff ($ this-> i_linkid);}

※ DB_LOGON () Open Database Connection ※ DB_Query () Universal Select ※ DB_Change () Database change Universal Function (Insert, Delete, Update) ※ DB_Insert () Insert, DB_Change () ※ DB_DELETE () DELETE, DB_Change ( ) ※ DB_UPDATE () Update, DB_CHANGE () DB_CHANGE () DB_COMMIT () Transaction Retreat ※ DB_ROLLBACK () Transaction Retreat ※ DB_LOGOFF () Disconnect Database Connection Class C_ORA_DB {Variable Definition VAR $ C_USER = ""; Database User Name VAR $ C_passwd = ""; Database Delivery VAR $ C_DB = ""; Database Name VAR $ I_LINKID = 0; Connection Handle VAR $ I_STMTID = 0; Query Handle VAR $ Color = ""; Global Color Function Name: DB_Logon () Role: Open Database Connection Parameters: None Return Value: Connection Handle (Integer) Note: No function db_logon () {$ this-> i_linkid = @ocilogon ($ this-> c_user, $ this-> c_passwd, $ this-> c_db ); if ($ this-> i_linkid == 0) {alertexit ('database link failed, please contact DBA!');} Return $ this-> i_linkid;} function name: db_query ($ c_sql, $ a_define = " ", $ I_START = -1, $ i_END = -1) Role: SELECT parameter: $ c_sql sql statement $ A_DEFINE The field that needs to be bound. Array type $ i_START Start Take Record -1 All Records $ I_END End Removing Record Return Value: Two-dimensional arrays ($ A_RS) Note: Value of the corresponding fields by numbers 0, 1, 2 .... Value of the corresponding field; Or by querying the field name, you can access the value of the corresponding field, such as by $ A_RS [0] or $ A_RS [0] ['Name'] or $ A_RS [0] ['Name'] can access the first record Name field $ i_start, $ i_end is a parameter that is used in conjunction with the paging.

Function DB_Query ($ C_SQL, $ A_DEFINE = ", $ i_START = -1, $ i_end = -1) {ifrtexit (" Parameter is not full! ");} Check parameter connection detection IF ($ THIS -> i_linkid == 0) {Alertexit ('Database link failed, please contact DBA!');} Format Detection $ this -> i_stmtid = ociparse ($ this -> i_linkid, $ c_sql); if (! $ This - > I_stmtid) {Alertexit ('sql format error! Please contact the programmer');} If you do not specify a binding field, get if IF ($ A_DEFINE == ") {$ A_CUR = EXPLode from the SQL statement ($ A_DEFINE ==") {$ A_CUR = EXPLODE "SELECT", $ c_sql); $ A_CUR = EXPLODE ("from", $ A_CUR [1]); $ A_DEFINE = EXPLODE (",", $ A_CUR [0]);} Binding Database Table field IF (GetType $ A_define) == "Array") Query columns are array {for ($ i = 0; $ I i_stmtid, "$ A_DEFINE_UP [$ I]", & $$ a_define [$ I]); Bind}} elseif (Trim ($ A_DEFINE) <> "" Query columns only one {$ A_DEFINE_UP = TRIM (STRTOUPPER ($ A_DEFINE)); OCIDEFINENAME ($ this -> i_stmtid, "$ A_DEFINE_UP ", & $$ a_define);} Perform a binding SQL statement if (! OCIEXECUTE ($ this -> i_stmtid) {echo" Perform error: SQL Error: $ c_sql
; return false; } $ loc = 0; return to the first dimension of the two-dimensional array to control the variable $ CNT = 0; start to extract the logo Record While (OCIFETCHINTO ($ this -> i_stmtid, & $ cur, oci_assoc) {Take the query out All records IF ($ i_start == -1) {if (GetType ($ A_DEFINE) == "Array") Query Column is an array {for ($ i = 0; $ I $$ a_define [$ I] = $ CUR [$ A_DEFINE_UP [$ I]];} $ A_RS [$ LOWER] [$ I] = $$ a_define [$ I];