note 34507 deleted from function.ibase-blob-echo by alindeman
| From: | alindeman@php.net | Date: | Tue, 29 Jul 2003 15:21:53 +0000 |
| Subject: | note 34507 deleted from function.ibase-blob-echo by alindeman | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-52942@lists.php.net to get a copy of this message | ||
Note Submitter: rjsmoc@hotmail.com
----
sacar texto de un blob:
$lnk = ibase_pconnect($db, $usuario, $clave, $charset, $buffers, $SQLdialect, $role); // conexion
$Q = ibase_query($lnk, 'select PERSONA, OPINION from TABLE'); // OPINION -> blob
subtype text
while ($R=ibase_fetch_object($Q)){
echo "$R->PERSONA<br/>\n";
if ($R->BLOB){
echo "Opina: ";
ibase_blob_echo($R->OPINION);
}else
echo "No opina";
}
ibase_free_result($Q);
----------------------
sacar una foto de un blob:
foto.php:
---
<?php
$lnk = ibase_pconnect($db, $usuario, $clave, $charset, $buffers, $SQLdialect, $role); // conexion
$Q = ibase_query($lnk,"select FOTO from fotos where Codigo = $CODIGO "); // seleccionar
la foto
if ($R = ibase_fetch_object($Q)){ // existe la foto?
if ($R->PE_FOTO)
ibase_blob_echo($R->PE_FOTO); // saca la foto
}
ibase_free_result($Q);
?>
---
llamar con
<img src="foto.php?CODIGO=1" border=0 ... >