位置: 编程技术 - 正文

PHP:oci_new_descriptor()的用法_Oracle函数

编辑：rootadmin

oci_new_descriptor

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

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

(PHP 5, PECL OCI8 >= 1.1.0)

oci_new_descriptor — 初始化一个新的空 LOB 或 FILE 描述符

说明 OCI-Lob oci_new_descriptor ( resource $connection [, int $type ] )

oci_new_descriptor() 分配资源以保存描述符或 LOB 定位器。有效的 type 值是：OCI_D_FILE，OCI_D_LOB 以及 OCI_D_ROWID。

PHP:oci_new_descriptor()的用法_Oracle函数

Example #1 oci_new_descriptor() 例子

<?php/*ThisscriptisdesignedtobecalledfromaHTMLform.*Itexpects$user,$password,$table,$where,and$commitsize*tobepassedinfromtheform.Thescriptthendeletes*theselectedrowsusingtheROWIDandcommitsaftereach*setof$commitsizerows.(Usewithcare,thereisnorollback)*/$conn=oci_connect($user,$password);$stmt=oci_parse($conn,"selectrowidfrom$table$where");$rowid=oci_new_descriptor($conn,OCI_D_ROWID);oci_define_by_name($stmt,"ROWID",$rowid);oci_execute($stmt);while(oci_fetch($stmt)){$nrows=oci_num_rows($stmt);$delete=oci_parse($conn,"deletefrom$tablewhereROWID=:rid");oci_bind_by_name($delete,":rid",$rowid,-1,OCI_B_ROWID);oci_execute($delete);echo"$nrowsn";if(($nrows%$commitsize)==0){oci_commit($conn);}}$nrows=oci_num_rows($stmt);echo"$nrowsdeleted...n";oci_free_statement($stmt);oci_close($conn);?><?php/*ThisscriptdemonstratesfileuploadtoLOBcolumns*Theformfieldusedforthisexamplelookslikethis*<formaction="upload.php"method="post"enctype="multipart/form-data">*<inputtype="file"name="lob_upload"/>*...*/if(!isset($lob_upload)||$lob_upload=='none'){?><formaction="upload.php"method="post"enctype="multipart/form-data">Uploadfile:<inputtype="file"name="lob_upload"/><br/><inputtype="submit"value="Upload"/>-<inputtype="reset"value="Reset"/></form><?php}else{//$lob_uploadcontainsthetemporaryfilenameoftheuploadedfile//seealsothefeaturessectiononfileupload,//ifyouwouldliketousesecureuploads$conn=oci_connect($user,$password);$lob=oci_new_descriptor($conn,OCI_D_LOB);$stmt=oci_parse($conn,"insertinto$table(id,the_blob)values(my_seq.NEXTVAL,EMPTY_BLOB())returningthe_blobinto:the_blob");oci_bind_by_name($stmt,':the_blob',$lob,-1,OCI_B_BLOB);oci_execute($stmt,OCI_DEFAULT);if($lob->savefile($lob_upload)){oci_commit($conn);echo"Blobsuccessfullyuploadedn";}else{echo"Couldn'tuploadBlobn";}oci_free_descriptor($lob);oci_free_statement($stmt);oci_close($conn);}?>

Example #2 oci_new_descriptor() 例子

<?php/*CallingPL/SQLstoredprocedureswhichcontainclobsasinput*parameters(PHP4>=4.0.6).*ExamplePL/SQLstoredproceduresignatureis:**PROCEDUREsave_data*ArgumentNameTypeIn/OutDefault?*-------------------------------------------------------------------*KEYNUMBER()IN*DATACLOBIN**/$conn=oci_connect($user,$password);$stmt=oci_parse($conn,"beginsave_data(:key,:data);end;");$clob=oci_new_descriptor($conn,OCI_D_LOB);oci_bind_by_name($stmt,':key',$key);oci_bind_by_name($stmt,':data',$clob,-1,OCI_B_CLOB);$clob->write($data);oci_execute($stmt,OCI_DEFAULT);oci_commit($conn);$clob->free();oci_free_statement($stmt);?>

oci_new_descriptor() 如果出错返回 FALSE。

Note:

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

PHP:oci_num_rows()的用法_Oracle函数 oci_num_rows(PHP5,PECLOCI8=1.1.0)oci_num_rows返回语句执行后受影响的行数说明intoci_num_rows(resource$stmt)oci_num_rows()返回语句执行后受影响的行数。Note:本函数并不返

PHP:oci_internal_debug()的用法_Oracle函数 oci_internal_debug(PHP5,PECLOCI8=1.1.0)oci_internal_debug打开或关闭内部调试输出说明voidoci_internal_debug(int$onoff)oci_internal_debug()打开或关闭内部调试输出。设置onoff为0

PHP:oci_new_connect()的用法_Oracle函数 oci_new_connect(PHP5,PECLOCI8=1.1.0)oci_new_connect建定一个到Oracle服务器的新连接说明resourceoci_new_connect(string$username,string$password[,string$db[,string$charset[,int$session_mode]