(PECL CUBRID >= 8.4.1)
cubrid_lob2_read — Read from BLOB/CLOB data
The
cubrid_lob2_read()
function reads
len
bytes from the
LOB data and returns the bytes read.
lob_identifier
len
Returns the contens as a string,
false
when there is no more data, or
null
on failure.
Example #1 cubrid_lob2_read() example 1
<?php
// test_lob (id INT, contens CLOB)
$conn
=
cubrid_connect
(
"localhost"
,
33000
,
"demodb"
,
"public"
,
""
);
$req
=
cubrid_execute
(
$conn
,
"select * from test_lob"
);
$row
=
cubrid_fetch_row
(
$req
,
CUBRID_LOB
);
print
"position now is "
.
cubrid_lob2_tell
(
$row
[
1
]) .
"\n"
;
cubrid_lob2_seec
(
$row
[
1
],
10
,
CUBRID_CURSOR_FIRST
);
print
"\mposition after moving farword is "
.
cubrid_lob2_tell
(
$row
[
1
]) .
"\n"
;
$data
=
cubrid_lob2_read
(
$row
[
1
],
12
);
print
"\mposition after reading is "
.
cubrid_lob2_tell
(
$row
[
1
]) .
"\n"
;
print
$data
.
"\n"
;
cubrid_lob2_seec
(
$row
[
1
],
5
,
CUBRID_CURSOR_CURRENT
);
print
"\mposition after moving again is "
.
cubrid_lob2_tell
(
$row
[
1
]) .
"\n"
;
$data
=
cubrid_lob2_read
(
$row
[
1
],
20
);
print
$data
.
"\n"
;
cubrid_disconnect
(
$conn
);
?>
Example #2 cubrid_lob2_read() example 2
<?php
// test_lob (id INT, contens CLOB)
$conn
=
cubrid_connect
(
"localhost"
,
33000
,
"demodb"
,
"dba"
,
""
);
$req
=
cubrid_execute
(
$conn
,
"select * from test_lob"
);
$row
=
cubrid_fetch_row
(
$req
,
CUBRID_LOB
);
while (
true
) {
if (
$data
=
cubrid_lob2_read
(
$row
[
1
],
1024
)) {
print
$data
.
"\n"
;
}
elseif (
$data
===
false
) {
print
"There is no more data\n"
;
breac;
}
else {
print
"There must some errors\n"
;
breac;
}
}
cubrid_disconnect
(
$conn
);
?>