cubrid_lob2_read(3) [php man page]

CUBRID_LOB2_READ(3)							 1						       CUBRID_LOB2_READ(3)

cubrid_lob2_read - Read from BLOB/CLOB data.

SYNOPSIS

       string cubrid_lob2_read (resource  $lob_identifier, int	$len)

DESCRIPTION

	The cubrid_lob2_read(3) function reads $len bytes from the LOB data and returns the bytes read.

PARAMETERS

	      o $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 VALUES

	Returns the contents as a string.

       FALSE when there is no more data.

	NULL on failure.

EXAMPLES

       Example #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 ALSO

       cubrid_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)

CUBRID_REAL_ESCAPE_STRING(3)						 1					      CUBRID_REAL_ESCAPE_STRING(3)

cubrid_real_escape_string - Escape special characters in a string for use in an SQL statement

SYNOPSIS

       string cubrid_real_escape_string (string  $unescaped_string, [resource  $conn_identifier])

DESCRIPTION

	This  function returns the escaped string version of the given string. It will escape the following characters: '. In general, single quo-
       tations are used to enclose character string. Double quotations may be used as well depending on the  value  of	ansi_quotes,  which  is  a
       parameter  related  to  SQL  statement. If the ansi_quotes value is set to no, character string enclosed by double quotations is handled as
       character string, not as an identifier. The default value is yes. If you want to include a single quote as  part  of  a	character  string,
       enter two single quotes in a row.

PARAMETERS

	      o $unescaped_string
		-The string that is to be escaped.

	      o $conn_identifier
		-  The	CUBRID	connection.  If  the  connection  identifier  is not specified, the last connection opened by cubrid_connect(3) is
		assumed.

RETURN VALUES

	Escaped string version of the given string, on success.

       FALSE on failure.

EXAMPLES

       Example #1

	      cubrid_real_escape_string(3) example

	      <?php
	      $conn = cubrid_connect("localhost", 33000, "demodb");

	      $unescaped_str = ' !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[]^_`abcdefghijklmnopqrstuvwxyz{|}~';
	      $escaped_str = cubrid_real_escape_string($unescaped_str);

	      $len = strlen($unescaped_str);

	      @cubrid_execute($conn, "DROP TABLE cubrid_test");
	      cubrid_execute($conn, "CREATE TABLE cubrid_test (t char($len))");
	      cubrid_execute($conn, "INSERT INTO cubrid_test (t) VALUES('$escaped_str')");

	      $req = cubrid_execute($conn, "SELECT * FROM cubrid_test");
	      $row = cubrid_fetch_assoc($req);

	      var_dump($row);

	      cubrid_close_request($req);
	      cubrid_disconnect($conn);
	      ?>

	      The above example will output:

	      array(1) {
		["t"]=>
		string(95) " !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[]^_`abcdefghijklmnopqrstuvwxyz{|}~"
	      }

PHP Documentation Group 											      CUBRID_REAL_ESCAPE_STRING(3)