PHP : Function Reference : ODBC Functions (Unified) : odbc_binmode PHP Examples Tutorials References

Examples ( Source code ) » odbc_binmode


<?php

    //get a GIF from a database and send it to browser

    //connect to database

    $Connection = odbc_connect("inventory", "admin", "secret");


    //execute query

    $Query = "SELECT Data " .

        "FROM Picture " .

        "WHERE ID=2 ";

    $Result = odbc_do($Connection, $Query);


    //make sure binmode is set for binary pass through

    odbc_binmode($Result, ODBC_BINMODE_PASSTHRU);


    //make sure longreadlen mode

    //is set for echo to browser

    odbc_longreadlen($Result, 0);


    //get the first row, ignore the rest

    odbc_fetch_row($Result);


    //send header so browser knows it's a gif

    header("Content-type: image/gif");


    //get the picture

    odbc_result($Result, 1);

?>

I am currently using an SQL Server 2000 used as a datasource for ODBC access, Testing PHP scripts from an Apache 2 server running on Windows 2000. I was trying to get an image from the database using ODBC but the output always flushes automatically while I was just getting the result using odbc_result() function. With this code, the picture automatically prints to the browser as soon as I hit odbc_result() (probably a bug, but bug reports aren't that easy to do). <?php $connH=odbc_pconnect("ImageDB","sa","",SQL_CUR_USE_IF_NEEDED) or die(odbc_errormsg()); $result=odbc_exec($connH, "SELECT Emp_Image FROM tblEmployeePics WHERE Emp_Id=547"); if ($result) { odbc_longreadlen($result, 131072); odbc_binmode($result,ODBC_BINMODE_PASSTHRU); //upon calling this, the output flushes out to the browser... made me scratch $m_FValue=odbc_result($result, 1); } ?> ...after 48 hours of scratching I finally made a work around, but by using a function in the bin2hex() function documentation... <?php function hex2bin($data){ $len = strlen($data); return pack("H" . $len, $data); } $connH=odbc_pconnect("ImageDB","sa","",SQL_CUR_USE_IF_NEEDED) or die(odbc_errormsg()); $result=odbc_exec($connH, "SELECT Emp_Image FROM tblEmployeePics WHERE Emp_Id=547"); if ($result) { odbc_longreadlen($result, 131072); odbc_binmode($result,ODBC_BINMODE_CONVERT); $m_FValue=odbc_result($result, 1); $out=hex2bin($m_FValue); } ?> The trick was to convert the output into hex by changing odbc_binmode to ODBC_BINMODE_CONVERT and using a handy function to convert it back to binary in order to facilitate manipulation of its size, depth etc...

odbc_binmode

Handling of binary column data (PHP 4, PHP 5)
bool odbc_binmode ( resource result_id, int mode )

Code Examples / Notes » odbc_binmode

Change Language

odbc_binmode

Handling of binary column data (PHP 4, PHP 5) bool odbc_binmode ( resource result_id, int mode )

Code Examples / Notes » odbc_binmode

Change Language

Handling of binary column data (PHP 4, PHP 5)
bool odbc_binmode ( resource result_id, int mode )