Bug #13133: Get longbinary data from ACCESS
| From: | rossati at libero dot it | Date: | Tue, 04 Sep 2001 15:08:26 +0000 |
| Subject: | Bug #13133: Get longbinary data from ACCESS | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-65056@lists.php.net to get a copy of this message | ||
From: rossati@libero.it
Operating system: W98 ME
PHP version: 4.0.4pl1
PHP Bug Type: ODBC related
Bug description: Get longbinary data from ACCESS
LongBinary data from ACCESS.
I receive 2 bytes for every byte of data, one is &h00.
<?php
$SceltaOggetto = "GIRASOLE";
$db=odbc_connect("CISTERNA","","");
$Where = "NCTN = '".$SceltaOggetto."'";
// cerco immagine ed eventualmente la scrivo
$SQL="SELECT IMMAGINE,DIMENSIONE FROM IMMAGINI WHERE ".$Where;
$resImg=odbc_exec($db,$SQL);
if (odbc_fetch_row ($resImg) == TRUE):
odbc_binmode ($resImg,ODBC_BINMODE_PASSTHRU);
$Dimensione = odbc_result($resImg,2); // ll immagine
echo "<BR>Dimensione: ".$Dimensione."<BR>";
$NomeFile = $SceltaOggetto.".jpg";
unlink($NomeFile); // scancello
if (file_exists($NomeFile) == FALSE):
odbc_longreadlen ($resImg,$Dimensione);
$graf = odbc_result($resImg,1);
echo "Lungore ".strlen($graf);
$fp = fopen ($NomeFile, "wb");
fwrite($fp,$graf,$Dimensione);
echo "<BR>ECHO<BR><BR>".$graf;
fclose($fp);
endif;
endif;
?>
--
Edit bug report at: http://bugs.php.net/?id=13133&edit=1