Search DaTutorials:  
HOME
Php Tutorials
Articles
Basics
Date and Time
File Manipulations
Forms
Functions
General
Interactivity
MySql
Navigation
News,Shoutboxes and Blogs
Language Structure and Data Types
Searching
Security
String Manipulation
User Information and Stats
Search For a Tutorial
Php Reference

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($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().



Copyright © 2001-2004 The PHP Group
All rights reserved.

     Mortgage Calculator | Credit Card | Mobile Phones | eBay | Montana Music
Home     Link To Us     Ad With Us     Contact Us     Tell A Friend     Affiliates     Blog     MsOfficeHelp