cubrid_lob2_import

(PECL CUBRID >= 8.4.1)

cubrid_lob2_import — Import BLOB/CLOB data from a file

说明

cubrid_lob2_import ( resource $lob_identifier , string $file_name ) : bool

The cubrid_lob2_import() function is used to save the contents of BLOB/CLOB data from a file. To use this function, you must use cubrid_lob2_new() or fetch a lob object from CUBRID database first. If the file already exists, the operation will fail. This function will not influence the cursor position of the lob object. It operates the entire lob object.

参数

lob_identifier

Lob identifier as a result of cubrid_lob2_new() or get from the result set.

filename

File name you want to import BLOB/CLOB data. It also supports the path of the file.

返回值

TRUE if the process is successful and FALSE for failure.

范例

Example #1 cubrid_lob2_export() example

<?php

$conn = cubrid_connect("localhost", 33000, "demodb", "dba", "");

cubrid_execute($conn,"DROP TABLE if exists test_lob");
cubrid_execute($conn,"CREATE TABLE test_lob (id INT, contents CLOB)");
 
$req = cubrid_prepare($conn, "INSERT INTO test_lob VALUES (?, ?)");
cubrid_bind($req, 1, 1);

$lob = cubrid_lob2_new($conn, "clob");
cubrid_lob2_import($lob, "doc_1.txt");
cubrid_lob2_bind($req, 2, $lob, 'CLOB'); // or cubrid_lob2_bind($req, 2, $lob);

cubrid_execute($req);

cubrid_lob2_close($lob);
cubrid_disconnect($conn);
?>

参见

相关文章
php eventbuffer read data from a file onto the end of the bufferphp classkit 函数 import new class method definitions from a filephp cubrid 函数 free the memory occupied by the result dataphp cubrid 过时的别名和函数 read data from a glo instance and save it in a filephp cubrid 函数 close blob/clob dataphp cubrid 函数 export blob/clob data to filephp cubrid 函数 get blob/clob dataphp cubrid 函数 read blob/clob data and send straight to browserphp cubrid 函数 get blob/clob data sizephp cubrid 函数 import blob/clob data from a filephp cubrid 函数 read from blob/clob dataphp cubrid 过时的别名和函数 save requested file in a glo instancephp cubrid 过时的别名和函数 read data from glo and send it to std outputphp firebird/interbase 函数 create a new blob for adding dataphp firebird/interbase 函数 get len bytes data from open blobphp mailparse 函数 streams data from source file pointer apply encoding and write to destfpphp mailparse 函数 scans the data from fp and extract each embedded uuencoded filephp 杂项 函数 unpack data from binary stringphp postgresql pdo copy data from file into tablephp sdo das xml 函数 creates an xml document object from scratch without the need to load a document from a file or string
关注编程学问公众号