fbsql_create_clob

(PHP 4 >= 4.2.0, PHP 5)

fbsql_create_clob -- Create a CLOB

Description

string fbsql_create_clob ( string clob_data [, resource link_identifier] )

Returns: A resource handle to the newly created CLOB.

fbsql_create_clob() creates a clob from clob_data. The returned resource handle 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($fpfilesize($filename));
    
fclose($fp);
    
    
$clobHandle fbsql_create_clob($clobdata$link);
    
    
$sql "INSERT INTO CLOB_TABLE (CLOB_COLUMN) VALUES ($clobHandle);";
    
$rs fbsql_query($sql$link);
?>

See also: fbsql_create_blob(), fbsql_read_blob(), fbsql_read_clob(), and fbsql_set_lob_mode().