Php/docs/function.fbsql-create-clob

• PHP Manual
• FrontBase 函数
• Create a CLOB

fbsql_create_clob

(PHP 4 >= 4.2.0, PHP 5 < 5.3.0)

fbsql_create_clob — Create a CLOB

说明

fbsql_create_clob ( string $clob_data [, resource $link_identifier ] ) : string

Creates a CLOB from the given data.

参数

clob_data

The CLOB data.

link_identifier

由 fbsql_connect() 或 fbsql_pconnect() 返回的 FrontBase 链接标识符.

如可选并未指定，函数会尝试查找一个到 FrontBase 服务器的开放链接，且如没有找到这样的链接，会尝试通过不带参数调用 fbsql_connect() 来创建一个。

返回值

Returns a resource handle to the newly created CLOB, which can be used with insert and update commands to store the CLOB in the database.

范例

Example #1 fbsql_create_clob() example

<?php$link = fbsql_pconnect("localhost", "_SYSTEM", "secret")    or die("Could not connect");$filename = "clob_file.txt";$fp = fopen($filename, "rb");$clobdata = fread($fp, filesize($filename));fclose($fp);$clobHandle = fbsql_create_clob($clobdata, $link);$sql = "INSERT INTO CLOB_TABLE (CLOB_COLUMN) VALUES ($clobHandle);";$rs = fbsql_query($sql, $link);?>

参见

• fbsql_create_blob() - Create a BLOB
• fbsql_read_blob() - Read a BLOB from the database
• fbsql_read_clob() - Read a CLOB from the database
• fbsql_set_lob_mode() - Set the LOB retrieve mode for a FrontBase result set