cubrid_lob2_import

cubrid_lob2_import

Import BLOB/CLOB data from a file

bool **cubrid_lob2_import** resource $lob_identifier string $file_name

The function is used to save the contents of BLOB/CLOB data from 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_import``cubrid_lob2_new

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

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

return.success

Voorbeeld: 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);
?>

cubrid_lob2_new``cubrid_lob2_close``cubrid_lob2_export``cubrid_lob2_bind