PHP:oci_bind_by_name()的用法_Oracle函数

oci_bind_by_name

推荐整理分享PHP:oci_bind_by_name()的用法_Oracle函数，希望有所帮助，仅作参考，欢迎阅读内容。

文章相关热门搜索词:,内容如对您有帮助，希望把文章链接给更多的朋友！

(PHP 5, PECL OCI8 >= 1.1.0)

oci_bind_by_name — 绑定一个 PHP 变量到一个 Oracle 位置标志符

说明 bool oci_bind_by_name ( resource $stmt , string $ph_name , mixed &$variable [, int $maxlength [, int $type ]] )

oci_bind_by_name() 将 PHP 变量 variable 绑定到 Oracle 的位置标志符 ph_name。该变量是否会被用作输入输出是在运行时决定的，并且函数给该变量分配必要的存储空间。length 参数确定该绑定的最大长度，如果将 length 设为 -1，oci_bind_by_name() 会用 variable 变量的当前长度确定绑定的最大长度。

如果要绑定一个抽象数据类型（LOB/ROWID/BFILE），需要先用 oci_new_descriptor() 函数分配空间。length 没有用于抽象数据类型，应被设为 -1。type 参数告诉 Oracle 要使用什么样的描述符。可能的值为：

SQLT_FILE - 对应于 BFILE；

SQLT_CFILE - 对应于 CFILE；

SQLT_CLOB - 对应于 CLOB；

SQLT_BLOB - 对应于 BLOB；

SQLT_ROWID - 对应于 ROWID；

SQLT_NTY - 对应于有名字的数据类型；

SQLT_INT - 对应于 integers；

SQLT_CHR - 对应于 VARCHARs；

SQLT_BIN - 对应于 RAW 列；

SQLT_LNG - 对应于 LONG 列；

SQLT_LBI - 对应于 LONG RAW 列；

SQLT_RSET - 对应于游标，是之前由 oci_new_cursor() 创建的。

Example #1 oci_bind_by_name() 例子

<?php/*oci_bind_by_nameexamplethiesatthiesodotnet()inserts3recordsintoemp,andusestheROWIDforupdatingtherecordsjustaftertheinsert.*/$conn=oci_connect("scott","tiger");$stmt=oci_parse($conn,"INSERTINTOemp(empno,ename)VALUES(:empno,:ename)RETURNINGROWIDINTO:rid");$data=array(=>"Larry",=>"Bill",=>"Jim");$rowid=oci_new_descriptor($conn,OCI_D_ROWID);oci_bind_by_name($stmt,":empno",$empno,);oci_bind_by_name($stmt,":ename",$ename,);oci_bind_by_name($stmt,":rid",$rowid,-1,OCI_B_ROWID);$update=oci_parse($conn,"UPDATEempSETsal=:salWHEREROWID=:rid");oci_bind_by_name($update,":rid",$rowid,-1,OCI_B_ROWID);oci_bind_by_name($update,":sal",$sal,);$sal=;foreach($dataas$empno=>$ename){oci_execute($stmt);oci_execute($update);}$rowid->free();oci_free_statement($update);oci_free_statement($stmt);$stmt=oci_parse($conn,"SELECT*FROMempWHEREempnoIN(,,)");oci_execute($stmt);while($row=oci_fetch_assoc($stmt)){var_dump($row);}oci_free_statement($stmt);/*deleteour"junk"fromtheemptable....*/$stmt=oci_parse($conn,"DELETEFROMempWHEREempnoIN(,,)");oci_execute($stmt);oci_free_statement($stmt);oci_close($conn);?>

记住，本函数删除了行尾的空白字符。见以下例子：

Example #2 oci_bind_by_name() 例子

<?php$connection=oci_connect('apelsin','kanistra');$query="INSERTINTOtest_tableVALUES(:id,:text)";$statement=oci_parse($query);oci_bind_by_name($statement,":id",1);oci_bind_by_name($statement,":text","trailingspacesfollow");oci_execute($statement);/*ThiscodewillinsertintoDBstring'trailingspacesfollow',withouttrailingspaces*/?>

Example #3 oci_bind_by_name() 例子

<?php$connection=oci_connect('apelsin','kanistra');$query="INSERTINTOtest_tableVALUES(:id,'trailingspacesfollow')";$statement=oci_parse($query);oci_bind_by_name($statement,":id",1);oci_execute($statement);/*Andthiscodewilladd'trailingspacesfollow',preservingtrailingwhitespaces*/?>

Warning

