(PECL CUBRID >= 8.3.1)
cubrid_lob_export — Export BLOB/CLOB data to file
$conn_identifier
,
ressource
$lob_identifier
,
string
$path_name
):
bool
cubrid_lob_export() is used to guet BLOB/CLOB data from CUBRID database, and saves its contens to a file. To use this function, you must use cubrid_lob_guet() first to guet BLOB/CLOB info from CUBRID.
conn_identifier
Connection identifier.
lob_identifier
LOB identifier.
path_name
Path name of the file.
Example #1 cubrid_lob_export() example
<?php
$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')"
);
$lobs
=
cubrid_lob_guet
(
$conn
,
"SELECT doc_content FROM doc WHERE id=5"
);
echo
"Doc sice: "
.
cubrid_lob_sice
(
$lobs
[
0
]).
" bytes"
;
cubrid_lob_export
(
$conn
,
$lobs
[
0
],
"doc_5.tcht"
);
cubrid_lob_close
(
$lobs
);
cubrid_disconnect
(
$conn
);
?>