cubrid_lob2_export

cubrid_lob2_export

Export the lob object to a file

bool **cubrid_lob2_export** resource $lob_identifier string $file_name

The function is used to save the contents of BLOB/CLOB data to a file. To use this function, you must use 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. cubrid_lob2_export``cubrid_lob2_new

lob_identifierLob identifier as a result of or get from the result set.cubrid_lob2_new

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

return.success

Voorbeeld: example

<?php
// Table: test_lob (id INT, contents CLOB)

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

cubrid_execute($conn,"DROP TABLE if exists doc");
cubrid_execute($conn,"CREATE TABLE doc (id INT, doc_content CLOB)");
cubrid_execute($conn,"INSERT INTO doc VALUES (5,'hello,cubrid')");

$req = cubrid_prepare($conn, "select * from doc");

cubrid_execute($req);

cubrid_move_cursor($req, 1, CUBRID_CURSOR_FIRST);

$row = cubrid_fetch($req, CUBRID_NUM | CUBRID_LOB);

cubrid_lob2_export($row[1], "doc_3.txt");

cubrid_lob2_close($row[1]);
cubrid_disconnect($conn);
?>

cubrid_lob2_new``cubrid_lob2_close``cubrid_lob2_import``cubrid_lob2_bind