cubrid_lob2_seek64

cubrid_lob2_seek64

Move the cursor of a lob object

bool **cubrid_lob2_seek64** resource $lob_identifier string $offset int $origin

The function is used to move the cursor position of a lob object by the value set in the argument, to the direction set in the argument. If the you want to move is larger than an integer data can be stored, you can use this function. cubrid_lob2_seek64``offset``origin``offset

To set the argument, you can use to set the cursor position moving forward units from the first beginning. In this case, must be a positive value. origin``CUBRID_CURSOR_FIRST``offset``offset

If you use for , you can move forward or backward. and can be positive or negative. CUBRID_CURSOR_CURRENT``origin``offset

If you use for , you can move backward units from the end of LOB object and only can be positive. CUBRID_CURSOR_LAST``origin``offset``offset

Opmerking: > If you use this function to move the cursor position of the lob object, you should pass as a string. offset

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

offsetNumber of units you want to move the cursor.

originThis parameter can be the following values:

CUBRID_CURSOR_FIRST: move forward from the first beginning.

CUBRID_CURSOR_CURRENT: move forward or backward from the current position.

CUBRID_CURSOR_LAST: move backward at the end of LOB object.

return.success

Voorbeeld: example

<?php
// test_lob (id INT, contents CLOB)
// Data length of doc_1.txt should be greater than 20101029056306120215.

$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);

$req = cubrid_execute($conn, "select * from test_lob");
$row = cubrid_fetch_row($req, CUBRID_LOB);
$lob = $row[1];

cubrid_lob2_seek64($lob, "20101029056306120215", CUBRID_CURSOR_FIRST);
$data = cubrid_lob2_read($lob, 20);
echo $data."\n";
cubrid_disconnect($conn);
?>

cubrid_lob2_read``cubrid_lob2_write``cubrid_lob2_seek``cubrid_lob2_tell``cubrid_lob2_tell64``cubrid_lob2_size``cubrid_lob2_size64