fbsql_create_clob
(PHP 4 >= 4.2.0, PHP 5)
fbsql_create_clob — Create a CLOB
설명
string fbsql_create_clob
( string $clob_data
[, resource $link_identifier
] )
Creates a CLOB from the given data.
매개변수
- clob_data
-
The CLOB data.
- link_identifier
-
fbsql_connect()나 fbsql_pconnect()가 반환한 FrontBase 연결 식별자.
반환값
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);
?>