Query: cubrid_lob2_read
OS: php
Section: 3
Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar
CUBRID_LOB2_READ(3) 1 CUBRID_LOB2_READ(3) cubrid_lob2_read - Read from BLOB/CLOB data.SYNOPSISstring cubrid_lob2_read (resource $lob_identifier, int $len)DESCRIPTIONThe cubrid_lob2_read(3) function reads $len bytes from the LOB data and returns the bytes read.PARAMETERSo $lob_identifier -Lob identifier as a result of cubrid_lob2_new(3) or get from the result set. o $len -Length from buffer you want to read from the lob data.RETURN VALUESReturns the contents as a string. FALSE when there is no more data. NULL on failure.EXAMPLESExample #1 cubrid_lob2_read(3) example 1 <?php // test_lob (id INT, contents 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]) . " "; cubrid_lob2_seek($row[1], 10, CUBRID_CURSOR_FIRST); print " position after moving farword is " . cubrid_lob2_tell($row[1]) . " "; $data = cubrid_lob2_read($row[1], 12); print " position after reading is " . cubrid_lob2_tell($row[1]) . " "; print $data . " "; cubrid_lob2_seek($row[1], 5, CUBRID_CURSOR_CURRENT); print " position after moving again is " . cubrid_lob2_tell($row[1]) . " "; $data = cubrid_lob2_read($row[1], 20); print $data . " "; cubrid_disconnect($conn); ?> Example #2 cubrid_lob2_read(3) example 2 <?php // test_lob (id INT, contents 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 . " "; } elseif ($data === false) { print "There is no more data "; break; } else { print "There must some errors "; break; } } cubrid_disconnect($conn); ?>SEE ALSOcubrid_lob2_write(3), cubrid_lob2_seek(3), cubrid_lob2_seek64(3), cubrid_lob2_tell(3), cubrid_lob2_tell64(3), cubrid_lob2_size(3), cubrid_lob2_size64(3). PHP Documentation Group CUBRID_LOB2_READ(3)