不要将 magic_quotes_gpc 或 addslashes() 与 oci_bind_by_name() 同时使用，因为不需要转义，任何自动加上的引号都会被写入数据库中，因为 oci_bind_by_name() 不能分辨有意加上的引号和魔术引号。

成功时返回 TRUE， 或者在失败时返回 FALSE。

Note:

在 PHP 5.0.0 之前的版本必须使用 ocibindbyname() 替代本函数。该函数名仍然可用，为向下兼容作为 oci_bind_by_name() 的别名。不过其已被废弃，不推荐使用。

参数

statement

A valid OCI8 statement identifer.

bv_name

The colon-prefixed bind variable placeholder used in the statement. The colon is optional in bv_name. Oracle does not use question marks for placeholders.

variable

The PHP variable to be associated with bv_name

maxlength

Sets the maximum length for the data. If you set it to -1, this function will use the current length of variable to set the maximum length. In this case the variable must exist and contain data when oci_bind_by_name() is called.

type

The datatype that Oracle will treat the data as. The default type used is SQLT_CHR. Oracle will convert the data between this type and the database column (or PL/SQL variable type), when possible.

If you need to bind an abstract datatype (LOB/ROWID/BFILE) you need to allocate it first using the oci_new_descriptor() function. The length is not used for abstract datatypes and should be set to -1.

Possible values for type are:

SQLT_BFILEE or OCI_B_BFILE - for BFILEs;

SQLT_CFILEE or OCI_B_CFILEE - for CFILEs;

SQLT_CLOB or OCI_B_CLOB - for CLOBs;

SQLT_BLOB or OCI_B_BLOB - for BLOBs;

SQLT_RDD or OCI_B_ROWID - for ROWIDs;

SQLT_NTY or OCI_B_NTY - for named datatypes;

SQLT_INT or OCI_B_INT - for integers;

SQLT_CHR - for VARCHARs;

SQLT_BIN or OCI_B_BIN - for RAW columns;

SQLT_LNG - for LONG columns;

SQLT_LBI - for LONG RAW columns;

SQLT_RSET - for cursors created with oci_new_cursor().

返回值

成功时返回 TRUE， 或者在失败时返回 FALSE。

范例

Example #4 Inserting data with oci_bind_by_name()

<?php//

Example #5 Binding once for multiple executions

<?php//

Example #6 Binding with a foreach() loop

