fbsql_create_blob

fbsql_create_blob

(PHP 4 >= 4.2.0, PHP 5)

fbsql_create_blob -- Create a BLOB

Description

string fbsql_create_blob ( string blob_data [, resource link_identifier] )

Returns: A resource handle to the newly created blob.

fbsql_create_blob() creates a blob from blob_data. The returned resource handle can be used with insert and update commands to store the blob in the database.

Example 1. fbsql_create_blob() example

<?php
    $link
= fbsql_pconnect("localhost", "_SYSTEM", "secret")
        or die(
"Could not connect");
    
$filename = "blobfile.bin";
    
$fp = fopen($filename, "rb");
    
$blobdata = fread($fp, filesize($filename));
    
fclose($fp);
    
    
$blobHandle = fbsql_create_blob($blobdata, $link);
    
    
$sql = "INSERT INTO BLOB_TABLE (BLOB_COLUMN) VALUES ($blobHandle);";
    
$rs = fbsql_query($sql, $link);
?>

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

© Copyright 2003-2023 www.php-editors.com. The ultimate PHP Editor and PHP IDE site.