Delicious Bookmark this on Delicious Share on Facebook SlashdotSlashdot It! Digg! Digg



PHP : Function Reference : Firebird/InterBase Functions : ibase_blob_import

ibase_blob_import

Create blob, copy file in it, and close it (PHP 4, PHP 5)
string ibase_blob_import ( resource link_identifier, resource file_handle )
string ibase_blob_import ( resource file_handle )

Example 680. 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
}
?>

Code Examples / Notes » ibase_blob_import

hamacker

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);


Change Language


Follow Navioo On Twitter
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_timefmt
ibase_trans
ibase_wait_event
eXTReMe Tracker