<?php$conn=oci_connect('hr','welcome','localhost/XE');if(!$conn){$m=oci_error();trigger_error(htmlentities($m['message']),E_USER_ERROR);}$sql='SELECT*FROMdepartmentsWHEREdepartment_name=:dnameANDlocation_id=:loc';$stid=oci_parse($conn,$sql);$ba=array(':dname'=>'ITSupport',':loc'=>);foreach($baas$key=>$val){//oci_bind_by_name($stid,$key,$val)doesnotwork//becauseitbindseachplaceholdertothesamelocation:$val//insteadusetheactuallocationofthedata:$ba[$key]oci_bind_by_name($stid,$key,$ba[$key]);}oci_execute($stid);$row=oci_fetch_array($stid,OCI_ASSOC+OCI_RETURN_NULLS);foreach($rowas$item){print$item."<br>n";}oci_free_statement($stid);oci_close($conn);?>

Example #7 Binding in a WHERE clause

<?php$conn=oci_connect("hr","hrpwd","localhost/XE");if(!$conn){$m=oci_error();trigger_error(htmlentities($m['message']),E_USER_ERROR);}$sql='SELECTlast_nameFROMemployeesWHEREemployee_id=:eidbv';$stid=oci_parse($conn,$sql);$myeid=;oci_bind_by_name($stid,':eidbv',$myeid);oci_execute($stid);$row=oci_fetch_array($stid,OCI_ASSOC);echo$row['LAST_NAME']."<br>n";//Outputis//Kochharoci_free_statement($stid);oci_close($conn);?>

Example #8 Binding with a LIKE clause

<?php$conn=oci_connect('hr','welcome','localhost/XE');if(!$conn){$m=oci_error();trigger_error(htmlentities($m['message']),E_USER_ERROR);}//Findallcitiesthatbeginwith'South'$stid=oci_parse($conn,"SELECTcityFROMlocationsWHEREcityLIKE:bv");$city='South%';//'%'isawildcardinSQLoci_bind_by_name($stid,":bv",$city);oci_execute($stid);oci_fetch_all($stid,$res);foreach($res['CITY']as$c){print$c."<br>n";}//Outputis//SouthBrunswick//SouthSanFrancisco//Southlakeoci_free_statement($stid);oci_close($conn);?>

Example #9 Binding with REGEXP_LIKE

<?php$conn=oci_connect('hr','welcome','localhost/XE');if(!$conn){$m=oci_error();trigger_error(htmlentities($m['message']),E_USER_ERROR);}//Findallcitiesthatcontain'ing'$stid=oci_parse($conn,"SELECTcityFROMlocationsWHEREREGEXP_LIKE(city,:bv)");$city='.*ing.*';oci_bind_by_name($stid,":bv",$city);oci_execute($stid);oci_fetch_all($stid,$res);foreach($res['CITY']as$c){print$c."<br>n";}//Outputis//Beijing//Singaporeoci_free_statement($stid);oci_close($conn);?>

For a small, fixed number of IN clause conditions, use individual bind variables. Values unknown at run time can be set to NULL. This allows a single statement to be used by all application users, maximizing Oracle DB cache efficiency.

Example # Binding Multiple Values in an IN Clause

<?php$conn=oci_connect('hr','welcome','localhost/XE');if(!$conn){$m=oci_error();trigger_error(htmlentities($m['message']),E_USER_ERROR);}$sql='SELECTlast_nameFROMemployeesWHEREemployee_idin(:e1,:e2,:e3)';$stid=oci_parse($conn,$sql);$mye1=;$mye2=;$mye3=NULL;//pretendwewerenotgiventhisvalueoci_bind_by_name($stid,':e1',$mye1);oci_bind_by_name($stid,':e2',$mye2);oci_bind_by_name($stid,':e3',$mye3);oci_execute($stid);oci_fetch_all($stid,$res);foreach($res['LAST_NAME']as$name){print$name."<br>n";}//Outputis//Ernst//Hunoldoci_free_statement($stid);oci_close($conn);?>

Example # Binding a ROWID returned by a query

<?php//

Example # Binding a ROWID on INSERT

<?php//Thisexampleinsertsanid&name,andthenupdatesthesalary//

Example # Binding for a PL/SQL stored function

<?php//BeforerunningthePHPprogram,createastoredfunctionin//SQL*

Example # Binding parameters for a PL/SQL stored procedure

<?php//BeforerunningthePHPprogram,createastoredprocedurein//SQL*

Example # Binding a CLOB column

<?php//Beforerunning,

返回值

成功时返回 TRUE， 或者在失败时返回 FALSE。

注释 Warning

Do not use magic_quotes_gpc or addslashes() and oci_bind_by_name() simultaneously as no quoting is needed. Any magically applied quotes will be written into your database because oci_bind_by_name() inserts data verbatim and does not remove quotes or escape characters.

Note:

If you bind a string to a CHAR column in a WHERE clause, remember that Oracle uses blank-padded comparison semantics for CHAR columns. Your PHP variable should be blank padded to the same width as the column for the WHERE clause to succeed.

Note:

The PHP variable argument is a reference. Some forms of loops do not work as expected:

<?phpforeach($myarrayas$key=>$value){oci_bind_by_name($stid,$key,$value);}?>

This binds each key to the location of $value, so all bound variables end up pointing to the last loop iteration&#;s value. Instead use the following:

<?phpforeach($myarrayas$key=>$value){oci_bind_by_name($stid,$key,$myarray[$key]);}?>

Note:

In PHP versions before 5.0.0 you must use ocibindbyname() instead. 在当前版本中，旧的函数名还可以被使用，但已经被废弃并不建议使用。

参见

oci_bind_array_by_name() - Binds a PHP array to an Oracle PL/SQL array parameter oci_parse() - 配置 Oracle 语句预备执行

PHP:oci_define_by_name()的用法_Oracle函数 oci_define_by_name(PHP5,PECLOCI8=1.1.0)oci_define_by_name在SELECT中使用PHP变量作为定义的步骤说明booloci_define_by_name(resource$statement,string$column_name,mixed&$variable[,int$type])o

PHP:oci_client_version()的用法_Oracle函数 oci_client_version(PHP5.3.7,PECLOCI8=1.4.6)oci_client_versionReturnstheOracleclientlibraryversion说明stringoci_client_version(void)ReturnsastringcontainingtheversionnumberoftheOracleCclientlibraryth

PHP:oci_cancel()的用法_Oracle函数 oci_cancel(PHP5,PECLOCI8=1.1.0)oci_cancel中断游标读取数据说明booloci_cancel(resource$statement)oci_cancel()使一个游标无效，释放所有与之关联的资源并取消了从中读取