From:             [EMAIL PROTECTED]
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


-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to