Query: cubrid_lob2_write
OS: php
Section: 3
Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar
CUBRID_LOB2_WRITE(3) 1 CUBRID_LOB2_WRITE(3) cubrid_lob2_write - Write to a lob object.SYNOPSISbool cubrid_lob2_write (resource $lob_identifier, string $buf)DESCRIPTIONThe cubrid_lob2_write(3) function reads as much as data from $buf and stores it to the LOB object. Note that this function can only append characters now.PARAMETERSo $lob_identifier -Lob identifier as a result of cubrid_lob2_new(3) or get from the result set. o $buf -Data that need to be written to the lob object.RETURN VALUESTRUE if the process is successful and FALSE for failure.EXAMPLESExample #1 cubrid_lob2_write(3) example 1 <?php // test_lob (id INT, contents CLOB) $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(2, ?)"); $lob = cubrid_lob2_new($conn, 'CLOB'); $len = cubrid_lob2_write($lob, "Hello world"); cubrid_lob2_bind($req, 1, $lob); cubrid_execute($req); cubrid_disconnect($conn); ?> Example #2 cubrid_lob2_write(3) example 2 <?php // test_lob (id INT, contents CLOB) $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(1, ?)"); $lob1 = cubrid_lob2_new($conn, 'CLOB'); $len = cubrid_lob2_write($lob1, "cubrid php driver"); cubrid_lob2_bind($req, 1, $lob1); cubrid_execute($req); $req = cubrid_execute($conn, "select * from test_lob"); $row = cubrid_fetch_row($req, CUBRID_LOB); $lob2 = $row[1]; cubrid_lob2_seek($lob2, 0, CUBRID_CURSOR_LAST); $pos = cubrid_lob2_tell($lob2); print "pos before write: $pos "; cubrid_lob2_write($lob2, "Hello world"); $pos = cubrid_lob2_tell($lob2); print "pos after write: $pos "; cubrid_disconnect($conn); ?>SEE ALSOcubrid_lob2_read(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_WRITE(3)
Related Man Pages |
---|
cubrid_put(3) - php |
cubrid_lob2_write(3) - php |
cubrid_affected_rows(3) - php |
cubrid_seq_drop(3) - php |
cubrid_set_add(3) - php |
Similar Topics in the Unix Linux Community |
---|
sort files |
Function extraction in PERL |
Limit on a File size. |
ORA-01756 Error while inserting a file in CLOB field |
How to call stored procedure with CLOB out parameter from shell script? |