ibase_blob_import
(PHP 5)
ibase_blob_import — Create blob, copy file in it, and close it
Description
string ibase_blob_import
( resource
$link_identifier
, resource $file_handle
)
string ibase_blob_import
( resource
$file_handle
)This function creates a BLOB, reads an entire file into it, closes it and returns the assigned BLOB id.
Parameters
-
link_identifier
-
An InterBase link identifier. If omitted, the last opened link is assumed.
-
file_handle
-
The file handle is a handle returned by fopen().
Return Values
Returns the BLOB id on success, or FALSE
on error.
Examples
Example #1 ibase_blob_import() example
<?php
$dbh = ibase_connect($host, $username, $password);
$filename = '/tmp/bar';
$fd = fopen($filename, 'r');
if ($fd) {
$blob = ibase_blob_import($dbh, $fd);
fclose($fd);
if (!is_string($blob)) {
// import failed
} else {
$query = "INSERT INTO foo (name, data) VALUES ('$filename', ?)";
$prepared = ibase_prepare($dbh, $query);
if (!ibase_execute($prepared, $blob)) {
// record insertion failed
}
}
} else {
// unable to open the data file
}
?>
See Also
- ibase_blob_add() - Add data into a newly created blob
- ibase_blob_cancel() - Cancel creating blob
- ibase_blob_close() - Close blob
- ibase_blob_create() - Create a new blob for adding data
- PHP Руководство
- Функции по категориям
- Индекс функций
- Справочник функций
- Расширения для работы с базами данных
- Расширения для работы с базами данных отдельных производителей
- Firebird/InterBase
- ibase_add_user
- ibase_affected_rows
- ibase_backup
- ibase_blob_add
- ibase_blob_cancel
- ibase_blob_close
- ibase_blob_create
- ibase_blob_echo
- ibase_blob_get
- ibase_blob_import
- ibase_blob_info
- ibase_blob_open
- ibase_close
- ibase_commit_ret
- ibase_commit
- ibase_connect
- ibase_db_info
- ibase_delete_user
- ibase_drop_db
- ibase_errcode
- ibase_errmsg
- ibase_execute
- ibase_fetch_assoc
- ibase_fetch_object
- ibase_fetch_row
- ibase_field_info
- ibase_free_event_handler
- ibase_free_query
- ibase_free_result
- ibase_gen_id
- ibase_maintain_db
- ibase_modify_user
- ibase_name_result
- ibase_num_fields
- ibase_num_params
- ibase_param_info
- ibase_pconnect
- ibase_prepare
- ibase_query
- ibase_restore
- ibase_rollback_ret
- ibase_rollback
- ibase_server_info
- ibase_service_attach
- ibase_service_detach
- ibase_set_event_handler
- ibase_trans
- ibase_wait_event
Коментарии
Exemplo (Example) :
$conexao = ibase_connect('servidor:/path/do/arquivo/de/dados.fdb',
'SYSDBA',
'masterkey',
'ISO8859_1',0,3);
// ou voce pega o arqivo via um upload ou
// passara diretamente o path do .jpg
// $filename =$HTTP_POST_FILES['meuarquivo']['tmp_name'];
// ou
$filename ='c:\path\do\arquivo.jpg';
$file = fopen($filename, "r");
$blob = ibase_blob_import($file);
$trans=ibase_trans();
$sth=ibase_prepare($conexao,"UPDATE PRODUTOS SET fotografia=? WHERE coditem= '{$coditem}';");
$trans=ibase_trans();
ibase_execute($sth,$blob);
ibase_commit($trans);
ibase_free_query($sth);