首页 >函数列表 >fbsql_read_blob

fbsql_read_blob

fbsql_read_blob

(PHP 4 >= 4.2.0, PHP 5)

fbsql_read_blobRead a BLOB from the database

说明

string fbsql_read_blob ( string $blob_handle [, resource $link_identifier ] )

Reads BLOB data from the database.

If a select statement contains BLOB and/or CLOB columns FrontBase will return the data directly when data is fetched. This default behavior can be changed with fbsql_set_lob_mode() so the fetch functions will return handles to BLOB and CLOB data. If a handle is fetched a user must call fbsql_read_blob() to get the actual BLOB data from the database.

参数

blob_handle

A BLOB handle, returned by fbsql_create_blob().

link_identifier

fbsql_connect()fbsql_pconnect() 返回的 FrontBase 链接标识符.

如可选并未指定,函数会尝试查找一个到 FrontBase 服务器的开放链接,且如没有找到这样的链接,会尝试通过不带参数调用 fbsql_connect() 来创建一个。

返回值

Returns a string containing the specified BLOB data.

范例

Example #1 fbsql_read_blob() example

<?php
$link 
fbsql_pconnect("localhost""_SYSTEM""secret")
    or die(
"Could not connect");
$sql "SELECT BLOB_COLUMN FROM BLOB_TABLE;";
$rs fbsql_query($sql$link);
$row_data fbsql_fetch_row($rs);
// $row_data[0] will now contain the blob data for the first row
fbsql_free_result($rs);

$rs fbsql_query($sql$link);
fbsql_set_lob_mode($rsFBSQL_LOB_HANDLE);
$row_data fbsql_fetch_row($rs);
// $row_data[0] will now contain a handle to the BLOB data in the first row
$blob_data fbsql_read_blob($row_data[0]);
fbsql_free_result($rs);

?>

参见


  • fbsql_affected_rows
  • fbsql_autocommit
  • fbsql_blob_size
  • fbsql_change_user
  • fbsql_clob_size
  • fbsql_close
  • fbsql_commit
  • fbsql_connect
  • fbsql_create_blob
  • fbsql_create_clob
  • fbsql_create_db
  • fbsql_database
  • fbsql_database_password
  • fbsql_data_seek
  • fbsql_db_query
  • fbsql_db_status
  • fbsql_drop_db
  • fbsql_errno
  • fbsql_error
  • fbsql_fetch_array
  • fbsql_fetch_assoc
  • fbsql_fetch_field
  • fbsql_fetch_lengths
  • fbsql_fetch_object
  • fbsql_fetch_row
  • fbsql_field_flags
  • fbsql_field_len
  • fbsql_field_name
  • fbsql_field_seek
  • fbsql_field_table
  • fbsql_field_type
  • fbsql_free_result
  • fbsql_get_autostart_info
  • fbsql_hostname
  • fbsql_insert_id
  • fbsql_list_dbs
  • fbsql_list_fields
  • fbsql_list_tables
  • fbsql_next_result
  • fbsql_num_fields
  • fbsql_num_rows
  • fbsql_password
  • fbsql_pconnect
  • fbsql_query
  • fbsql_read_blob
  • fbsql_read_clob
  • fbsql_result
  • fbsql_rollback
  • fbsql_rows_fetched
  • fbsql_select_db
  • fbsql_set_characterset
  • fbsql_set_lob_mode
  • fbsql_set_password
  • fbsql_set_transaction
  • fbsql_start_db
  • fbsql_stop_db
  • fbsql_tablename
  • fbsql_table_name
  • fbsql_username
  • fbsql_warnings
  • PHP MySQL HTML CSS JavaScript MSSQL AJAX .NET JSP Linux Mac ASP 服务器 SQL jQuery C# C++ java Android IOS oracle MongoDB SQLite wamp 交通频道