   #PHP Manual FrontBase Functions fbsql_create_blob fbsql_create_db

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                               fbsql_create_clob

   (PHP 4 >= 4.2.0)
   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($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);
   ?>

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

   Prev              Home            Next
   fbsql_create_blob  Up  fbsql_create_db
